PREVIEW / stock_1hour / 2006-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-10.parquet
  size:    590 KB
  rows:    28,089
  symbols: 2,174

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-01-10 05:00:00	AAPL	Stock	2.7018	2.7018	2.7018	2.7018	2800.0
2006-01-10 06:00:00	AAPL	Stock	2.7018	2.7018	2.7018	2.7018	8400.0
2006-01-10 07:00:00	AAPL	Stock	2.7054	2.7089	2.7046	2.7054	25200.0
2006-01-10 08:00:00	AAPL	Stock	2.705	2.7129	2.7018	2.7111	3990392.0
2006-01-10 09:00:00	AAPL	Stock	2.7107	2.7475	2.7082	2.7432	115739652.0
2006-01-10 10:00:00	AAPL	Stock	2.7432	2.7775	2.7421	2.7507	166820976.0
2006-01-10 11:00:00	AAPL	Stock	2.7507	2.7768	2.7261	2.7661	156225776.0
2006-01-10 12:00:00	AAPL	Stock	2.7661	2.8979	2.7657	2.8964	673042328.0
2006-01-10 13:00:00	AAPL	Stock	2.8957	2.9246	2.8546	2.8604	478712556.0
2006-01-10 14:00:00	AAPL	Stock	2.8607	2.8825	2.8411	2.8486	284909268.0
2006-01-10 15:00:00	AAPL	Stock	2.8486	2.8911	2.8164	2.8889	376976320.0
2006-01-10 16:00:00	AAPL	Stock	2.8911	2.9054	2.8861	2.8982	11379200.0
2006-01-10 17:00:00	AAPL	Stock	2.8982	2.9029	2.8936	2.9021	1117788.0
2006-01-10 18:00:00	AAPL	Stock	2.9025	2.9029	2.9014	2.9021	462000.0
2006-01-10 08:00:00	MSFT	Stock	26.75	26.76	26.65	26.76	15501.0
2006-01-10 09:00:00	MSFT	Stock	26.77	26.79	26.59	26.63	6998071.0
2006-01-10 10:00:00	MSFT	Stock	26.63	26.72	26.6	26.66	8726382.0
2006-01-10 11:00:00	MSFT	Stock	26.66	26.77	26.64	26.75	5924393.0
2006-01-10 12:00:00	MSFT	Stock	26.74	26.81	26.73	26.772	8368236.0
2006-01-10 13:00:00	MSFT	Stock	26.78	26.83	26.73	26.74	7712143.0
2006-01-10 14:00:00	MSFT	Stock	26.74	26.82	26.7	26.812	9687862.0
2006-01-10 15:00:00	MSFT	Stock	26.82	27.02	26.78	27.0	15795066.0
2006-01-10 16:00:00	MSFT	Stock	27.0	27.02	26.96	26.99	210565.0
2006-01-10 17:00:00	MSFT	Stock	27.0	27.0	26.99	26.99	3800.0
2006-01-10 18:00:00	MSFT	Stock	27.0	27.0	26.99	26.99	2500.0
2006-01-10 08:00:00	NVDA	Stock	0.3479	0.3479	0.3479	0.3479	36000.0
2006-01-10 09:00:00	NVDA	Stock	0.3485	0.3485	0.3437	0.3457	49948920.0
2006-01-10 10:00:00	NVDA	Stock	0.3456	0.3472	0.3455	0.3457	46130160.0
2006-01-10 11:00:00	NVDA	Stock	0.3457	0.3457	0.344	0.3443	39660720.0
2006-01-10 12:00:00	NVDA	Stock	0.3444	0.3464	0.3443	0.3446	26272440.0
2006-01-10 13:00:00	NVDA	Stock	0.3446	0.3478	0.3442	0.3463	36239640.0
2006-01-10 14:00:00	NVDA	Stock	0.3463	0.3479	0.3458	0.3469	42672240.0
2006-01-10 15:00:00	NVDA	Stock	0.3469	0.3499	0.3469	0.3498	88008360.0
2006-01-10 16:00:00	NVDA	Stock	0.3498	0.35	0.3489	0.3499	188280.0
2006-01-10 17:00:00	NVDA	Stock	0.3497	0.3497	0.3496	0.3496	96000.0
2006-01-10 07:00:00	AMZN	Stock	2.3355	2.3355	2.313	2.313	48000.0
2006-01-10 08:00:00	AMZN	Stock	2.325	2.3275	2.315	2.325	930800.0
2006-01-10 09:00:00	AMZN	Stock	2.3275	2.3375	2.3115	2.318	23227220.0
2006-01-10 10:00:00	AMZN	Stock	2.3185	2.3325	2.2925	2.295	30728400.0
2006-01-10 11:00:00	AMZN	Stock	2.2945	2.312	2.292	2.307	17291640.0
2006-01-10 12:00:00	AMZN	Stock	2.307	2.3105	2.2885	2.293	15376860.0
2006-01-10 13:00:00	AMZN	Stock	2.293	2.3035	2.2915	2.294	20804580.0
2006-01-10 14:00:00	AMZN	Stock	2.2945	2.3	2.268	2.283	39027660.0
2006-01-10 15:00:00	AMZN	Stock	2.283	2.2895	2.2725	2.2825	42523860.0
2006-01-10 16:00:00	AMZN	Stock	2.282	2.2865	2.2795	2.286	1504100.0
2006-01-10 17:00:00	AMZN	Stock	2.29	2.2925	2.2875	2.2925	59620.0
2006-01-10 18:00:00	AMZN	Stock	2.2825	2.2835	2.2825	2.2835	16000.0
2006-01-10 09:00:00	CL	Stock	27.58	27.62	27.505	27.585	364400.0
2006-01-10 10:00:00	CL	Stock	27.605	27.655	27.405	27.425	496200.0
2006-01-10 11:00:00	CL	Stock	27.43	27.555	27.425	27.49	460200.0

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

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