PREVIEW / stock_30min / 2015-07-14

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-14.parquet
  size:    1.6 MB
  rows:    81,812
  symbols: 3,483

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2015-07-14 04:00:00	AAPL	Stock	31.49	31.49	31.42	31.42	13012.0
2015-07-14 04:30:00	AAPL	Stock	31.4525	31.4525	31.4475	31.4475	4164.0
2015-07-14 05:00:00	AAPL	Stock	31.4375	31.4375	31.4375	31.4375	1704.0
2015-07-14 05:30:00	AAPL	Stock	31.4625	31.4625	31.45	31.45	8560.0
2015-07-14 06:00:00	AAPL	Stock	31.45	31.47	31.4275	31.4275	9312.0
2015-07-14 06:30:00	AAPL	Stock	31.4275	31.4575	31.4125	31.415	13440.0
2015-07-14 07:00:00	AAPL	Stock	31.4225	31.4475	31.4125	31.425	31184.0
2015-07-14 07:30:00	AAPL	Stock	31.425	31.425	31.4	31.4125	25316.0
2015-07-14 08:00:00	AAPL	Stock	31.415	31.4625	31.3975	31.45	203984.0
2015-07-14 08:30:00	AAPL	Stock	31.445	31.4525	31.4	31.4025	206304.0
2015-07-14 09:00:00	AAPL	Stock	31.405	31.5125	31.4	31.4675	391360.0
2015-07-14 09:30:00	AAPL	Stock	31.51	31.5375	31.285	31.3238	17788872.0
2015-07-14 10:00:00	AAPL	Stock	31.325	31.4125	31.26	31.4025	13261064.0
2015-07-14 10:30:00	AAPL	Stock	31.4025	31.4275	31.3425	31.385	8867464.0
2015-07-14 11:00:00	AAPL	Stock	31.38	31.475	31.38	31.4175	8011944.0
2015-07-14 11:30:00	AAPL	Stock	31.425	31.5075	31.4125	31.47	6967112.0
2015-07-14 12:00:00	AAPL	Stock	31.4725	31.4775	31.42	31.4575	4958832.0
2015-07-14 12:30:00	AAPL	Stock	31.4575	31.495	31.445	31.4775	4495312.0
2015-07-14 13:00:00	AAPL	Stock	31.4775	31.5425	31.46	31.54	5604192.0
2015-07-14 13:30:00	AAPL	Stock	31.5375	31.575	31.525	31.575	6471576.0
2015-07-14 14:00:00	AAPL	Stock	31.5725	31.5925	31.5412	31.545	5200000.0
2015-07-14 14:30:00	AAPL	Stock	31.545	31.5775	31.5375	31.55	4975716.0
2015-07-14 15:00:00	AAPL	Stock	31.55	31.555	31.4275	31.4475	10097268.0
2015-07-14 15:30:00	AAPL	Stock	31.445	31.45	31.39	31.4025	12374916.0
2015-07-14 16:00:00	AAPL	Stock	31.4005	31.415	31.3635	31.415	8946124.0
2015-07-14 16:30:00	AAPL	Stock	31.4075	31.415	31.405	31.415	18004.0
2015-07-14 17:00:00	AAPL	Stock	31.4125	31.415	31.4025	31.4125	138128.0
2015-07-14 17:30:00	AAPL	Stock	31.41	31.425	31.4025	31.4075	40560.0
2015-07-14 18:00:00	AAPL	Stock	31.4075	31.4175	31.4	31.4175	45040.0
2015-07-14 18:30:00	AAPL	Stock	31.4175	31.42	31.4075	31.4175	33040.0
2015-07-14 19:00:00	AAPL	Stock	31.4175	31.42	31.41	31.415	63840.0
2015-07-14 19:30:00	AAPL	Stock	31.4125	31.4125	31.4	31.41	62268.0
2015-07-14 05:00:00	MSFT	Stock	45.58	45.58	45.5	45.5	1550.0
2015-07-14 06:00:00	MSFT	Stock	45.51	45.51	45.5	45.5	1500.0
2015-07-14 08:00:00	MSFT	Stock	45.54	45.57	45.5	45.5	900.0
2015-07-14 08:30:00	MSFT	Stock	45.47	45.47	45.47	45.47	1300.0
2015-07-14 09:00:00	MSFT	Stock	45.5	45.55	45.5	45.53	699.0
2015-07-14 09:30:00	MSFT	Stock	45.45	45.69	45.31	45.6	2987255.0
2015-07-14 10:00:00	MSFT	Stock	45.62	45.72	45.57	45.635	1396695.0
2015-07-14 10:30:00	MSFT	Stock	45.63	45.72	45.6	45.71	1633484.0
2015-07-14 11:00:00	MSFT	Stock	45.71	45.88	45.705	45.86	2032484.0
2015-07-14 11:30:00	MSFT	Stock	45.86	45.96	45.83	45.83	1398999.0
2015-07-14 12:00:00	MSFT	Stock	45.84	45.89	45.71	45.735	1045490.0
2015-07-14 12:30:00	MSFT	Stock	45.74	45.755	45.63	45.681	798741.0
2015-07-14 13:00:00	MSFT	Stock	45.68	45.735	45.641	45.7	844743.0
2015-07-14 13:30:00	MSFT	Stock	45.7	45.72	45.64	45.7	1034391.0
2015-07-14 14:00:00	MSFT	Stock	45.69	45.78	45.69	45.75	1492531.0
2015-07-14 14:30:00	MSFT	Stock	45.74	45.79	45.68	45.74	1095929.0
2015-07-14 15:00:00	MSFT	Stock	45.74	45.8	45.73	45.77	1064061.0
2015-07-14 15:30:00	MSFT	Stock	45.77	45.79	45.6	45.62	2113296.0

> showing 50 of 81,812 rows — these rows as CSV

> unlock the full archive -- $79 one-time