PREVIEW / stock_1hour / 2006-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-30.parquet
  size:    598 KB
  rows:    28,187
  symbols: 2,221

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-30 04:00:00	AAPL	Stock	2.2225	2.2225	2.2225	2.2225	2800.0
2006-03-30 05:00:00	AAPL	Stock	2.2282	2.2282	2.2282	2.2282	5600.0
2006-03-30 06:00:00	AAPL	Stock	2.2318	2.2318	2.2232	2.2286	58800.0
2006-03-30 07:00:00	AAPL	Stock	2.2232	2.2429	2.2214	2.23	922544.0
2006-03-30 08:00:00	AAPL	Stock	2.2293	2.2357	2.215	2.2271	7351148.0
2006-03-30 09:00:00	AAPL	Stock	2.2275	2.26	2.2275	2.2354	252033992.0
2006-03-30 10:00:00	AAPL	Stock	2.2354	2.2482	2.1975	2.2029	336363244.0
2006-03-30 11:00:00	AAPL	Stock	2.2025	2.2375	2.1979	2.2304	201908196.0
2006-03-30 12:00:00	AAPL	Stock	2.2307	2.2418	2.2186	2.2275	100838108.0
2006-03-30 13:00:00	AAPL	Stock	2.2271	2.2546	2.2179	2.2514	140875420.0
2006-03-30 14:00:00	AAPL	Stock	2.2518	2.2607	2.2364	2.2425	171787364.0
2006-03-30 15:00:00	AAPL	Stock	2.2425	2.2564	2.2368	2.2411	162989512.0
2006-03-30 16:00:00	AAPL	Stock	2.2414	2.2461	2.2261	2.2414	4479860.0
2006-03-30 17:00:00	AAPL	Stock	2.2425	2.2496	2.2411	2.2496	599900.0
2006-03-30 18:00:00	AAPL	Stock	2.2464	2.2511	2.2411	2.2464	317884.0
2006-03-30 07:00:00	MSFT	Stock	27.1	27.1	27.1	27.1	1000.0
2006-03-30 08:00:00	MSFT	Stock	27.05	27.08	26.97	27.0	30300.0
2006-03-30 09:00:00	MSFT	Stock	26.99	27.26	26.99	27.181	5615683.0
2006-03-30 10:00:00	MSFT	Stock	27.19	27.32	27.18	27.21	10873475.0
2006-03-30 11:00:00	MSFT	Stock	27.22	27.25	27.13	27.24	5812499.0
2006-03-30 12:00:00	MSFT	Stock	27.24	27.39	27.23	27.312	6054546.0
2006-03-30 13:00:00	MSFT	Stock	27.32	27.32	27.16	27.28	4683459.0
2006-03-30 14:00:00	MSFT	Stock	27.28	27.36	27.19	27.208	6229508.0
2006-03-30 15:00:00	MSFT	Stock	27.2	27.28	27.2	27.25	11522096.0
2006-03-30 16:00:00	MSFT	Stock	27.23	27.3	27.02	27.25	917633.0
2006-03-30 17:00:00	MSFT	Stock	27.29	27.29	27.25	27.25	2452.0
2006-03-30 18:00:00	MSFT	Stock	27.25	27.25	27.25	27.25	400.0
2006-03-30 04:00:00	NVDA	Stock	0.4757	0.4757	0.4757	0.4757	12000.0
2006-03-30 07:00:00	NVDA	Stock	0.479	0.4792	0.4785	0.4785	240000.0
2006-03-30 08:00:00	NVDA	Stock	0.4783	0.4783	0.4767	0.4769	1909200.0
2006-03-30 09:00:00	NVDA	Stock	0.4765	0.4807	0.4688	0.473	204705360.0
2006-03-30 10:00:00	NVDA	Stock	0.473	0.4815	0.4708	0.4773	262751880.0
2006-03-30 11:00:00	NVDA	Stock	0.4773	0.4789	0.4742	0.4758	142859640.0
2006-03-30 12:00:00	NVDA	Stock	0.4756	0.4758	0.4712	0.4743	74120760.0
2006-03-30 13:00:00	NVDA	Stock	0.4743	0.4747	0.4676	0.4707	88089720.0
2006-03-30 14:00:00	NVDA	Stock	0.4706	0.4765	0.4706	0.4749	81247440.0
2006-03-30 15:00:00	NVDA	Stock	0.4749	0.4797	0.4744	0.4793	126232680.0
2006-03-30 16:00:00	NVDA	Stock	0.4792	0.4798	0.4757	0.4798	3055800.0
2006-03-30 17:00:00	NVDA	Stock	0.4787	0.481	0.4787	0.481	216000.0
2006-03-30 18:00:00	NVDA	Stock	0.4804	0.4804	0.4804	0.4804	12000.0
2006-03-30 08:00:00	AMZN	Stock	1.82	1.82	1.82	1.82	40000.0
2006-03-30 09:00:00	AMZN	Stock	1.8205	1.845	1.8105	1.8345	13384140.0
2006-03-30 10:00:00	AMZN	Stock	1.8335	1.8445	1.81	1.825	16149480.0
2006-03-30 11:00:00	AMZN	Stock	1.825	1.8315	1.819	1.824	6502140.0
2006-03-30 12:00:00	AMZN	Stock	1.8235	1.828	1.8175	1.8205	6809680.0
2006-03-30 13:00:00	AMZN	Stock	1.821	1.8225	1.814	1.817	7398060.0
2006-03-30 14:00:00	AMZN	Stock	1.8165	1.8275	1.809	1.812	9602620.0
2006-03-30 15:00:00	AMZN	Stock	1.8125	1.8375	1.8125	1.835	15875400.0
2006-03-30 16:00:00	AMZN	Stock	1.835	1.838	1.816	1.838	1256500.0
2006-03-30 17:00:00	AMZN	Stock	1.84	1.842	1.836	1.836	32000.0

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

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