PREVIEW / stock_5min / 2011-07-20

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-07-20.parquet
  size:    4.7 MB
  rows:    320,319
  symbols: 3,532

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
2011-07-20 04:00:00	AAPL	Stock	14.0579	14.0579	13.9646	14.0	46900.0
2011-07-20 04:05:00	AAPL	Stock	14.0	14.025	13.9943	14.0179	28000.0
2011-07-20 04:10:00	AAPL	Stock	14.0046	14.0046	13.9857	13.9964	26600.0
2011-07-20 04:15:00	AAPL	Stock	13.9964	13.9964	13.9964	13.9964	14000.0
2011-07-20 04:20:00	AAPL	Stock	13.9911	13.9911	13.9911	13.9911	16800.0
2011-07-20 04:25:00	AAPL	Stock	13.9911	13.9911	13.9857	13.9893	28000.0
2011-07-20 04:30:00	AAPL	Stock	13.9821	13.9821	13.9821	13.9821	8400.0
2011-07-20 04:35:00	AAPL	Stock	13.9843	13.9843	13.9714	13.9714	39200.0
2011-07-20 04:45:00	AAPL	Stock	13.9725	13.9771	13.9654	13.9768	30520.0
2011-07-20 04:50:00	AAPL	Stock	13.9739	13.9739	13.9643	13.9643	36372.0
2011-07-20 04:55:00	AAPL	Stock	13.95	13.9643	13.95	13.9639	11200.0
2011-07-20 05:00:00	AAPL	Stock	13.9643	13.9643	13.9571	13.9571	19600.0
2011-07-20 05:05:00	AAPL	Stock	13.9643	13.9646	13.9643	13.9646	30800.0
2011-07-20 05:10:00	AAPL	Stock	13.9643	13.9643	13.9464	13.9464	11200.0
2011-07-20 05:15:00	AAPL	Stock	13.9361	13.9361	13.9361	13.9361	2800.0
2011-07-20 05:20:00	AAPL	Stock	13.9575	13.9575	13.9382	13.9382	5600.0
2011-07-20 05:25:00	AAPL	Stock	13.9579	13.9714	13.9521	13.9714	36400.0
2011-07-20 05:30:00	AAPL	Stock	13.9786	13.9786	13.9786	13.9786	13888.0
2011-07-20 05:35:00	AAPL	Stock	13.9889	13.9893	13.9786	13.9786	26712.0
2011-07-20 05:40:00	AAPL	Stock	13.9786	13.9786	13.9786	13.9786	32088.0
2011-07-20 05:45:00	AAPL	Stock	13.9786	13.9786	13.9786	13.9786	2800.0
2011-07-20 05:50:00	AAPL	Stock	13.9868	14.0	13.9868	13.9943	33600.0
2011-07-20 05:55:00	AAPL	Stock	13.9939	14.0111	13.9939	14.0075	109200.0
2011-07-20 06:00:00	AAPL	Stock	14.0071	14.0139	14.0071	14.0136	14000.0
2011-07-20 06:05:00	AAPL	Stock	14.0143	14.0214	14.0132	14.0214	39200.0
2011-07-20 06:10:00	AAPL	Stock	14.0214	14.04	14.0214	14.04	68600.0
2011-07-20 06:15:00	AAPL	Stock	14.0411	14.0411	14.0218	14.0321	22456.0
2011-07-20 06:20:00	AAPL	Stock	14.0357	14.0568	14.0357	14.0568	150640.0
2011-07-20 06:25:00	AAPL	Stock	14.0568	14.1071	14.0568	14.1071	649124.0
2011-07-20 06:30:00	AAPL	Stock	14.1068	14.1107	14.1011	14.1071	215824.0
2011-07-20 06:35:00	AAPL	Stock	14.1071	14.125	14.1071	14.1071	139972.0
2011-07-20 06:40:00	AAPL	Stock	14.1071	14.1071	14.1071	14.1071	100072.0
2011-07-20 06:45:00	AAPL	Stock	14.1075	14.1104	14.1071	14.1071	156800.0
2011-07-20 06:50:00	AAPL	Stock	14.1071	14.1143	14.1071	14.1143	30800.0
2011-07-20 06:55:00	AAPL	Stock	14.1154	14.1161	14.1071	14.1071	59920.0
2011-07-20 07:00:00	AAPL	Stock	14.1111	14.125	14.1071	14.1071	292292.0
2011-07-20 07:05:00	AAPL	Stock	14.1136	14.1607	14.1136	14.15	371196.0
2011-07-20 07:10:00	AAPL	Stock	14.1532	14.1679	14.1489	14.1679	748048.0
2011-07-20 07:15:00	AAPL	Stock	14.1679	14.2136	14.1679	14.1929	674548.0
2011-07-20 07:20:00	AAPL	Stock	14.1929	14.2382	14.1929	14.2296	952476.0
2011-07-20 07:25:00	AAPL	Stock	14.2296	14.2296	14.2143	14.2214	288736.0
2011-07-20 07:30:00	AAPL	Stock	14.2196	14.2286	14.2125	14.2211	368200.0
2011-07-20 07:35:00	AAPL	Stock	14.2232	14.25	14.2232	14.2375	447328.0
2011-07-20 07:40:00	AAPL	Stock	14.2429	14.2489	14.2429	14.2432	213136.0
2011-07-20 07:45:00	AAPL	Stock	14.2432	14.2654	14.2429	14.2571	712516.0
2011-07-20 07:50:00	AAPL	Stock	14.2554	14.2643	14.2439	14.2518	396676.0
2011-07-20 07:55:00	AAPL	Stock	14.2479	14.25	14.225	14.2364	547344.0
2011-07-20 08:00:00	AAPL	Stock	14.2364	14.2521	14.1646	14.1868	3612560.0
2011-07-20 08:05:00	AAPL	Stock	14.1821	14.2143	14.1786	14.1911	1029560.0
2011-07-20 08:10:00	AAPL	Stock	14.1911	14.1982	14.1661	14.1714	693252.0

> showing 50 of 320,319 rows — these rows as CSV

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