PREVIEW / stock_1hour / 2006-07-28

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-28.parquet
  size:    607 KB
  rows:    29,206
  symbols: 2,303

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-07-28 08:00:00	AAPL	Stock	2.2661	2.2875	2.2643	2.2839	1347080.0
2006-07-28 09:00:00	AAPL	Stock	2.2857	2.2879	2.2679	2.2871	67907224.0
2006-07-28 10:00:00	AAPL	Stock	2.2871	2.2961	2.2796	2.2925	105215124.0
2006-07-28 11:00:00	AAPL	Stock	2.2921	2.3121	2.2893	2.3054	97915104.0
2006-07-28 12:00:00	AAPL	Stock	2.3043	2.3279	2.2946	2.3268	99953896.0
2006-07-28 13:00:00	AAPL	Stock	2.3268	2.33	2.3082	2.3175	71687000.0
2006-07-28 14:00:00	AAPL	Stock	2.3175	2.3393	2.3171	2.3314	83456268.0
2006-07-28 15:00:00	AAPL	Stock	2.3314	2.3457	2.3268	2.3425	146880160.0
2006-07-28 16:00:00	AAPL	Stock	2.3425	2.3468	2.3222	2.3446	2199344.0
2006-07-28 17:00:00	AAPL	Stock	2.3446	2.3482	2.3429	2.3432	428568.0
2006-07-28 18:00:00	AAPL	Stock	2.345	2.35	2.3446	2.35	128408.0
2006-07-28 07:00:00	MSFT	Stock	23.85	23.85	23.85	23.85	1000.0
2006-07-28 08:00:00	MSFT	Stock	23.9	24.04	23.9	24.04	101339.0
2006-07-28 09:00:00	MSFT	Stock	24.0	24.24	24.0	24.22	5216765.0
2006-07-28 10:00:00	MSFT	Stock	24.22	24.24	24.06	24.12	9282872.0
2006-07-28 11:00:00	MSFT	Stock	24.12	24.23	24.1	24.14	8176480.0
2006-07-28 12:00:00	MSFT	Stock	24.14	24.22	24.11	24.18	4944904.0
2006-07-28 13:00:00	MSFT	Stock	24.18	24.23	24.1	24.162	4171822.0
2006-07-28 14:00:00	MSFT	Stock	24.17	24.25	24.16	24.23	6721574.0
2006-07-28 15:00:00	MSFT	Stock	24.23	24.28	24.1	24.22	10666992.0
2006-07-28 16:00:00	MSFT	Stock	24.2	24.28	24.2	24.25	495149.0
2006-07-28 17:00:00	MSFT	Stock	24.25	24.26	24.13	24.25	7150.0
2006-07-28 18:00:00	MSFT	Stock	24.25	24.25	24.24	24.24	219.0
2006-07-28 08:00:00	NVDA	Stock	0.345	0.3495	0.345	0.3495	54000.0
2006-07-28 09:00:00	NVDA	Stock	0.3483	0.3598	0.3453	0.3553	94993740.0
2006-07-28 10:00:00	NVDA	Stock	0.3555	0.3567	0.3525	0.3555	65703600.0
2006-07-28 11:00:00	NVDA	Stock	0.3557	0.3623	0.3555	0.3613	93070860.0
2006-07-28 12:00:00	NVDA	Stock	0.3611	0.3667	0.36	0.3665	103918260.0
2006-07-28 13:00:00	NVDA	Stock	0.3665	0.3668	0.3625	0.3642	72009540.0
2006-07-28 14:00:00	NVDA	Stock	0.3642	0.3708	0.3642	0.3707	108523200.0
2006-07-28 15:00:00	NVDA	Stock	0.3706	0.3785	0.3702	0.3777	235545780.0
2006-07-28 16:00:00	NVDA	Stock	0.3777	0.3812	0.3767	0.3783	3425400.0
2006-07-28 17:00:00	NVDA	Stock	0.3788	0.3788	0.376	0.3775	219660.0
2006-07-28 18:00:00	NVDA	Stock	0.3767	0.3783	0.3767	0.3783	205200.0
2006-07-28 08:00:00	AMZN	Stock	1.3275	1.33	1.3275	1.328	55640.0
2006-07-28 09:00:00	AMZN	Stock	1.3285	1.34	1.3285	1.335	22060340.0
2006-07-28 10:00:00	AMZN	Stock	1.3352	1.34	1.334	1.335	41425200.0
2006-07-28 11:00:00	AMZN	Stock	1.335	1.3385	1.3345	1.337	28622860.0
2006-07-28 12:00:00	AMZN	Stock	1.3375	1.3395	1.3335	1.338	31797940.0
2006-07-28 13:00:00	AMZN	Stock	1.3385	1.34	1.337	1.3375	18882020.0
2006-07-28 14:00:00	AMZN	Stock	1.3375	1.3555	1.337	1.3525	33579360.0
2006-07-28 15:00:00	AMZN	Stock	1.3525	1.359	1.3445	1.3585	66628300.0
2006-07-28 16:00:00	AMZN	Stock	1.3585	1.3595	1.349	1.356	556000.0
2006-07-28 17:00:00	AMZN	Stock	1.3545	1.3545	1.354	1.354	26000.0
2006-07-28 18:00:00	AMZN	Stock	1.354	1.355	1.354	1.354	16300.0
2006-07-28 09:00:00	CL	Stock	29.6	29.835	29.49	29.75	304800.0
2006-07-28 10:00:00	CL	Stock	29.75	29.85	29.635	29.815	635600.0
2006-07-28 11:00:00	CL	Stock	29.81	29.97	29.81	29.905	509400.0
2006-07-28 12:00:00	CL	Stock	29.91	29.955	29.88	29.91	238400.0
2006-07-28 13:00:00	CL	Stock	29.92	29.92	29.785	29.805	326600.0

> showing 50 of 29,206 rows — these rows as CSV

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