PREVIEW / stock_5min / 2013-05-03

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-05-03.parquet
  size:    5.1 MB
  rows:    338,012
  symbols: 3,509

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
2013-05-03 04:00:00	AAPL	Stock	15.9643	15.9643	15.9643	15.9643	2800.0
2013-05-03 04:10:00	AAPL	Stock	15.9643	15.9643	15.9643	15.9643	2800.0
2013-05-03 04:20:00	AAPL	Stock	15.9661	15.9661	15.9661	15.9661	2800.0
2013-05-03 04:45:00	AAPL	Stock	15.985	15.985	15.9821	15.9821	9044.0
2013-05-03 05:05:00	AAPL	Stock	15.9696	15.9696	15.9643	15.9643	5600.0
2013-05-03 05:10:00	AAPL	Stock	15.9643	15.9643	15.9643	15.9643	2800.0
2013-05-03 05:20:00	AAPL	Stock	15.9643	15.9643	15.9571	15.9571	5600.0
2013-05-03 07:00:00	AAPL	Stock	15.9654	15.9654	15.9429	15.9429	8400.0
2013-05-03 07:05:00	AAPL	Stock	15.9636	15.9636	15.9604	15.9604	8400.0
2013-05-03 07:15:00	AAPL	Stock	15.9721	15.9732	15.9721	15.9732	30800.0
2013-05-03 07:20:00	AAPL	Stock	15.9786	15.9786	15.9643	15.9643	49308.0
2013-05-03 07:25:00	AAPL	Stock	15.9639	15.9639	15.9561	15.9561	8400.0
2013-05-03 07:35:00	AAPL	Stock	15.9643	15.9643	15.9518	15.9518	14000.0
2013-05-03 07:40:00	AAPL	Stock	15.9464	15.955	15.9407	15.955	12180.0
2013-05-03 07:45:00	AAPL	Stock	15.9543	15.9643	15.9543	15.9571	34272.0
2013-05-03 07:50:00	AAPL	Stock	15.9464	15.9464	15.9464	15.9464	13160.0
2013-05-03 07:55:00	AAPL	Stock	15.9464	15.9464	15.9464	15.9464	2800.0
2013-05-03 08:00:00	AAPL	Stock	15.9364	15.9786	15.9286	15.9329	226604.0
2013-05-03 08:05:00	AAPL	Stock	15.9404	15.9454	15.9339	15.9429	73612.0
2013-05-03 08:10:00	AAPL	Stock	15.9368	15.9368	15.92	15.9357	267456.0
2013-05-03 08:15:00	AAPL	Stock	15.9375	15.9468	15.9329	15.9329	118272.0
2013-05-03 08:20:00	AAPL	Stock	15.9293	15.9329	15.9239	15.9239	74900.0
2013-05-03 08:25:00	AAPL	Stock	15.925	15.9371	15.925	15.9286	67032.0
2013-05-03 08:30:00	AAPL	Stock	15.9357	16.0439	15.9357	16.0361	1515080.0
2013-05-03 08:35:00	AAPL	Stock	16.0379	16.0518	16.0268	16.0464	789124.0
2013-05-03 08:40:00	AAPL	Stock	16.0464	16.0643	16.0396	16.0571	791952.0
2013-05-03 08:45:00	AAPL	Stock	16.0489	16.065	16.0489	16.0554	255920.0
2013-05-03 08:50:00	AAPL	Stock	16.0607	16.075	16.0564	16.0632	840280.0
2013-05-03 08:55:00	AAPL	Stock	16.0643	16.0871	16.0639	16.0804	1042636.0
2013-05-03 09:00:00	AAPL	Stock	16.0679	16.0814	16.0679	16.0814	456596.0
2013-05-03 09:05:00	AAPL	Stock	16.0836	16.0964	16.0814	16.0889	613816.0
2013-05-03 09:10:00	AAPL	Stock	16.0875	16.1107	16.0868	16.1032	893564.0
2013-05-03 09:15:00	AAPL	Stock	16.1043	16.115	16.1029	16.1104	583632.0
2013-05-03 09:20:00	AAPL	Stock	16.1075	16.1161	16.1032	16.1146	488684.0
2013-05-03 09:25:00	AAPL	Stock	16.1139	16.1196	16.1054	16.1171	814072.0
2013-05-03 09:30:00	AAPL	Stock	16.1125	16.1743	16.09	16.1603	28567140.0
2013-05-03 09:35:00	AAPL	Stock	16.1604	16.1857	16.1232	16.1529	17168172.0
2013-05-03 09:40:00	AAPL	Stock	16.1503	16.1868	16.1379	16.1596	12745964.0
2013-05-03 09:45:00	AAPL	Stock	16.157	16.1639	16.1189	16.1375	11425176.0
2013-05-03 09:50:00	AAPL	Stock	16.133	16.1529	16.1262	16.1264	8429484.0
2013-05-03 09:55:00	AAPL	Stock	16.1264	16.1439	16.1007	16.1121	8269128.0
2013-05-03 10:00:00	AAPL	Stock	16.1125	16.1189	16.0539	16.0618	14882784.0
2013-05-03 10:05:00	AAPL	Stock	16.0618	16.0971	16.0607	16.0941	7810432.0
2013-05-03 10:10:00	AAPL	Stock	16.0946	16.125	16.0921	16.1018	7799680.0
2013-05-03 10:15:00	AAPL	Stock	16.1034	16.1239	16.0739	16.0787	5884340.0
2013-05-03 10:20:00	AAPL	Stock	16.0786	16.1071	16.0786	16.0977	4339160.0
2013-05-03 10:25:00	AAPL	Stock	16.0968	16.1143	16.0839	16.0994	4306484.0
2013-05-03 10:30:00	AAPL	Stock	16.1025	16.1339	16.0999	16.1232	6464024.0
2013-05-03 10:35:00	AAPL	Stock	16.1236	16.1286	16.0989	16.1029	4058964.0
2013-05-03 10:40:00	AAPL	Stock	16.1044	16.1229	16.0989	16.1179	4894540.0

> showing 50 of 338,012 rows — these rows as CSV

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