PREVIEW / stock_5min / 2011-01-28

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-01-28.parquet
  size:    5.1 MB
  rows:    345,063
  symbols: 3,520

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-01-28 07:00:00	AAPL	Stock	12.2225	12.2225	12.2082	12.2082	14000.0
2011-01-28 07:05:00	AAPL	Stock	12.2421	12.2421	12.2421	12.2421	10780.0
2011-01-28 07:20:00	AAPL	Stock	12.2411	12.2411	12.2411	12.2411	5600.0
2011-01-28 07:45:00	AAPL	Stock	12.2457	12.2457	12.2457	12.2457	5600.0
2011-01-28 07:55:00	AAPL	Stock	12.2457	12.2457	12.245	12.245	14000.0
2011-01-28 08:00:00	AAPL	Stock	12.2411	12.2446	12.2214	12.2275	139048.0
2011-01-28 08:05:00	AAPL	Stock	12.2321	12.2379	12.2271	12.2379	102704.0
2011-01-28 08:10:00	AAPL	Stock	12.2325	12.2575	12.2321	12.2575	128800.0
2011-01-28 08:15:00	AAPL	Stock	12.2368	12.2368	12.2321	12.2368	54740.0
2011-01-28 08:20:00	AAPL	Stock	12.2368	12.2375	12.2368	12.2375	25760.0
2011-01-28 08:25:00	AAPL	Stock	12.2357	12.25	12.2357	12.2404	136332.0
2011-01-28 08:30:00	AAPL	Stock	12.2357	12.2882	12.2321	12.2807	618044.0
2011-01-28 08:35:00	AAPL	Stock	12.2804	12.2836	12.2636	12.2768	337568.0
2011-01-28 08:40:00	AAPL	Stock	12.2768	12.2775	12.2636	12.2657	124460.0
2011-01-28 08:45:00	AAPL	Stock	12.2671	12.2721	12.2671	12.2682	32032.0
2011-01-28 08:50:00	AAPL	Stock	12.2732	12.2746	12.2668	12.2668	140000.0
2011-01-28 08:55:00	AAPL	Stock	12.2696	12.2739	12.2696	12.2732	72800.0
2011-01-28 09:00:00	AAPL	Stock	12.2654	12.2725	12.2654	12.2725	5600.0
2011-01-28 09:05:00	AAPL	Stock	12.2714	12.2721	12.2689	12.2721	31080.0
2011-01-28 09:10:00	AAPL	Stock	12.2764	12.2786	12.2739	12.2786	119392.0
2011-01-28 09:15:00	AAPL	Stock	12.2782	12.2782	12.2718	12.2718	217896.0
2011-01-28 09:20:00	AAPL	Stock	12.2675	12.2675	12.2607	12.2661	71624.0
2011-01-28 09:25:00	AAPL	Stock	12.2657	12.29	12.2554	12.29	461860.0
2011-01-28 09:30:00	AAPL	Stock	12.2921	12.3	12.2504	12.2691	10389988.0
2011-01-28 09:35:00	AAPL	Stock	12.2689	12.2939	12.2564	12.2679	6054776.0
2011-01-28 09:40:00	AAPL	Stock	12.2679	12.2857	12.2607	12.2693	4776296.0
2011-01-28 09:45:00	AAPL	Stock	12.2689	12.2836	12.2629	12.2654	3665172.0
2011-01-28 09:50:00	AAPL	Stock	12.2654	12.2746	12.2582	12.2642	4231584.0
2011-01-28 09:55:00	AAPL	Stock	12.2643	12.2729	12.2218	12.2293	10704988.0
2011-01-28 10:00:00	AAPL	Stock	12.2293	12.2339	12.1882	12.1936	10639160.0
2011-01-28 10:05:00	AAPL	Stock	12.1961	12.1971	12.1382	12.1671	18486188.0
2011-01-28 10:10:00	AAPL	Stock	12.1664	12.2011	12.1554	12.1898	7805280.0
2011-01-28 10:15:00	AAPL	Stock	12.19	12.2025	12.1568	12.1614	7537376.0
2011-01-28 10:20:00	AAPL	Stock	12.1629	12.17	12.1025	12.1118	14385728.0
2011-01-28 10:25:00	AAPL	Stock	12.1111	12.1429	12.1071	12.1329	8695400.0
2011-01-28 10:30:00	AAPL	Stock	12.1321	12.1429	12.1071	12.1074	10190292.0
2011-01-28 10:35:00	AAPL	Stock	12.1071	12.1311	12.1043	12.1271	7127204.0
2011-01-28 10:40:00	AAPL	Stock	12.1271	12.1596	12.1221	12.1446	9655660.0
2011-01-28 10:45:00	AAPL	Stock	12.145	12.1577	12.1286	12.1573	7497756.0
2011-01-28 10:50:00	AAPL	Stock	12.1578	12.1629	12.1289	12.1439	7033964.0
2011-01-28 10:55:00	AAPL	Stock	12.1461	12.15	12.1207	12.1414	7214956.0
2011-01-28 11:00:00	AAPL	Stock	12.1404	12.1468	12.1211	12.1254	6184808.0
2011-01-28 11:05:00	AAPL	Stock	12.1254	12.135	12.1168	12.125	5051536.0
2011-01-28 11:10:00	AAPL	Stock	12.1261	12.1493	12.1225	12.1379	5561780.0
2011-01-28 11:15:00	AAPL	Stock	12.1357	12.1457	12.1221	12.1411	5044088.0
2011-01-28 11:20:00	AAPL	Stock	12.1404	12.1461	12.1196	12.1262	4044012.0
2011-01-28 11:25:00	AAPL	Stock	12.1246	12.1371	12.1114	12.1186	4723852.0
2011-01-28 11:30:00	AAPL	Stock	12.1179	12.1179	12.0839	12.0868	14563892.0
2011-01-28 11:35:00	AAPL	Stock	12.0868	12.0893	12.0568	12.0714	14396648.0
2011-01-28 11:40:00	AAPL	Stock	12.0714	12.0807	12.0304	12.0364	10276952.0

> showing 50 of 345,063 rows — these rows as CSV

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