PREVIEW / stock_1hour / 2008-08-05

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-08-05.parquet
  size:    841 KB
  rows:    40,278
  symbols: 3,316

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-08-05 07:00:00	AAPL	Stock	5.5586	5.5796	5.5357	5.5511	464380.0
2008-08-05 08:00:00	AAPL	Stock	5.5504	5.5625	5.5304	5.5536	2847516.0
2008-08-05 09:00:00	AAPL	Stock	5.5529	5.5861	5.5293	5.5704	99631840.0
2008-08-05 10:00:00	AAPL	Stock	5.5714	5.6036	5.5686	5.6029	97799688.0
2008-08-05 11:00:00	AAPL	Stock	5.6029	5.6386	5.5964	5.6336	77959084.0
2008-08-05 12:00:00	AAPL	Stock	5.6336	5.6343	5.6121	5.6243	49689332.0
2008-08-05 13:00:00	AAPL	Stock	5.6243	5.6418	5.6207	5.636	47465068.0
2008-08-05 14:00:00	AAPL	Stock	5.6371	5.7089	5.625	5.6989	140863016.0
2008-08-05 15:00:00	AAPL	Stock	5.6989	5.7429	5.6679	5.7339	145218892.0
2008-08-05 16:00:00	AAPL	Stock	5.7339	5.7571	5.6371	5.75	23447508.0
2008-08-05 17:00:00	AAPL	Stock	5.75	5.7671	5.7421	5.7582	796992.0
2008-08-05 18:00:00	AAPL	Stock	5.7536	5.7536	5.7471	5.7482	310268.0
2008-08-05 19:00:00	AAPL	Stock	5.7479	5.7511	5.7471	5.7471	186032.0
2008-08-05 07:00:00	MSFT	Stock	25.59	25.59	25.39	25.52	800.0
2008-08-05 08:00:00	MSFT	Stock	25.28	25.5	25.28	25.5	71921.0
2008-08-05 09:00:00	MSFT	Stock	25.5	25.69	25.42	25.63	5266009.0
2008-08-05 10:00:00	MSFT	Stock	25.63	25.75	25.6	25.72	11484799.0
2008-08-05 11:00:00	MSFT	Stock	25.72	25.99	25.71	25.94	12106059.0
2008-08-05 12:00:00	MSFT	Stock	25.94	26.11	25.84	26.1	10075056.0
2008-08-05 13:00:00	MSFT	Stock	26.09	26.12	25.9	25.9	7896692.0
2008-08-05 14:00:00	MSFT	Stock	25.91	26.24	25.86	26.12	11786187.0
2008-08-05 15:00:00	MSFT	Stock	26.12	26.28	26.07	26.19	15152539.0
2008-08-05 16:00:00	MSFT	Stock	26.21	26.22	25.932	26.21	6201958.0
2008-08-05 17:00:00	MSFT	Stock	26.2	26.32	26.2	26.31	71869.0
2008-08-05 18:00:00	MSFT	Stock	26.28	26.28	26.27	26.28	5400.0
2008-08-05 19:00:00	MSFT	Stock	26.27	26.31	26.27	26.31	5650.0
2008-08-05 20:00:00	MSFT	Stock	26.21	26.21	26.21	26.21	1000.0
2008-08-05 08:00:00	NVDA	Stock	0.2672	0.2672	0.2663	0.2672	72000.0
2008-08-05 09:00:00	NVDA	Stock	0.267	0.2698	0.2665	0.2685	46284200.0
2008-08-05 10:00:00	NVDA	Stock	0.2685	0.271	0.2683	0.2705	82662200.0
2008-08-05 11:00:00	NVDA	Stock	0.2708	0.2745	0.2705	0.2745	97086880.0
2008-08-05 12:00:00	NVDA	Stock	0.2745	0.2745	0.273	0.2735	49758360.0
2008-08-05 13:00:00	NVDA	Stock	0.2736	0.2763	0.2732	0.2748	89404600.0
2008-08-05 14:00:00	NVDA	Stock	0.275	0.2788	0.2735	0.2783	107701000.0
2008-08-05 15:00:00	NVDA	Stock	0.2783	0.2795	0.2763	0.2795	183303720.0
2008-08-05 16:00:00	NVDA	Stock	0.2798	0.2798	0.2744	0.2798	6581480.0
2008-08-05 17:00:00	NVDA	Stock	0.2792	0.2838	0.2775	0.2805	626200.0
2008-08-05 18:00:00	NVDA	Stock	0.283	0.283	0.28	0.2812	274000.0
2008-08-05 19:00:00	NVDA	Stock	0.2812	0.283	0.2812	0.283	38000.0
2008-08-05 08:00:00	AMZN	Stock	3.834	3.834	3.834	3.834	4000.0
2008-08-05 09:00:00	AMZN	Stock	3.8325	3.874	3.83	3.841	15088580.0
2008-08-05 10:00:00	AMZN	Stock	3.841	3.869	3.826	3.85	20811440.0
2008-08-05 11:00:00	AMZN	Stock	3.85	3.8655	3.8455	3.859	11544100.0
2008-08-05 12:00:00	AMZN	Stock	3.859	3.8975	3.853	3.894	10861460.0
2008-08-05 13:00:00	AMZN	Stock	3.894	3.909	3.88	3.893	15193280.0
2008-08-05 14:00:00	AMZN	Stock	3.893	3.976	3.8745	3.9635	27669560.0
2008-08-05 15:00:00	AMZN	Stock	3.963	3.965	3.9415	3.9485	47933580.0
2008-08-05 16:00:00	AMZN	Stock	3.949	3.96	3.9048	3.95	5104760.0
2008-08-05 17:00:00	AMZN	Stock	3.951	3.9625	3.951	3.9625	10000.0
2008-08-05 19:00:00	AMZN	Stock	3.966	3.9795	3.966	3.9795	29100.0

> showing 50 of 40,278 rows — these rows as CSV

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