PREVIEW / stock_30min / 2014-03-21

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-21.parquet
  size:    1.7 MB
  rows:    87,522
  symbols: 3,551

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
2014-03-21 05:00:00	AAPL	Stock	18.9286	18.9286	18.8339	18.8339	57960.0
2014-03-21 06:30:00	AAPL	Stock	18.9171	18.9271	18.9171	18.9271	5600.0
2014-03-21 07:00:00	AAPL	Stock	18.9246	18.9643	18.9246	18.9643	93800.0
2014-03-21 07:30:00	AAPL	Stock	18.9571	18.9604	18.9089	18.9268	122388.0
2014-03-21 08:00:00	AAPL	Stock	18.9279	18.9321	18.9171	18.9321	202020.0
2014-03-21 08:30:00	AAPL	Stock	18.9318	18.9393	18.9118	18.9211	297528.0
2014-03-21 09:00:00	AAPL	Stock	18.9282	19.1129	18.9229	19.0193	4502288.0
2014-03-21 09:30:00	AAPL	Stock	18.9925	19.0625	18.8971	18.8986	76020476.0
2014-03-21 10:00:00	AAPL	Stock	18.8987	18.9182	18.8482	18.8804	18335240.0
2014-03-21 10:30:00	AAPL	Stock	18.8804	18.9196	18.8543	18.9125	11179700.0
2014-03-21 11:00:00	AAPL	Stock	18.9132	18.925	18.8954	18.9214	6890660.0
2014-03-21 11:30:00	AAPL	Stock	18.9218	18.9286	18.8968	18.8996	7374640.0
2014-03-21 12:00:00	AAPL	Stock	18.9011	18.9154	18.8943	18.9032	4785228.0
2014-03-21 12:30:00	AAPL	Stock	18.9032	18.9046	18.8489	18.8511	7903420.0
2014-03-21 13:00:00	AAPL	Stock	18.8511	18.8575	18.8011	18.8196	14320656.0
2014-03-21 13:30:00	AAPL	Stock	18.8143	18.8564	18.8111	18.8375	8740816.0
2014-03-21 14:00:00	AAPL	Stock	18.8393	18.8675	18.8086	18.8107	9144072.0
2014-03-21 14:30:00	AAPL	Stock	18.8107	18.8621	18.7975	18.8486	12666136.0
2014-03-21 15:00:00	AAPL	Stock	18.8482	18.87	18.8229	18.8661	12712056.0
2014-03-21 15:30:00	AAPL	Stock	18.8661	18.9875	18.8557	18.9868	58777572.0
2014-03-21 16:00:00	AAPL	Stock	19.0311	19.06	18.9091	19.0079	69589240.0
2014-03-21 16:30:00	AAPL	Stock	19.0313	19.0352	19.0018	19.0143	5153148.0
2014-03-21 17:00:00	AAPL	Stock	19.0111	19.0311	19.0107	19.0125	1013292.0
2014-03-21 17:30:00	AAPL	Stock	19.0114	19.0311	19.0039	19.0039	338576.0
2014-03-21 18:00:00	AAPL	Stock	19.0046	19.0071	18.9929	19.0071	105784.0
2014-03-21 18:30:00	AAPL	Stock	19.0071	19.0114	19.0071	19.0114	93240.0
2014-03-21 19:00:00	AAPL	Stock	19.0086	19.0107	19.0046	19.009	59388.0
2014-03-21 19:30:00	AAPL	Stock	19.0089	19.0171	19.0089	19.0171	30520.0
2014-03-21 06:30:00	MSFT	Stock	40.34	40.5	40.34	40.5	800.0
2014-03-21 07:00:00	MSFT	Stock	40.55	40.55	40.55	40.55	100.0
2014-03-21 07:30:00	MSFT	Stock	40.56	40.56	40.48	40.48	5145.0
2014-03-21 08:00:00	MSFT	Stock	40.47	40.66	40.47	40.57	6548.0
2014-03-21 08:30:00	MSFT	Stock	40.55	40.6	40.5	40.5	8243.0
2014-03-21 09:00:00	MSFT	Stock	40.52	40.92	40.37	40.72	1352431.0
2014-03-21 09:30:00	MSFT	Stock	40.72	40.94	40.45	40.498	27398204.0
2014-03-21 10:00:00	MSFT	Stock	40.5	40.52	40.06	40.14	6707122.0
2014-03-21 10:30:00	MSFT	Stock	40.135	40.38	40.11	40.315	3940987.0
2014-03-21 11:00:00	MSFT	Stock	40.31	40.36	40.21	40.259	2639766.0
2014-03-21 11:30:00	MSFT	Stock	40.25	40.35	40.25	40.33	1470803.0
2014-03-21 12:00:00	MSFT	Stock	40.33	40.39	40.28	40.37	2007201.0
2014-03-21 12:30:00	MSFT	Stock	40.375	40.4	40.32	40.375	1368744.0
2014-03-21 13:00:00	MSFT	Stock	40.375	40.43	40.303	40.345	2471813.0
2014-03-21 13:30:00	MSFT	Stock	40.341	40.4	40.285	40.35	1749183.0
2014-03-21 14:00:00	MSFT	Stock	40.359	40.43	40.22	40.22	2002943.0
2014-03-21 14:30:00	MSFT	Stock	40.225	40.32	40.165	40.22	3327017.0
2014-03-21 15:00:00	MSFT	Stock	40.21	40.25	40.09	40.23	3062021.0
2014-03-21 15:30:00	MSFT	Stock	40.23	40.29	40.01	40.17	7849131.0
2014-03-21 16:00:00	MSFT	Stock	40.16	40.85	40.15	40.165	7857890.0
2014-03-21 16:30:00	MSFT	Stock	40.166	40.452	40.15	40.452	279983.0
2014-03-21 17:00:00	MSFT	Stock	40.16	40.19	40.16	40.19	2518243.0

> showing 50 of 87,522 rows — these rows as CSV

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