PREVIEW / stock_5min / 2011-05-31

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-05-31.parquet
  size:    5.2 MB
  rows:    348,485
  symbols: 3,570

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-05-31 04:00:00	AAPL	Stock	12.0714	12.0714	12.0714	12.0714	17584.0
2011-05-31 04:15:00	AAPL	Stock	12.1407	12.1407	12.1407	12.1407	2800.0
2011-05-31 04:25:00	AAPL	Stock	12.1439	12.145	12.1229	12.145	8400.0
2011-05-31 04:30:00	AAPL	Stock	12.1454	12.1454	12.1454	12.1454	2800.0
2011-05-31 04:40:00	AAPL	Stock	12.1489	12.1489	12.1489	12.1489	2800.0
2011-05-31 07:00:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	5600.0
2011-05-31 07:05:00	AAPL	Stock	12.1282	12.145	12.1271	12.1429	159600.0
2011-05-31 07:10:00	AAPL	Stock	12.1425	12.1439	12.1425	12.1429	19600.0
2011-05-31 07:15:00	AAPL	Stock	12.1418	12.1418	12.1357	12.1418	11200.0
2011-05-31 07:20:00	AAPL	Stock	12.1418	12.1429	12.1321	12.1429	110040.0
2011-05-31 07:25:00	AAPL	Stock	12.1429	12.1557	12.1429	12.1546	70140.0
2011-05-31 07:30:00	AAPL	Stock	12.1582	12.175	12.1561	12.1732	61600.0
2011-05-31 07:35:00	AAPL	Stock	12.1732	12.175	12.1614	12.1614	16800.0
2011-05-31 07:40:00	AAPL	Stock	12.1614	12.1614	12.1568	12.1568	11200.0
2011-05-31 07:45:00	AAPL	Stock	12.1482	12.1482	12.1482	12.1482	5600.0
2011-05-31 07:50:00	AAPL	Stock	12.1464	12.1464	12.1411	12.1411	232400.0
2011-05-31 07:55:00	AAPL	Stock	12.1339	12.1339	12.1339	12.1339	16800.0
2011-05-31 08:00:00	AAPL	Stock	12.1293	12.1425	12.1254	12.1393	65996.0
2011-05-31 08:05:00	AAPL	Stock	12.1339	12.1339	12.1286	12.1286	28000.0
2011-05-31 08:10:00	AAPL	Stock	12.1254	12.1321	12.125	12.1307	130004.0
2011-05-31 08:15:00	AAPL	Stock	12.1318	12.1357	12.1304	12.1357	108528.0
2011-05-31 08:20:00	AAPL	Stock	12.1325	12.1407	12.1321	12.1321	96348.0
2011-05-31 08:25:00	AAPL	Stock	12.1357	12.1357	12.1254	12.1257	114800.0
2011-05-31 08:30:00	AAPL	Stock	12.1339	12.1961	12.1339	12.1911	904008.0
2011-05-31 08:35:00	AAPL	Stock	12.1839	12.1946	12.1754	12.1754	429352.0
2011-05-31 08:40:00	AAPL	Stock	12.1754	12.1793	12.1679	12.1786	166964.0
2011-05-31 08:45:00	AAPL	Stock	12.1786	12.1786	12.1725	12.1725	161756.0
2011-05-31 08:50:00	AAPL	Stock	12.1679	12.1757	12.1643	12.1661	96936.0
2011-05-31 08:55:00	AAPL	Stock	12.1661	12.175	12.1607	12.1696	264040.0
2011-05-31 09:00:00	AAPL	Stock	12.1654	12.1961	12.1636	12.1929	614096.0
2011-05-31 09:05:00	AAPL	Stock	12.1893	12.1896	12.1857	12.1893	205800.0
2011-05-31 09:10:00	AAPL	Stock	12.1889	12.2018	12.1857	12.1964	609588.0
2011-05-31 09:15:00	AAPL	Stock	12.1975	12.1989	12.1904	12.1929	264320.0
2011-05-31 09:20:00	AAPL	Stock	12.1929	12.1929	12.1821	12.1825	70812.0
2011-05-31 09:25:00	AAPL	Stock	12.1893	12.19	12.1782	12.1821	286720.0
2011-05-31 09:30:00	AAPL	Stock	12.1821	12.2429	12.1786	12.2396	19342260.0
2011-05-31 09:35:00	AAPL	Stock	12.2386	12.2732	12.2386	12.2589	17769164.0
2011-05-31 09:40:00	AAPL	Stock	12.2604	12.2696	12.2411	12.2632	9576840.0
2011-05-31 09:45:00	AAPL	Stock	12.261	12.2786	12.2539	12.2736	11150440.0
2011-05-31 09:50:00	AAPL	Stock	12.2743	12.2843	12.2571	12.2605	9719836.0
2011-05-31 09:55:00	AAPL	Stock	12.2607	12.2618	12.2393	12.2393	7694932.0
2011-05-31 10:00:00	AAPL	Stock	12.2389	12.2571	12.2375	12.2464	6124804.0
2011-05-31 10:05:00	AAPL	Stock	12.2464	12.2693	12.2429	12.2664	6033160.0
2011-05-31 10:10:00	AAPL	Stock	12.2678	12.2764	12.2636	12.2745	4667236.0
2011-05-31 10:15:00	AAPL	Stock	12.2733	12.2889	12.2679	12.2739	9362836.0
2011-05-31 10:20:00	AAPL	Stock	12.2732	12.2754	12.2361	12.2414	10154060.0
2011-05-31 10:25:00	AAPL	Stock	12.2414	12.2546	12.2393	12.2521	3785124.0
2011-05-31 10:30:00	AAPL	Stock	12.2512	12.2546	12.2393	12.2468	3460744.0
2011-05-31 10:35:00	AAPL	Stock	12.2479	12.25	12.225	12.2279	5531652.0
2011-05-31 10:40:00	AAPL	Stock	12.2271	12.25	12.2271	12.2482	4166904.0

> showing 50 of 348,485 rows — these rows as CSV

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