PREVIEW / stock_1hour / 2006-03-21

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-21.parquet
  size:    598 KB
  rows:    28,011
  symbols: 2,207

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-21 07:00:00	AAPL	Stock	2.2821	2.2821	2.2821	2.2821	5600.0
2006-03-21 08:00:00	AAPL	Stock	2.2821	2.2875	2.2629	2.2764	1539160.0
2006-03-21 09:00:00	AAPL	Stock	2.2768	2.2982	2.2564	2.2668	127792476.0
2006-03-21 10:00:00	AAPL	Stock	2.2668	2.2696	2.2425	2.2532	180182072.0
2006-03-21 11:00:00	AAPL	Stock	2.2532	2.2918	2.2518	2.2854	192901016.0
2006-03-21 12:00:00	AAPL	Stock	2.2854	2.2957	2.2689	2.2711	166217492.0
2006-03-21 13:00:00	AAPL	Stock	2.2711	2.2804	2.2529	2.255	100800252.0
2006-03-21 14:00:00	AAPL	Stock	2.255	2.2586	2.2218	2.2246	227550372.0
2006-03-21 15:00:00	AAPL	Stock	2.2243	2.2275	2.1925	2.2071	333443880.0
2006-03-21 16:00:00	AAPL	Stock	2.2071	2.2143	2.2036	2.2129	5858440.0
2006-03-21 17:00:00	AAPL	Stock	2.2125	2.2189	2.2079	2.2189	1714272.0
2006-03-21 18:00:00	AAPL	Stock	2.2179	2.2196	2.2154	2.2193	869904.0
2006-03-21 07:00:00	MSFT	Stock	27.78	27.78	27.78	27.78	500.0
2006-03-21 08:00:00	MSFT	Stock	27.83	27.85	27.82	27.83	29309.0
2006-03-21 09:00:00	MSFT	Stock	27.86	27.99	27.83	27.98	6697010.0
2006-03-21 10:00:00	MSFT	Stock	27.99	28.001	27.88	27.972	8737373.0
2006-03-21 11:00:00	MSFT	Stock	27.97	28.22	27.96	28.1	18457746.0
2006-03-21 12:00:00	MSFT	Stock	28.09	28.12	28.05	28.07	4974525.0
2006-03-21 13:00:00	MSFT	Stock	28.069	28.09	27.94	27.99	6658104.0
2006-03-21 14:00:00	MSFT	Stock	27.99	28.01	27.749	27.78	9630088.0
2006-03-21 15:00:00	MSFT	Stock	27.77	27.81	27.68	27.75	12699432.0
2006-03-21 16:00:00	MSFT	Stock	27.74	27.95	27.72	27.75	692597.0
2006-03-21 17:00:00	MSFT	Stock	27.74	27.78	26.79	27.0	1588320.0
2006-03-21 18:00:00	MSFT	Stock	27.0	27.18	26.96	27.05	1099686.0
2006-03-21 07:00:00	NVDA	Stock	0.4146	0.4146	0.4115	0.4115	324000.0
2006-03-21 08:00:00	NVDA	Stock	0.4112	0.4148	0.4104	0.4137	5035200.0
2006-03-21 09:00:00	NVDA	Stock	0.4137	0.4246	0.412	0.4238	229086240.0
2006-03-21 10:00:00	NVDA	Stock	0.4238	0.4283	0.4215	0.4267	248812800.0
2006-03-21 11:00:00	NVDA	Stock	0.4267	0.4293	0.4257	0.4281	199502160.0
2006-03-21 12:00:00	NVDA	Stock	0.428	0.4308	0.4269	0.4272	96640560.0
2006-03-21 13:00:00	NVDA	Stock	0.4275	0.4281	0.4239	0.4267	111227640.0
2006-03-21 14:00:00	NVDA	Stock	0.4267	0.4283	0.4221	0.4238	145349520.0
2006-03-21 15:00:00	NVDA	Stock	0.4238	0.4243	0.4207	0.4232	167792520.0
2006-03-21 16:00:00	NVDA	Stock	0.4232	0.4235	0.4208	0.4234	1754160.0
2006-03-21 17:00:00	NVDA	Stock	0.4232	0.4236	0.4177	0.4179	4439160.0
2006-03-21 18:00:00	NVDA	Stock	0.4179	0.4192	0.4167	0.4175	3052440.0
2006-03-21 08:00:00	AMZN	Stock	1.805	1.805	1.805	1.805	2600.0
2006-03-21 09:00:00	AMZN	Stock	1.8055	1.8205	1.798	1.804	15335780.0
2006-03-21 10:00:00	AMZN	Stock	1.803	1.804	1.783	1.7935	29646180.0
2006-03-21 11:00:00	AMZN	Stock	1.7935	1.8355	1.793	1.8355	27766940.0
2006-03-21 12:00:00	AMZN	Stock	1.8355	1.8365	1.821	1.8225	11903120.0
2006-03-21 13:00:00	AMZN	Stock	1.822	1.823	1.8035	1.8085	11226100.0
2006-03-21 14:00:00	AMZN	Stock	1.8085	1.8135	1.795	1.7955	14710000.0
2006-03-21 15:00:00	AMZN	Stock	1.796	1.8055	1.793	1.7955	20836080.0
2006-03-21 16:00:00	AMZN	Stock	1.7955	1.796	1.795	1.796	273660.0
2006-03-21 17:00:00	AMZN	Stock	1.796	1.796	1.796	1.796	62780.0
2006-03-21 18:00:00	AMZN	Stock	1.796	1.796	1.796	1.796	7700.0
2006-03-21 09:00:00	CL	Stock	28.5	28.895	28.5	28.81	774800.0
2006-03-21 10:00:00	CL	Stock	28.795	28.845	28.745	28.8	562800.0
2006-03-21 11:00:00	CL	Stock	28.8	28.94	28.77	28.9295	479600.0

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

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