PREVIEW / stock_1hour / 2009-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-02.parquet
  size:    890 KB
  rows:    44,488
  symbols: 3,314

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-07-02 07:00:00	AAPL	Stock	5.05	5.0714	5.05	5.0714	5600.0
2009-07-02 08:00:00	AAPL	Stock	5.0768	5.0975	5.0393	5.04	1519616.0
2009-07-02 09:00:00	AAPL	Stock	5.0411	5.0518	4.9929	5.0004	69642944.0
2009-07-02 10:00:00	AAPL	Stock	5.0025	5.0357	5.0017	5.0171	87084508.0
2009-07-02 11:00:00	AAPL	Stock	5.0178	5.0178	4.9925	5.0136	54424692.0
2009-07-02 12:00:00	AAPL	Stock	5.0136	5.0232	5.0025	5.0061	33014100.0
2009-07-02 13:00:00	AAPL	Stock	5.0071	5.0193	5.0061	5.0093	23161152.0
2009-07-02 14:00:00	AAPL	Stock	5.0089	5.0264	5.0071	5.0204	24061548.0
2009-07-02 15:00:00	AAPL	Stock	5.0196	5.0204	5.0007	5.0011	59625272.0
2009-07-02 16:00:00	AAPL	Stock	5.0011	5.0126	4.9936	5.0018	9260972.0
2009-07-02 17:00:00	AAPL	Stock	5.0127	5.0127	4.9896	4.9939	2601648.0
2009-07-02 18:00:00	AAPL	Stock	5.0007	5.0007	4.9932	4.9996	944692.0
2009-07-02 19:00:00	AAPL	Stock	4.9964	4.9964	4.9929	4.9929	90076.0
2009-07-02 08:00:00	MSFT	Stock	23.99	23.99	23.72	23.75	32494.0
2009-07-02 09:00:00	MSFT	Stock	23.8	23.82	23.25	23.32	9123953.0
2009-07-02 10:00:00	MSFT	Stock	23.31	23.44	23.25	23.41	11654972.0
2009-07-02 11:00:00	MSFT	Stock	23.41	23.43	23.21	23.3	6894350.0
2009-07-02 12:00:00	MSFT	Stock	23.3	23.36	23.24	23.34	5002064.0
2009-07-02 13:00:00	MSFT	Stock	23.34	23.42	23.31	23.37	5272544.0
2009-07-02 14:00:00	MSFT	Stock	23.37	23.44	23.32	23.32	7274998.0
2009-07-02 15:00:00	MSFT	Stock	23.325	23.52	23.31	23.36	15157289.0
2009-07-02 16:00:00	MSFT	Stock	23.34	23.41	23.32	23.37	1975035.0
2009-07-02 17:00:00	MSFT	Stock	23.39	23.39	23.37	23.39	893326.0
2009-07-02 18:00:00	MSFT	Stock	23.39	23.39	23.37	23.37	33987.0
2009-07-02 19:00:00	MSFT	Stock	23.39	23.39	23.37	23.38	705.0
2009-07-02 07:00:00	NVDA	Stock	0.275	0.275	0.2738	0.274	192000.0
2009-07-02 08:00:00	NVDA	Stock	0.274	0.2775	0.274	0.275	1085360.0
2009-07-02 09:00:00	NVDA	Stock	0.2758	0.2778	0.2715	0.273	95237440.0
2009-07-02 10:00:00	NVDA	Stock	0.273	0.274	0.2688	0.273	123912680.0
2009-07-02 11:00:00	NVDA	Stock	0.273	0.2743	0.271	0.2715	62295720.0
2009-07-02 12:00:00	NVDA	Stock	0.2715	0.2735	0.2695	0.2732	65519600.0
2009-07-02 13:00:00	NVDA	Stock	0.2735	0.275	0.2732	0.2738	40909000.0
2009-07-02 14:00:00	NVDA	Stock	0.2738	0.275	0.2738	0.275	30262560.0
2009-07-02 15:00:00	NVDA	Stock	0.275	0.2752	0.2715	0.2723	107978200.0
2009-07-02 16:00:00	NVDA	Stock	0.2725	0.2738	0.2708	0.2725	15889480.0
2009-07-02 17:00:00	NVDA	Stock	0.2725	0.2735	0.272	0.272	2904200.0
2009-07-02 18:00:00	NVDA	Stock	0.2695	0.2725	0.2695	0.2725	29520.0
2009-07-02 19:00:00	NVDA	Stock	0.2725	0.2752	0.2725	0.2752	28000.0
2009-07-02 07:00:00	AMZN	Stock	4.119	4.119	4.119	4.119	6000.0
2009-07-02 08:00:00	AMZN	Stock	4.07	4.073	4.027	4.027	184820.0
2009-07-02 09:00:00	AMZN	Stock	4.027	4.0685	3.9255	3.9455	36880160.0
2009-07-02 10:00:00	AMZN	Stock	3.9449	3.9885	3.9325	3.9845	26843700.0
2009-07-02 11:00:00	AMZN	Stock	3.9845	4.0065	3.955	3.963	19460400.0
2009-07-02 12:00:00	AMZN	Stock	3.962	3.9827	3.9595	3.9827	9028480.0
2009-07-02 13:00:00	AMZN	Stock	3.9815	4.0085	3.9815	3.984	11278060.0
2009-07-02 14:00:00	AMZN	Stock	3.985	4.0	3.9685	3.999	10592080.0
2009-07-02 15:00:00	AMZN	Stock	4.0	4.0	3.9605	3.966	25135820.0
2009-07-02 16:00:00	AMZN	Stock	3.966	3.9833	3.955	3.966	2791520.0
2009-07-02 17:00:00	AMZN	Stock	3.9758	3.9758	3.95	3.952	1030780.0
2009-07-02 18:00:00	AMZN	Stock	3.966	3.966	3.9595	3.9595	9580.0

> showing 50 of 44,488 rows — these rows as CSV

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