PREVIEW / stock_1hour / 2009-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-10-01.parquet
  size:    940 KB
  rows:    45,825
  symbols: 3,379

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
2009-10-01 07:00:00	AAPL	Stock	6.59	6.6043	6.59	6.6025	60900.0
2009-10-01 08:00:00	AAPL	Stock	6.6204	6.6429	6.5982	6.6107	1705452.0
2009-10-01 09:00:00	AAPL	Stock	6.6118	6.6507	6.6	6.63	65767156.0
2009-10-01 10:00:00	AAPL	Stock	6.6275	6.6493	6.5536	6.5614	106290604.0
2009-10-01 11:00:00	AAPL	Stock	6.5611	6.5643	6.5121	6.5343	70056868.0
2009-10-01 12:00:00	AAPL	Stock	6.5343	6.5654	6.53	6.5382	44277016.0
2009-10-01 13:00:00	AAPL	Stock	6.5382	6.5393	6.5179	6.5289	57852256.0
2009-10-01 14:00:00	AAPL	Stock	6.5289	6.5421	6.52	6.5221	42817068.0
2009-10-01 15:00:00	AAPL	Stock	6.5221	6.5393	6.4536	6.4557	109830420.0
2009-10-01 16:00:00	AAPL	Stock	6.4575	6.5476	6.4364	6.4571	21032088.0
2009-10-01 17:00:00	AAPL	Stock	6.4546	6.4557	6.44	6.44	2072392.0
2009-10-01 18:00:00	AAPL	Stock	6.4411	6.4593	6.4343	6.4386	652092.0
2009-10-01 19:00:00	AAPL	Stock	6.4393	6.4479	6.4386	6.4464	263900.0
2009-10-01 20:00:00	AAPL	Stock	6.6196	6.6196	6.6196	6.6196	17612.0
2009-10-01 04:00:00	MSFT	Stock	25.67	25.67	25.6	25.6	1500.0
2009-10-01 05:00:00	MSFT	Stock	25.55	25.63	25.4	25.41	6889.0
2009-10-01 06:00:00	MSFT	Stock	25.45	25.53	25.4	25.53	11500.0
2009-10-01 07:00:00	MSFT	Stock	25.46	25.52	25.45	25.46	3500.0
2009-10-01 08:00:00	MSFT	Stock	25.48	25.89	25.45	25.46	443587.0
2009-10-01 09:00:00	MSFT	Stock	25.46	25.89	25.22	25.25	9805109.0
2009-10-01 10:00:00	MSFT	Stock	25.25	25.28	24.89	25.057	15310000.0
2009-10-01 11:00:00	MSFT	Stock	25.05	25.06	24.92	24.952	8944909.0
2009-10-01 12:00:00	MSFT	Stock	24.95	25.05	24.9	24.91	5429162.0
2009-10-01 13:00:00	MSFT	Stock	24.9	24.95	24.8	24.9	6762429.0
2009-10-01 14:00:00	MSFT	Stock	24.9	25.03	24.85	24.99	6229981.0
2009-10-01 15:00:00	MSFT	Stock	24.98	25.02	24.84	24.87	14795670.0
2009-10-01 16:00:00	MSFT	Stock	24.86	25.008	24.805	24.84	3194749.0
2009-10-01 17:00:00	MSFT	Stock	24.87	24.88	24.81	24.81	169734.0
2009-10-01 18:00:00	MSFT	Stock	24.81	24.88	24.76	24.8	100366.0
2009-10-01 19:00:00	MSFT	Stock	24.81	25.89	24.77	24.79	8632.0
2009-10-01 20:00:00	MSFT	Stock	25.72	25.72	25.72	25.72	2145.0
2009-10-01 04:00:00	NVDA	Stock	0.376	0.376	0.372	0.3758	36000.0
2009-10-01 05:00:00	NVDA	Stock	0.3675	0.3675	0.3675	0.3675	44000.0
2009-10-01 06:00:00	NVDA	Stock	0.3758	0.3758	0.3678	0.374	336360.0
2009-10-01 07:00:00	NVDA	Stock	0.3738	0.374	0.3703	0.3715	1427920.0
2009-10-01 08:00:00	NVDA	Stock	0.3733	0.3748	0.368	0.3725	4602120.0
2009-10-01 09:00:00	NVDA	Stock	0.3723	0.3748	0.3655	0.3678	124762640.0
2009-10-01 10:00:00	NVDA	Stock	0.3678	0.3685	0.3588	0.3592	254005880.0
2009-10-01 11:00:00	NVDA	Stock	0.3592	0.3592	0.3518	0.3555	125442440.0
2009-10-01 12:00:00	NVDA	Stock	0.3558	0.3598	0.3553	0.3562	100295560.0
2009-10-01 13:00:00	NVDA	Stock	0.3562	0.3562	0.3528	0.354	55555160.0
2009-10-01 14:00:00	NVDA	Stock	0.3538	0.355	0.3525	0.3534	81042880.0
2009-10-01 15:00:00	NVDA	Stock	0.3534	0.3535	0.3488	0.349	197979360.0
2009-10-01 16:00:00	NVDA	Stock	0.349	0.3577	0.348	0.353	11218840.0
2009-10-01 17:00:00	NVDA	Stock	0.351	0.351	0.349	0.3493	1239200.0
2009-10-01 18:00:00	NVDA	Stock	0.349	0.3498	0.347	0.347	498360.0
2009-10-01 19:00:00	NVDA	Stock	0.35	0.3758	0.347	0.3475	301240.0
2009-10-01 20:00:00	NVDA	Stock	0.3758	0.3758	0.3758	0.3758	398760.0
2009-10-01 08:00:00	AMZN	Stock	4.668	4.668	4.6425	4.6525	29280.0
2009-10-01 09:00:00	AMZN	Stock	4.64	4.668	4.6055	4.617	13429940.0

> showing 50 of 45,825 rows — these rows as CSV

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