PREVIEW / stock_1hour / 2008-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-16.parquet
  size:    890 KB
  rows:    43,983
  symbols: 3,356

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
2008-09-16 06:00:00	AAPL	Stock	5.0	5.0	4.9446	4.9446	26824.0
2008-09-16 07:00:00	AAPL	Stock	4.9643	4.9804	4.9068	4.9639	772940.0
2008-09-16 08:00:00	AAPL	Stock	4.9393	4.9554	4.825	4.8254	6322372.0
2008-09-16 09:00:00	AAPL	Stock	4.825	4.8357	4.7196	4.7568	197291248.0
2008-09-16 10:00:00	AAPL	Stock	4.7546	4.955	4.7393	4.9444	245278404.0
2008-09-16 11:00:00	AAPL	Stock	4.9475	4.9865	4.8414	4.9136	133525756.0
2008-09-16 12:00:00	AAPL	Stock	4.9139	4.9811	4.9082	4.98	97821052.0
2008-09-16 13:00:00	AAPL	Stock	4.98	5.0	4.9232	4.9593	80569664.0
2008-09-16 14:00:00	AAPL	Stock	4.9595	5.0357	4.8382	5.0137	176109528.0
2008-09-16 15:00:00	AAPL	Stock	5.0118	5.0893	4.9686	4.9893	185636892.0
2008-09-16 16:00:00	AAPL	Stock	4.99	5.0282	4.8666	4.9607	46238276.0
2008-09-16 17:00:00	AAPL	Stock	4.9607	4.9964	4.9193	4.9889	9656388.0
2008-09-16 18:00:00	AAPL	Stock	4.9893	4.9893	4.9614	4.9732	133000.0
2008-09-16 19:00:00	AAPL	Stock	4.9643	5.0871	4.9643	5.0818	1194620.0
2008-09-16 05:00:00	MSFT	Stock	26.5	27.11	26.5	27.11	600.0
2008-09-16 06:00:00	MSFT	Stock	26.21	27.13	26.21	27.13	500.0
2008-09-16 08:00:00	MSFT	Stock	26.52	26.68	26.28	26.35	90352.0
2008-09-16 09:00:00	MSFT	Stock	26.29	26.49	25.65	26.0	17090647.0
2008-09-16 10:00:00	MSFT	Stock	26.0	26.15	25.89	26.07	18661314.0
2008-09-16 11:00:00	MSFT	Stock	26.07	26.29	25.79	25.99	10682935.0
2008-09-16 12:00:00	MSFT	Stock	25.99	26.12	25.86	26.06	8591049.0
2008-09-16 13:00:00	MSFT	Stock	26.07	26.11	25.77	25.88	7117780.0
2008-09-16 14:00:00	MSFT	Stock	25.87	26.05	25.52	25.97	19612386.0
2008-09-16 15:00:00	MSFT	Stock	25.98	26.25	25.75	25.99	18924213.0
2008-09-16 16:00:00	MSFT	Stock	25.92	26.175	25.8	25.8	7711515.0
2008-09-16 17:00:00	MSFT	Stock	25.99	26.0	25.8	25.99	1084604.0
2008-09-16 18:00:00	MSFT	Stock	25.85	25.91	25.81	25.9	4545.0
2008-09-16 19:00:00	MSFT	Stock	25.9	26.29	25.9	26.26	49544.0
2008-09-16 07:00:00	NVDA	Stock	0.225	0.225	0.225	0.225	171600.0
2008-09-16 08:00:00	NVDA	Stock	0.2312	0.2325	0.2258	0.2258	182400.0
2008-09-16 09:00:00	NVDA	Stock	0.2258	0.2295	0.2192	0.22	117110000.0
2008-09-16 10:00:00	NVDA	Stock	0.22	0.2328	0.22	0.232	201429680.0
2008-09-16 11:00:00	NVDA	Stock	0.232	0.2375	0.224	0.2368	139776640.0
2008-09-16 12:00:00	NVDA	Stock	0.2369	0.2405	0.2348	0.2349	121644640.0
2008-09-16 13:00:00	NVDA	Stock	0.2348	0.2368	0.2325	0.2338	205087080.0
2008-09-16 14:00:00	NVDA	Stock	0.2338	0.2388	0.2308	0.2372	199341480.0
2008-09-16 15:00:00	NVDA	Stock	0.237	0.2415	0.2359	0.2398	218206960.0
2008-09-16 16:00:00	NVDA	Stock	0.2405	0.2408	0.233	0.24	16349800.0
2008-09-16 17:00:00	NVDA	Stock	0.236	0.25	0.236	0.243	7530600.0
2008-09-16 18:00:00	NVDA	Stock	0.2412	0.2462	0.2412	0.2462	119280.0
2008-09-16 19:00:00	NVDA	Stock	0.2412	0.2462	0.2412	0.2462	48080.0
2008-09-16 06:00:00	AMZN	Stock	3.83	3.83	3.83	3.83	4000.0
2008-09-16 07:00:00	AMZN	Stock	3.83	3.83	3.83	3.83	2240.0
2008-09-16 08:00:00	AMZN	Stock	3.83	3.853	3.81	3.8505	183300.0
2008-09-16 09:00:00	AMZN	Stock	3.8505	3.95	3.8275	3.919	25829940.0
2008-09-16 10:00:00	AMZN	Stock	3.919	3.9815	3.9052	3.9295	55478060.0
2008-09-16 11:00:00	AMZN	Stock	3.93	3.9675	3.92	3.9445	29229380.0
2008-09-16 12:00:00	AMZN	Stock	3.9455	3.955	3.919	3.9378	23356740.0
2008-09-16 13:00:00	AMZN	Stock	3.9395	3.9535	3.9275	3.935	34120540.0
2008-09-16 14:00:00	AMZN	Stock	3.934	3.97	3.899	3.917	50540100.0

> showing 50 of 43,983 rows — these rows as CSV

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