PREVIEW / stock_5min / 2012-11-09

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-11-09.parquet
  size:    4.8 MB
  rows:    319,827
  symbols: 3,463

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
2012-11-09 04:00:00	AAPL	Stock	19.2054	19.2054	19.1607	19.1607	9016.0
2012-11-09 04:20:00	AAPL	Stock	19.1564	19.1607	19.1564	19.1607	31528.0
2012-11-09 04:25:00	AAPL	Stock	19.1679	19.1679	19.1679	19.1679	2800.0
2012-11-09 04:30:00	AAPL	Stock	19.1696	19.1857	19.1432	19.1786	98000.0
2012-11-09 04:35:00	AAPL	Stock	19.1875	19.1957	19.1875	19.1957	19600.0
2012-11-09 04:40:00	AAPL	Stock	19.1607	19.2143	19.1607	19.2143	28000.0
2012-11-09 04:45:00	AAPL	Stock	19.2143	19.25	19.2107	19.2318	40600.0
2012-11-09 04:55:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	5600.0
2012-11-09 05:00:00	AAPL	Stock	19.2214	19.23	19.2214	19.23	6076.0
2012-11-09 05:05:00	AAPL	Stock	19.2321	19.2321	19.2321	19.2321	5600.0
2012-11-09 05:10:00	AAPL	Stock	19.2411	19.2411	19.2321	19.2321	5600.0
2012-11-09 05:15:00	AAPL	Stock	19.2457	19.25	19.2457	19.25	36652.0
2012-11-09 05:20:00	AAPL	Stock	19.2321	19.2321	19.2214	19.2214	8400.0
2012-11-09 05:40:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	5600.0
2012-11-09 05:45:00	AAPL	Stock	19.2214	19.2214	19.2214	19.2214	5600.0
2012-11-09 05:50:00	AAPL	Stock	19.2214	19.2286	19.2214	19.2286	16800.0
2012-11-09 05:55:00	AAPL	Stock	19.2357	19.2375	19.2143	19.2143	114632.0
2012-11-09 06:10:00	AAPL	Stock	19.2036	19.2036	19.1789	19.1789	46648.0
2012-11-09 06:15:00	AAPL	Stock	19.1789	19.1789	19.1789	19.1789	14000.0
2012-11-09 06:25:00	AAPL	Stock	19.1661	19.1661	19.1661	19.1661	14000.0
2012-11-09 06:35:00	AAPL	Stock	19.1836	19.1836	19.1518	19.1518	25900.0
2012-11-09 06:40:00	AAPL	Stock	19.1518	19.1518	19.1432	19.1518	38500.0
2012-11-09 06:50:00	AAPL	Stock	19.1432	19.1518	19.1432	19.1518	53452.0
2012-11-09 06:55:00	AAPL	Stock	19.1786	19.1786	19.1786	19.1786	2800.0
2012-11-09 07:00:00	AAPL	Stock	19.1571	19.1596	19.1236	19.1429	40544.0
2012-11-09 07:05:00	AAPL	Stock	19.1429	19.165	19.1425	19.1607	140504.0
2012-11-09 07:10:00	AAPL	Stock	19.15	19.1596	19.1482	19.1596	16800.0
2012-11-09 07:15:00	AAPL	Stock	19.1464	19.1464	19.1186	19.1307	30520.0
2012-11-09 07:20:00	AAPL	Stock	19.1257	19.1429	19.115	19.1254	99232.0
2012-11-09 07:25:00	AAPL	Stock	19.1407	19.1589	19.1336	19.15	126028.0
2012-11-09 07:30:00	AAPL	Stock	19.1429	19.1507	19.1204	19.1239	85176.0
2012-11-09 07:35:00	AAPL	Stock	19.1218	19.1318	19.1086	19.1132	156380.0
2012-11-09 07:40:00	AAPL	Stock	19.1114	19.1386	19.1086	19.1371	119532.0
2012-11-09 07:45:00	AAPL	Stock	19.1339	19.1339	19.1107	19.115	209384.0
2012-11-09 07:50:00	AAPL	Stock	19.1118	19.1386	19.1118	19.1386	67480.0
2012-11-09 07:55:00	AAPL	Stock	19.1375	19.1404	19.1096	19.1246	231000.0
2012-11-09 08:00:00	AAPL	Stock	19.125	19.1529	19.0536	19.0543	1072148.0
2012-11-09 08:05:00	AAPL	Stock	19.0607	19.0857	19.0579	19.0821	1142876.0
2012-11-09 08:10:00	AAPL	Stock	19.0821	19.0871	19.0489	19.0596	788676.0
2012-11-09 08:15:00	AAPL	Stock	19.0575	19.1054	19.05	19.1046	636832.0
2012-11-09 08:20:00	AAPL	Stock	19.1046	19.1379	19.1018	19.1314	614740.0
2012-11-09 08:25:00	AAPL	Stock	19.1246	19.1596	19.1229	19.1475	775460.0
2012-11-09 08:30:00	AAPL	Stock	19.15	19.2264	19.1464	19.2143	1833972.0
2012-11-09 08:35:00	AAPL	Stock	19.2146	19.2589	19.2143	19.2289	667800.0
2012-11-09 08:40:00	AAPL	Stock	19.2257	19.25	19.2214	19.225	606508.0
2012-11-09 08:45:00	AAPL	Stock	19.2279	19.2279	19.19	19.2089	602952.0
2012-11-09 08:50:00	AAPL	Stock	19.2021	19.2121	19.1896	19.1896	287196.0
2012-11-09 08:55:00	AAPL	Stock	19.1907	19.2304	19.1907	19.225	477372.0
2012-11-09 09:00:00	AAPL	Stock	19.2232	19.3689	19.2218	19.3393	1791048.0
2012-11-09 09:05:00	AAPL	Stock	19.3479	19.4111	19.3211	19.3536	2312380.0

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

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