PREVIEW / stock_1hour / 2006-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-04.parquet
  size:    604 KB
  rows:    28,981
  symbols: 2,311

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-08-04 04:00:00	AAPL	Stock	2.3018	2.3214	2.2964	2.2964	702940.0
2006-08-04 05:00:00	AAPL	Stock	2.2929	2.3143	2.2882	2.3125	204204.0
2006-08-04 06:00:00	AAPL	Stock	2.3089	2.3161	2.3036	2.3036	116144.0
2006-08-04 07:00:00	AAPL	Stock	2.3036	2.4071	2.3036	2.3964	6606012.0
2006-08-04 08:00:00	AAPL	Stock	2.3982	2.4136	2.3804	2.4107	70078876.0
2006-08-04 09:00:00	AAPL	Stock	2.4107	2.4504	2.3804	2.4132	359975056.0
2006-08-04 10:00:00	AAPL	Stock	2.4136	2.4168	2.3782	2.3875	278023676.0
2006-08-04 11:00:00	AAPL	Stock	2.3875	2.3939	2.3225	2.3296	284679360.0
2006-08-04 12:00:00	AAPL	Stock	2.3293	2.3514	2.32	2.3338	238002828.0
2006-08-04 13:00:00	AAPL	Stock	2.3332	2.3754	2.3332	2.3654	182858424.0
2006-08-04 14:00:00	AAPL	Stock	2.3654	2.3811	2.3579	2.3654	124755792.0
2006-08-04 15:00:00	AAPL	Stock	2.3657	2.4414	2.3611	2.4411	288813896.0
2006-08-04 16:00:00	AAPL	Stock	2.4414	2.4446	2.4339	2.4361	4400060.0
2006-08-04 17:00:00	AAPL	Stock	2.4361	2.4411	2.4357	2.4396	490560.0
2006-08-04 18:00:00	AAPL	Stock	2.4393	2.4404	2.4375	2.4404	228900.0
2006-08-04 07:00:00	MSFT	Stock	24.27	24.27	24.27	24.27	1500.0
2006-08-04 08:00:00	MSFT	Stock	24.24	24.38	24.24	24.38	106432.0
2006-08-04 09:00:00	MSFT	Stock	24.37	24.45	24.32	24.367	4477493.0
2006-08-04 10:00:00	MSFT	Stock	24.37	24.47	24.33	24.45	6344032.0
2006-08-04 11:00:00	MSFT	Stock	24.46	24.49	24.43	24.45	4756494.0
2006-08-04 12:00:00	MSFT	Stock	24.453	24.46	24.32	24.35	5212127.0
2006-08-04 13:00:00	MSFT	Stock	24.35	24.39	24.24	24.27	5079458.0
2006-08-04 14:00:00	MSFT	Stock	24.27	24.32	24.16	24.22	4478903.0
2006-08-04 15:00:00	MSFT	Stock	24.22	24.3	24.15	24.3	7444097.0
2006-08-04 16:00:00	MSFT	Stock	24.3	24.31	24.14	24.29	3447499.0
2006-08-04 17:00:00	MSFT	Stock	24.21	24.24	24.19	24.22	6072.0
2006-08-04 18:00:00	MSFT	Stock	24.23	24.25	24.21	24.25	4379.0
2006-08-04 07:00:00	NVDA	Stock	0.395	0.395	0.395	0.395	6000.0
2006-08-04 08:00:00	NVDA	Stock	0.4077	0.4125	0.403	0.4125	2476020.0
2006-08-04 09:00:00	NVDA	Stock	0.4123	0.4167	0.4057	0.4123	97122720.0
2006-08-04 10:00:00	NVDA	Stock	0.4123	0.4128	0.4032	0.4108	111091440.0
2006-08-04 11:00:00	NVDA	Stock	0.4107	0.4115	0.4055	0.4058	68328480.0
2006-08-04 12:00:00	NVDA	Stock	0.4058	0.409	0.3975	0.3995	96531960.0
2006-08-04 13:00:00	NVDA	Stock	0.3995	0.4022	0.3958	0.3985	83993220.0
2006-08-04 14:00:00	NVDA	Stock	0.3983	0.4005	0.39	0.3905	98492160.0
2006-08-04 15:00:00	NVDA	Stock	0.3903	0.4013	0.3895	0.3998	166872360.0
2006-08-04 16:00:00	NVDA	Stock	0.4	0.4	0.3977	0.3977	1588500.0
2006-08-04 17:00:00	NVDA	Stock	0.3987	0.3987	0.3987	0.3987	6000.0
2006-08-04 08:00:00	AMZN	Stock	1.3395	1.3485	1.334	1.3415	352660.0
2006-08-04 09:00:00	AMZN	Stock	1.3425	1.36	1.3395	1.357	17177040.0
2006-08-04 10:00:00	AMZN	Stock	1.3565	1.3795	1.355	1.3695	56607240.0
2006-08-04 11:00:00	AMZN	Stock	1.3699	1.377	1.3675	1.375	31312420.0
2006-08-04 12:00:00	AMZN	Stock	1.375	1.376	1.36	1.364	29978160.0
2006-08-04 13:00:00	AMZN	Stock	1.364	1.37	1.35	1.351	18711700.0
2006-08-04 14:00:00	AMZN	Stock	1.351	1.357	1.3494	1.3529	18078720.0
2006-08-04 15:00:00	AMZN	Stock	1.3525	1.366	1.3505	1.3635	30552040.0
2006-08-04 16:00:00	AMZN	Stock	1.3645	1.367	1.3645	1.366	534820.0
2006-08-04 17:00:00	AMZN	Stock	1.3655	1.366	1.3655	1.366	28000.0
2006-08-04 18:00:00	AMZN	Stock	1.366	1.366	1.366	1.366	4000.0
2006-08-04 09:00:00	CL	Stock	29.15	29.18	29.1185	29.18	388400.0

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

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