PREVIEW / stock_1hour / 2006-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-27.parquet
  size:    622 KB
  rows:    29,573
  symbols: 2,288

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-06-27 07:00:00	AAPL	Stock	2.0946	2.0946	2.0893	2.0893	28000.0
2006-06-27 08:00:00	AAPL	Stock	2.1007	2.1036	2.0971	2.1029	520100.0
2006-06-27 09:00:00	AAPL	Stock	2.1039	2.115	2.0929	2.0961	48037304.0
2006-06-27 10:00:00	AAPL	Stock	2.0964	2.1025	2.0639	2.0657	142502108.0
2006-06-27 11:00:00	AAPL	Stock	2.0657	2.0743	2.0614	2.0689	82137776.0
2006-06-27 12:00:00	AAPL	Stock	2.0689	2.1116	2.0593	2.0618	51376724.0
2006-06-27 13:00:00	AAPL	Stock	2.0614	2.0711	2.0593	2.0668	38205804.0
2006-06-27 14:00:00	AAPL	Stock	2.0664	2.0711	2.0536	2.0582	58228772.0
2006-06-27 15:00:00	AAPL	Stock	2.0586	2.0732	2.05	2.0511	92299872.0
2006-06-27 16:00:00	AAPL	Stock	2.0514	2.0518	2.0446	2.0489	5202652.0
2006-06-27 17:00:00	AAPL	Stock	2.0468	2.0493	2.0464	2.0464	293720.0
2006-06-27 18:00:00	AAPL	Stock	2.0475	2.051	2.0464	2.0486	808696.0
2006-06-27 08:00:00	MSFT	Stock	22.8	22.88	22.8	22.88	20271.0
2006-06-27 09:00:00	MSFT	Stock	22.85	23.13	22.84	23.1	9831429.0
2006-06-27 10:00:00	MSFT	Stock	23.11	23.16	23.03	23.06	13435976.0
2006-06-27 11:00:00	MSFT	Stock	23.06	23.11	22.95	23.0	9437873.0
2006-06-27 12:00:00	MSFT	Stock	23.01	23.02	22.91	22.95	6445398.0
2006-06-27 13:00:00	MSFT	Stock	22.96	23.03	22.93	23.01	4852389.0
2006-06-27 14:00:00	MSFT	Stock	23.01	23.03	22.91	22.97	9101826.0
2006-06-27 15:00:00	MSFT	Stock	22.97	23.08	22.85	22.86	14041421.0
2006-06-27 16:00:00	MSFT	Stock	22.86	23.005	22.82	22.89	3574918.0
2006-06-27 17:00:00	MSFT	Stock	22.89	22.9	22.88	22.88	5600.0
2006-06-27 18:00:00	MSFT	Stock	22.859	22.88	22.859	22.86	216308.0
2006-06-27 08:00:00	NVDA	Stock	0.3358	0.3428	0.3355	0.3383	218400.0
2006-06-27 09:00:00	NVDA	Stock	0.3375	0.3377	0.3335	0.3342	27277680.0
2006-06-27 10:00:00	NVDA	Stock	0.3342	0.3348	0.3303	0.331	84373260.0
2006-06-27 11:00:00	NVDA	Stock	0.3308	0.3312	0.3243	0.3248	86396640.0
2006-06-27 12:00:00	NVDA	Stock	0.3247	0.3252	0.3202	0.3238	75376080.0
2006-06-27 13:00:00	NVDA	Stock	0.324	0.326	0.3237	0.3248	55661100.0
2006-06-27 14:00:00	NVDA	Stock	0.3248	0.3262	0.3238	0.3245	78236400.0
2006-06-27 15:00:00	NVDA	Stock	0.3243	0.3283	0.3233	0.3247	147324240.0
2006-06-27 16:00:00	NVDA	Stock	0.3262	0.3265	0.325	0.3265	1634880.0
2006-06-27 17:00:00	NVDA	Stock	0.3255	0.3255	0.3255	0.3255	30000.0
2006-06-27 18:00:00	NVDA	Stock	0.3258	0.3258	0.3246	0.3246	101340.0
2006-06-27 09:00:00	AMZN	Stock	1.84	1.869	1.8355	1.8685	15069060.0
2006-06-27 10:00:00	AMZN	Stock	1.8685	1.875	1.838	1.8425	29028240.0
2006-06-27 11:00:00	AMZN	Stock	1.8425	1.848	1.82	1.8416	16479500.0
2006-06-27 12:00:00	AMZN	Stock	1.842	1.8445	1.825	1.831	7171820.0
2006-06-27 13:00:00	AMZN	Stock	1.831	1.8385	1.829	1.8375	9525080.0
2006-06-27 14:00:00	AMZN	Stock	1.8375	1.841	1.8085	1.815	10123820.0
2006-06-27 15:00:00	AMZN	Stock	1.815	1.831	1.815	1.8245	16857020.0
2006-06-27 16:00:00	AMZN	Stock	1.825	1.8422	1.8235	1.8422	28100.0
2006-06-27 18:00:00	AMZN	Stock	1.8237	1.8237	1.8237	1.8237	18560.0
2006-06-27 08:00:00	CL	Stock	30.105	30.105	30.105	30.105	2800.0
2006-06-27 09:00:00	CL	Stock	30.05	30.065	29.93	30.035	334400.0
2006-06-27 10:00:00	CL	Stock	30.01	30.05	29.85	30.045	643000.0
2006-06-27 11:00:00	CL	Stock	30.045	30.085	30.005	30.035	1266200.0
2006-06-27 12:00:00	CL	Stock	30.035	30.08	30.0	30.04	670000.0
2006-06-27 13:00:00	CL	Stock	30.045	30.105	29.98	30.1	793000.0
2006-06-27 14:00:00	CL	Stock	30.095	30.1	29.945	30.01	590800.0

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

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