PREVIEW / stock_1hour / 2008-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-07.parquet
  size:    813 KB
  rows:    40,751
  symbols: 3,283

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-04-07 04:00:00	AAPL	Stock	5.5118	5.5118	5.5039	5.5039	28000.0
2008-04-07 05:00:00	AAPL	Stock	5.5232	5.5511	5.5232	5.5511	45360.0
2008-04-07 06:00:00	AAPL	Stock	5.5536	5.5743	5.5536	5.5536	378000.0
2008-04-07 07:00:00	AAPL	Stock	5.5436	5.5679	5.5321	5.56	684656.0
2008-04-07 08:00:00	AAPL	Stock	5.5582	5.5714	5.5407	5.5632	4875640.0
2008-04-07 09:00:00	AAPL	Stock	5.5625	5.6054	5.5489	5.5989	155090992.0
2008-04-07 10:00:00	AAPL	Stock	5.5996	5.6339	5.58	5.6307	185875088.0
2008-04-07 11:00:00	AAPL	Stock	5.6304	5.685	5.6211	5.6746	148591212.0
2008-04-07 12:00:00	AAPL	Stock	5.6739	5.7032	5.6643	5.6721	110618284.0
2008-04-07 13:00:00	AAPL	Stock	5.6721	5.6771	5.6	5.6136	131341084.0
2008-04-07 14:00:00	AAPL	Stock	5.6141	5.6182	5.5486	5.5775	207534180.0
2008-04-07 15:00:00	AAPL	Stock	5.5771	5.5968	5.5396	5.5686	183452948.0
2008-04-07 16:00:00	AAPL	Stock	5.5689	5.6173	5.5475	5.5625	10570476.0
2008-04-07 17:00:00	AAPL	Stock	5.5607	5.6167	5.5575	5.5643	1331904.0
2008-04-07 18:00:00	AAPL	Stock	5.5661	5.5714	5.5643	5.5714	251664.0
2008-04-07 19:00:00	AAPL	Stock	5.5696	5.5793	5.5696	5.5757	289744.0
2008-04-07 07:00:00	MSFT	Stock	29.56	29.56	29.5	29.5	3100.0
2008-04-07 08:00:00	MSFT	Stock	29.58	29.75	29.5	29.64	188326.0
2008-04-07 09:00:00	MSFT	Stock	29.69	29.7	29.3	29.47	6248524.0
2008-04-07 10:00:00	MSFT	Stock	29.47	29.51	29.25	29.3	6183788.0
2008-04-07 11:00:00	MSFT	Stock	29.31	29.362	29.11	29.252	5783527.0
2008-04-07 12:00:00	MSFT	Stock	29.258	29.35	29.13	29.17	4864291.0
2008-04-07 13:00:00	MSFT	Stock	29.172	29.24	29.09	29.11	5008654.0
2008-04-07 14:00:00	MSFT	Stock	29.11	29.19	29.04	29.06	5147514.0
2008-04-07 15:00:00	MSFT	Stock	29.06	29.23	29.03	29.16	8415034.0
2008-04-07 16:00:00	MSFT	Stock	29.16	29.361	29.1	29.2	1615662.0
2008-04-07 17:00:00	MSFT	Stock	29.18	29.18	29.11	29.12	55105.0
2008-04-07 18:00:00	MSFT	Stock	29.14	29.18	29.12	29.15	7720.0
2008-04-07 19:00:00	MSFT	Stock	29.15	29.15	29.12	29.12	5445.0
2008-04-07 08:00:00	NVDA	Stock	0.475	0.4812	0.4723	0.4785	3241000.0
2008-04-07 09:00:00	NVDA	Stock	0.4763	0.4875	0.4763	0.487	130251400.0
2008-04-07 10:00:00	NVDA	Stock	0.4872	0.4872	0.4812	0.4852	111222120.0
2008-04-07 11:00:00	NVDA	Stock	0.4855	0.4875	0.483	0.485	83533320.0
2008-04-07 12:00:00	NVDA	Stock	0.4852	0.4865	0.4812	0.4818	77981920.0
2008-04-07 13:00:00	NVDA	Stock	0.4818	0.488	0.4808	0.4852	79405560.0
2008-04-07 14:00:00	NVDA	Stock	0.4855	0.4858	0.479	0.4802	82037000.0
2008-04-07 15:00:00	NVDA	Stock	0.48	0.481	0.477	0.48	139163480.0
2008-04-07 16:00:00	NVDA	Stock	0.4808	0.4843	0.4763	0.4798	17256960.0
2008-04-07 17:00:00	NVDA	Stock	0.4828	0.4828	0.4788	0.4808	502120.0
2008-04-07 18:00:00	NVDA	Stock	0.4795	0.4808	0.4795	0.4808	496000.0
2008-04-07 19:00:00	NVDA	Stock	0.4812	0.4818	0.4812	0.4818	40000.0
2008-04-07 04:00:00	AMZN	Stock	3.853	3.853	3.853	3.853	10400.0
2008-04-07 08:00:00	AMZN	Stock	3.853	3.875	3.853	3.8725	39800.0
2008-04-07 09:00:00	AMZN	Stock	3.8725	3.9125	3.849	3.9125	13128400.0
2008-04-07 10:00:00	AMZN	Stock	3.9115	3.9215	3.8	3.8185	27598660.0
2008-04-07 11:00:00	AMZN	Stock	3.82	3.853	3.817	3.848	14050400.0
2008-04-07 12:00:00	AMZN	Stock	3.8475	3.871	3.8445	3.86	14009220.0
2008-04-07 13:00:00	AMZN	Stock	3.8605	3.8635	3.8445	3.8485	10320240.0
2008-04-07 14:00:00	AMZN	Stock	3.8482	3.8575	3.8416	3.846	19700400.0
2008-04-07 15:00:00	AMZN	Stock	3.846	3.8545	3.835	3.845	27956760.0

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

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