PREVIEW / stock_5min / 2012-04-13

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-04-13.parquet
  size:    4.7 MB
  rows:    321,476
  symbols: 3,510

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-04-13 04:00:00	AAPL	Stock	22.2143	22.2143	22.2143	22.2143	2800.0
2012-04-13 04:05:00	AAPL	Stock	22.2143	22.2143	22.2054	22.2054	14000.0
2012-04-13 04:25:00	AAPL	Stock	22.2054	22.2054	22.2054	22.2054	8400.0
2012-04-13 04:30:00	AAPL	Stock	22.2054	22.2054	22.2	22.2	126000.0
2012-04-13 04:35:00	AAPL	Stock	22.1964	22.1964	22.1964	22.1964	40600.0
2012-04-13 04:50:00	AAPL	Stock	22.1893	22.1893	22.1893	22.1893	14000.0
2012-04-13 05:00:00	AAPL	Stock	22.2036	22.2043	22.1893	22.1893	20440.0
2012-04-13 05:05:00	AAPL	Stock	22.1893	22.1893	22.1893	22.1893	5600.0
2012-04-13 05:10:00	AAPL	Stock	22.1893	22.1893	22.1893	22.1893	5600.0
2012-04-13 05:15:00	AAPL	Stock	22.1893	22.1893	22.1893	22.1893	13300.0
2012-04-13 05:30:00	AAPL	Stock	22.2014	22.2014	22.2014	22.2014	2800.0
2012-04-13 06:15:00	AAPL	Stock	22.2018	22.2018	22.1964	22.1964	21980.0
2012-04-13 06:30:00	AAPL	Stock	22.2321	22.2321	22.2321	22.2321	5908.0
2012-04-13 06:35:00	AAPL	Stock	22.2107	22.2107	22.2107	22.2107	5600.0
2012-04-13 06:45:00	AAPL	Stock	22.2107	22.2107	22.2107	22.2107	8400.0
2012-04-13 06:55:00	AAPL	Stock	22.2214	22.2214	22.2214	22.2214	2800.0
2012-04-13 07:00:00	AAPL	Stock	22.2464	22.2536	22.2321	22.2536	121240.0
2012-04-13 07:05:00	AAPL	Stock	22.25	22.2518	22.2429	22.2429	39704.0
2012-04-13 07:10:00	AAPL	Stock	22.2411	22.2411	22.2411	22.2411	28000.0
2012-04-13 07:15:00	AAPL	Stock	22.2382	22.2425	22.2325	22.2325	50792.0
2012-04-13 07:20:00	AAPL	Stock	22.2321	22.2418	22.2321	22.2418	11508.0
2012-04-13 07:25:00	AAPL	Stock	22.2461	22.25	22.2461	22.25	40628.0
2012-04-13 07:30:00	AAPL	Stock	22.2432	22.2529	22.2432	22.2468	16800.0
2012-04-13 07:35:00	AAPL	Stock	22.2446	22.2464	22.2432	22.2432	98000.0
2012-04-13 07:40:00	AAPL	Stock	22.2436	22.2493	22.2382	22.2382	22400.0
2012-04-13 07:45:00	AAPL	Stock	22.2329	22.2329	22.2004	22.2143	285600.0
2012-04-13 07:50:00	AAPL	Stock	22.2121	22.2196	22.2039	22.2139	109816.0
2012-04-13 07:55:00	AAPL	Stock	22.2139	22.2143	22.2018	22.2054	63056.0
2012-04-13 08:00:00	AAPL	Stock	22.2054	22.2464	22.1629	22.1782	406364.0
2012-04-13 08:05:00	AAPL	Stock	22.1696	22.1696	22.1118	22.13	413112.0
2012-04-13 08:10:00	AAPL	Stock	22.1214	22.175	22.115	22.165	354256.0
2012-04-13 08:15:00	AAPL	Stock	22.175	22.1875	22.1654	22.1814	232680.0
2012-04-13 08:20:00	AAPL	Stock	22.1914	22.2014	22.1825	22.2014	144088.0
2012-04-13 08:25:00	AAPL	Stock	22.1896	22.2146	22.1875	22.1964	222572.0
2012-04-13 08:30:00	AAPL	Stock	22.1957	22.1964	22.1811	22.1929	79520.0
2012-04-13 08:35:00	AAPL	Stock	22.1943	22.2036	22.1843	22.1846	314608.0
2012-04-13 08:40:00	AAPL	Stock	22.185	22.1964	22.1846	22.1875	77280.0
2012-04-13 08:45:00	AAPL	Stock	22.1857	22.1918	22.1843	22.1843	56420.0
2012-04-13 08:50:00	AAPL	Stock	22.1843	22.2161	22.1839	22.2161	199836.0
2012-04-13 08:55:00	AAPL	Stock	22.2246	22.2329	22.2207	22.2207	135324.0
2012-04-13 09:00:00	AAPL	Stock	22.2275	22.2411	22.2207	22.2329	113456.0
2012-04-13 09:05:00	AAPL	Stock	22.2418	22.2821	22.2346	22.2796	677320.0
2012-04-13 09:10:00	AAPL	Stock	22.2811	22.3125	22.275	22.2954	866852.0
2012-04-13 09:15:00	AAPL	Stock	22.3018	22.3089	22.2857	22.2868	575904.0
2012-04-13 09:20:00	AAPL	Stock	22.2943	22.3007	22.2857	22.2961	545692.0
2012-04-13 09:25:00	AAPL	Stock	22.2918	22.3179	22.231	22.2936	657356.0
2012-04-13 09:30:00	AAPL	Stock	22.2939	22.3107	22.1525	22.1832	23703232.0
2012-04-13 09:35:00	AAPL	Stock	22.1832	22.2053	22.0496	22.055	30605988.0
2012-04-13 09:40:00	AAPL	Stock	22.055	22.14	22.0521	22.1267	14379484.0
2012-04-13 09:45:00	AAPL	Stock	22.1264	22.1779	22.1225	22.1379	12873588.0

> showing 50 of 321,476 rows — these rows as CSV

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