PREVIEW / stock_1hour / 2009-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-03.parquet
  size:    852 KB
  rows:    42,933
  symbols: 3,359

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
2009-03-03 07:00:00	AAPL	Stock	3.1679	3.1679	3.1679	3.1679	5600.0
2009-03-03 08:00:00	AAPL	Stock	3.1671	3.2071	3.15	3.1821	2791964.0
2009-03-03 09:00:00	AAPL	Stock	3.1821	3.2036	3.1536	3.1611	87985716.0
2009-03-03 10:00:00	AAPL	Stock	3.1611	3.1929	3.1386	3.1646	107352364.0
2009-03-03 11:00:00	AAPL	Stock	3.165	3.1886	3.1429	3.17	90316744.0
2009-03-03 12:00:00	AAPL	Stock	3.1704	3.2136	3.165	3.1686	88568256.0
2009-03-03 13:00:00	AAPL	Stock	3.1689	3.1929	3.155	3.185	79982140.0
2009-03-03 14:00:00	AAPL	Stock	3.185	3.2407	3.1807	3.225	115022488.0
2009-03-03 15:00:00	AAPL	Stock	3.225	3.2254	3.1539	3.1557	131087292.0
2009-03-03 16:00:00	AAPL	Stock	3.1557	3.1928	3.1161	3.1386	13272224.0
2009-03-03 17:00:00	AAPL	Stock	3.1321	3.1561	3.1257	3.1293	2431016.0
2009-03-03 18:00:00	AAPL	Stock	3.1286	3.1804	3.1286	3.1286	2844968.0
2009-03-03 19:00:00	AAPL	Stock	3.1321	3.1321	3.125	3.1318	58744.0
2009-03-03 20:00:00	AAPL	Stock	3.155	3.155	3.155	3.155	221200.0
2009-03-03 06:00:00	MSFT	Stock	15.81	15.81	15.8	15.8	1500.0
2009-03-03 07:00:00	MSFT	Stock	15.77	16.0	15.77	15.9	11472.0
2009-03-03 08:00:00	MSFT	Stock	15.9	16.0	15.85	15.96	139918.0
2009-03-03 09:00:00	MSFT	Stock	15.96	16.23	15.95	16.08	7697245.0
2009-03-03 10:00:00	MSFT	Stock	16.08	16.15	15.9	15.97	9699207.0
2009-03-03 11:00:00	MSFT	Stock	15.97	15.98	15.64	15.71	12807248.0
2009-03-03 12:00:00	MSFT	Stock	15.71	16.05	15.71	15.85	9102164.0
2009-03-03 13:00:00	MSFT	Stock	15.85	16.0	15.77	15.96	7010218.0
2009-03-03 14:00:00	MSFT	Stock	15.96	16.24	15.93	16.19	11190121.0
2009-03-03 15:00:00	MSFT	Stock	16.18	16.235	15.89	15.9	15177418.0
2009-03-03 16:00:00	MSFT	Stock	15.89	16.064	15.66	15.7	4909288.0
2009-03-03 17:00:00	MSFT	Stock	15.79	15.88	15.71	15.75	266580.0
2009-03-03 18:00:00	MSFT	Stock	15.75	16.0	15.75	15.77	488609.0
2009-03-03 19:00:00	MSFT	Stock	15.75	15.84	15.75	15.8	7985.0
2009-03-03 20:00:00	MSFT	Stock	15.69	15.69	15.69	15.69	8900.0
2009-03-03 08:00:00	NVDA	Stock	0.1955	0.1955	0.1955	0.1955	10000.0
2009-03-03 09:00:00	NVDA	Stock	0.1955	0.1968	0.1905	0.1913	101113600.0
2009-03-03 10:00:00	NVDA	Stock	0.1913	0.1938	0.1878	0.19	178174240.0
2009-03-03 11:00:00	NVDA	Stock	0.19	0.1908	0.1868	0.1883	90484800.0
2009-03-03 12:00:00	NVDA	Stock	0.1885	0.1938	0.1883	0.192	70985520.0
2009-03-03 13:00:00	NVDA	Stock	0.1918	0.1942	0.191	0.1938	53643360.0
2009-03-03 14:00:00	NVDA	Stock	0.1938	0.2045	0.1935	0.2038	230418560.0
2009-03-03 15:00:00	NVDA	Stock	0.204	0.204	0.1968	0.1968	290282480.0
2009-03-03 16:00:00	NVDA	Stock	0.1968	0.1992	0.1948	0.195	15518360.0
2009-03-03 17:00:00	NVDA	Stock	0.197	0.197	0.197	0.197	1386320.0
2009-03-03 18:00:00	NVDA	Stock	0.197	0.197	0.197	0.197	95200.0
2009-03-03 20:00:00	NVDA	Stock	0.187	0.187	0.187	0.187	48000.0
2009-03-03 08:00:00	AMZN	Stock	3.1225	3.15	3.1225	3.15	31200.0
2009-03-03 09:00:00	AMZN	Stock	3.1475	3.1645	3.095	3.1015	24260420.0
2009-03-03 10:00:00	AMZN	Stock	3.102	3.156	3.075	3.091	22262560.0
2009-03-03 11:00:00	AMZN	Stock	3.0915	3.125	3.065	3.0915	23227600.0
2009-03-03 12:00:00	AMZN	Stock	3.091	3.1445	3.09	3.1085	22371980.0
2009-03-03 13:00:00	AMZN	Stock	3.109	3.111	3.0665	3.095	24215240.0
2009-03-03 14:00:00	AMZN	Stock	3.0945	3.138	3.085	3.131	28898960.0
2009-03-03 15:00:00	AMZN	Stock	3.13	3.1315	3.0705	3.0845	39893500.0
2009-03-03 16:00:00	AMZN	Stock	3.0845	3.1062	3.018	3.04	5469980.0

> showing 50 of 42,933 rows — these rows as CSV

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