PREVIEW / stock_1hour / 2009-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-07.parquet
  size:    886 KB
  rows:    42,537
  symbols: 3,428

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-12-07 04:00:00	AAPL	Stock	6.8611	6.8611	6.8596	6.8596	12936.0
2009-12-07 07:00:00	AAPL	Stock	6.8782	6.9386	6.8782	6.9318	125104.0
2009-12-07 08:00:00	AAPL	Stock	6.9454	6.9464	6.9007	6.9021	1061872.0
2009-12-07 09:00:00	AAPL	Stock	6.9046	6.9204	6.7414	6.8004	161660352.0
2009-12-07 10:00:00	AAPL	Stock	6.7993	6.8618	6.7714	6.8393	138228860.0
2009-12-07 11:00:00	AAPL	Stock	6.8386	6.8457	6.7946	6.8154	53924752.0
2009-12-07 12:00:00	AAPL	Stock	6.8154	6.8332	6.8036	6.8043	40999280.0
2009-12-07 13:00:00	AAPL	Stock	6.8043	6.8571	6.8036	6.8136	67546864.0
2009-12-07 14:00:00	AAPL	Stock	6.8136	6.8175	6.7579	6.7707	84226268.0
2009-12-07 15:00:00	AAPL	Stock	6.7718	6.7779	6.7386	6.75	143772944.0
2009-12-07 16:00:00	AAPL	Stock	6.7507	6.8112	6.7427	6.7607	11867296.0
2009-12-07 17:00:00	AAPL	Stock	6.9043	6.9043	6.76	6.7714	1372952.0
2009-12-07 18:00:00	AAPL	Stock	6.7679	6.7796	6.7482	6.7796	923860.0
2009-12-07 19:00:00	AAPL	Stock	6.7796	6.7818	6.7743	6.7786	280448.0
2009-12-07 04:00:00	MSFT	Stock	29.8	29.8	29.78	29.78	490.0
2009-12-07 07:00:00	MSFT	Stock	29.8	29.8	29.79	29.79	2200.0
2009-12-07 08:00:00	MSFT	Stock	29.89	29.96	29.86	29.88	6633.0
2009-12-07 09:00:00	MSFT	Stock	29.91	30.08	29.7	29.95	5166961.0
2009-12-07 10:00:00	MSFT	Stock	29.95	29.98	29.83	29.87	6342570.0
2009-12-07 11:00:00	MSFT	Stock	29.87	29.915	29.84	29.862	3953074.0
2009-12-07 12:00:00	MSFT	Stock	29.87	29.93	29.85	29.881	3492317.0
2009-12-07 13:00:00	MSFT	Stock	29.88	29.89	29.78	29.86	3958688.0
2009-12-07 14:00:00	MSFT	Stock	29.85	29.88	29.68	29.7	5168406.0
2009-12-07 15:00:00	MSFT	Stock	29.71	29.82	29.68	29.78	6831901.0
2009-12-07 16:00:00	MSFT	Stock	29.8	29.89	29.72	29.89	1581879.0
2009-12-07 17:00:00	MSFT	Stock	29.98	29.98	29.72	29.74	3900.0
2009-12-07 18:00:00	MSFT	Stock	29.75	29.76	29.75	29.75	1500.0
2009-12-07 19:00:00	MSFT	Stock	29.76	29.8	29.76	29.8	4725.0
2009-12-07 20:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	29800.0
2009-12-07 05:00:00	NVDA	Stock	0.3748	0.3748	0.3748	0.3748	4000.0
2009-12-07 06:00:00	NVDA	Stock	0.3642	0.3642	0.3642	0.3642	4000.0
2009-12-07 07:00:00	NVDA	Stock	0.3642	0.3725	0.3642	0.3725	288200.0
2009-12-07 08:00:00	NVDA	Stock	0.3728	0.4013	0.3728	0.3945	36444320.0
2009-12-07 09:00:00	NVDA	Stock	0.395	0.4125	0.3915	0.4065	720782120.0
2009-12-07 10:00:00	NVDA	Stock	0.4062	0.4068	0.3962	0.4038	604181400.0
2009-12-07 11:00:00	NVDA	Stock	0.4037	0.4062	0.399	0.4048	367778800.0
2009-12-07 12:00:00	NVDA	Stock	0.4048	0.4051	0.402	0.4045	159718600.0
2009-12-07 13:00:00	NVDA	Stock	0.4045	0.4065	0.3775	0.4036	279916680.0
2009-12-07 14:00:00	NVDA	Stock	0.4035	0.4045	0.3973	0.4013	266155920.0
2009-12-07 15:00:00	NVDA	Stock	0.4013	0.4038	0.3998	0.4022	264141520.0
2009-12-07 16:00:00	NVDA	Stock	0.4025	0.4048	0.4015	0.4018	28227720.0
2009-12-07 17:00:00	NVDA	Stock	0.4018	0.403	0.4018	0.403	305360.0
2009-12-07 18:00:00	NVDA	Stock	0.403	0.403	0.4013	0.4013	328640.0
2009-12-07 19:00:00	NVDA	Stock	0.4018	0.4025	0.4013	0.4025	541240.0
2009-12-07 04:00:00	AMZN	Stock	6.85	6.85	6.85	6.85	4000.0
2009-12-07 06:00:00	AMZN	Stock	6.915	6.915	6.915	6.915	10000.0
2009-12-07 07:00:00	AMZN	Stock	6.905	6.9055	6.8905	6.8955	70640.0
2009-12-07 08:00:00	AMZN	Stock	6.905	6.905	6.863	6.865	339540.0
2009-12-07 09:00:00	AMZN	Stock	6.865	6.95	6.8015	6.8715	28111240.0
2009-12-07 10:00:00	AMZN	Stock	6.8715	6.912	6.853	6.872	18824400.0

> showing 50 of 42,537 rows — these rows as CSV

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