PREVIEW / stock_1hour / 2006-03-29

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-29.parquet
  size:    599 KB
  rows:    28,342
  symbols: 2,227

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
2006-03-29 04:00:00	AAPL	Stock	2.1	2.1	2.0839	2.0839	33600.0
2006-03-29 05:00:00	AAPL	Stock	2.0875	2.0875	2.0875	2.0875	67200.0
2006-03-29 06:00:00	AAPL	Stock	2.1032	2.1032	2.0911	2.0911	14000.0
2006-03-29 07:00:00	AAPL	Stock	2.0943	2.1054	2.0943	2.0975	131516.0
2006-03-29 08:00:00	AAPL	Stock	2.0982	2.1104	2.0971	2.1086	3670744.0
2006-03-29 09:00:00	AAPL	Stock	2.1079	2.115	2.0829	2.0882	169049580.0
2006-03-29 10:00:00	AAPL	Stock	2.0882	2.0907	2.0596	2.0629	353522904.0
2006-03-29 11:00:00	AAPL	Stock	2.0629	2.1657	2.0625	2.1579	681841916.0
2006-03-29 12:00:00	AAPL	Stock	2.1579	2.1893	2.1564	2.1832	339329144.0
2006-03-29 13:00:00	AAPL	Stock	2.1832	2.2075	2.1786	2.2025	244207992.0
2006-03-29 14:00:00	AAPL	Stock	2.2021	2.2196	2.1946	2.2154	256508308.0
2006-03-29 15:00:00	AAPL	Stock	2.215	2.2329	2.2104	2.2246	275079252.0
2006-03-29 16:00:00	AAPL	Stock	2.225	2.2271	2.1273	2.2182	9282420.0
2006-03-29 17:00:00	AAPL	Stock	2.2154	2.2261	2.2036	2.2143	2392180.0
2006-03-29 18:00:00	AAPL	Stock	2.2132	2.2164	2.2114	2.2118	408800.0
2006-03-29 07:00:00	MSFT	Stock	26.93	26.93	26.93	26.93	1000.0
2006-03-29 08:00:00	MSFT	Stock	26.94	26.97	26.93	26.96	49554.0
2006-03-29 09:00:00	MSFT	Stock	26.96	27.01	26.92	26.96	5732384.0
2006-03-29 10:00:00	MSFT	Stock	26.96	27.14	26.93	27.01	8374442.0
2006-03-29 11:00:00	MSFT	Stock	27.02	27.15	27.01	27.07	5531165.0
2006-03-29 12:00:00	MSFT	Stock	27.08	27.12	27.03	27.041	2818763.0
2006-03-29 13:00:00	MSFT	Stock	27.05	27.19	27.02	27.13	3818600.0
2006-03-29 14:00:00	MSFT	Stock	27.14	27.2	27.07	27.08	6230592.0
2006-03-29 15:00:00	MSFT	Stock	27.08	27.11	27.01	27.02	12708857.0
2006-03-29 16:00:00	MSFT	Stock	27.02	27.09	27.0	27.04	2336061.0
2006-03-29 17:00:00	MSFT	Stock	27.03	27.05	27.01	27.01	9320.0
2006-03-29 18:00:00	MSFT	Stock	27.03	27.03	27.019	27.019	582029.0
2006-03-29 08:00:00	NVDA	Stock	0.4514	0.4514	0.4514	0.4514	60000.0
2006-03-29 09:00:00	NVDA	Stock	0.4521	0.4558	0.4496	0.4553	112827720.0
2006-03-29 10:00:00	NVDA	Stock	0.4554	0.4607	0.4529	0.4582	181759920.0
2006-03-29 11:00:00	NVDA	Stock	0.4582	0.4691	0.4579	0.4661	167096760.0
2006-03-29 12:00:00	NVDA	Stock	0.4662	0.4685	0.4642	0.4667	99765480.0
2006-03-29 13:00:00	NVDA	Stock	0.4666	0.4708	0.4664	0.47	85539600.0
2006-03-29 14:00:00	NVDA	Stock	0.4699	0.4732	0.4699	0.472	79749720.0
2006-03-29 15:00:00	NVDA	Stock	0.472	0.4765	0.4718	0.4759	207055560.0
2006-03-29 16:00:00	NVDA	Stock	0.4751	0.4764	0.4746	0.4762	1915320.0
2006-03-29 17:00:00	NVDA	Stock	0.4762	0.4771	0.4757	0.4759	376200.0
2006-03-29 18:00:00	NVDA	Stock	0.476	0.4775	0.4758	0.4775	597720.0
2006-03-29 08:00:00	AMZN	Stock	1.8245	1.831	1.7805	1.7805	34200.0
2006-03-29 09:00:00	AMZN	Stock	1.7875	1.7945	1.7655	1.7865	8375020.0
2006-03-29 10:00:00	AMZN	Stock	1.7865	1.819	1.7836	1.7955	33933720.0
2006-03-29 11:00:00	AMZN	Stock	1.7965	1.8115	1.796	1.8055	14983760.0
2006-03-29 12:00:00	AMZN	Stock	1.806	1.818	1.8055	1.816	14602120.0
2006-03-29 13:00:00	AMZN	Stock	1.816	1.8405	1.816	1.8315	20815920.0
2006-03-29 14:00:00	AMZN	Stock	1.832	1.84	1.8175	1.8225	17666460.0
2006-03-29 15:00:00	AMZN	Stock	1.8225	1.8235	1.809	1.8165	29249580.0
2006-03-29 16:00:00	AMZN	Stock	1.816	1.8172	1.8118	1.8172	578640.0
2006-03-29 17:00:00	AMZN	Stock	1.815	1.818	1.815	1.818	31800.0
2006-03-29 09:00:00	CL	Stock	28.73	28.775	28.51	28.53	563000.0
2006-03-29 10:00:00	CL	Stock	28.535	28.62	28.525	28.54	555400.0

> showing 50 of 28,342 rows — these rows as CSV

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