PREVIEW / stock_1hour / 2020-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-07.parquet
  size:    1.1 MB
  rows:    50,700
  symbols: 2,425

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
2020-02-07 04:00:00	AAPL	Stock	81.2225	81.2225	80.925	80.95	132600.0
2020-02-07 05:00:00	AAPL	Stock	80.8775	80.8775	80.6275	80.6775	141468.0
2020-02-07 06:00:00	AAPL	Stock	80.68	80.875	80.5525	80.875	80316.0
2020-02-07 07:00:00	AAPL	Stock	80.845	81.0	80.7525	80.95	264968.0
2020-02-07 08:00:00	AAPL	Stock	80.975	81.1	80.6875	80.7925	769448.0
2020-02-07 09:00:00	AAPL	Stock	80.7928	80.8875	80.1625	80.3025	17231612.0
2020-02-07 10:00:00	AAPL	Stock	80.295	80.83	80.11	80.5942	17450340.0
2020-02-07 11:00:00	AAPL	Stock	80.5938	80.85	80.4375	80.71	8947684.0
2020-02-07 12:00:00	AAPL	Stock	80.7125	80.85	80.6425	80.6475	5448632.0
2020-02-07 13:00:00	AAPL	Stock	80.645	80.6875	79.75	80.185	7288580.0
2020-02-07 14:00:00	AAPL	Stock	80.1825	80.2525	79.5825	79.8925	15324688.0
2020-02-07 15:00:00	AAPL	Stock	79.89	80.015	79.5	80.01	18128768.0
2020-02-07 16:00:00	AAPL	Stock	80.0075	80.0075	79.95	79.99	5809864.0
2020-02-07 17:00:00	AAPL	Stock	79.995	80.0075	79.9125	79.9125	153672.0
2020-02-07 18:00:00	AAPL	Stock	79.92	79.92	79.8375	79.84	112824.0
2020-02-07 19:00:00	AAPL	Stock	79.8375	79.92	79.75	79.8725	128660.0
2020-02-07 04:00:00	MSFT	Stock	183.49	183.5	183.0	183.0	8775.0
2020-02-07 05:00:00	MSFT	Stock	182.91	183.0	182.68	182.88	4013.0
2020-02-07 06:00:00	MSFT	Stock	182.68	183.0	182.5	183.0	6194.0
2020-02-07 07:00:00	MSFT	Stock	182.95	183.17	182.8	183.0	30957.0
2020-02-07 08:00:00	MSFT	Stock	182.87	183.7	182.72	183.05	73236.0
2020-02-07 09:00:00	MSFT	Stock	182.9	184.78	182.48	183.926	4527331.0
2020-02-07 10:00:00	MSFT	Stock	183.92	185.36	183.41	184.843	4389391.0
2020-02-07 11:00:00	MSFT	Stock	184.845	185.63	184.65	185.42	2848803.0
2020-02-07 12:00:00	MSFT	Stock	185.415	185.457	184.9	185.15	1907474.0
2020-02-07 13:00:00	MSFT	Stock	185.155	185.16	183.95	184.13	2309866.0
2020-02-07 14:00:00	MSFT	Stock	184.13	184.17	182.82	184.0	3559933.0
2020-02-07 15:00:00	MSFT	Stock	184.002	184.23	183.55	183.95	3828462.0
2020-02-07 16:00:00	MSFT	Stock	183.89	183.99	183.71	183.829	6250731.0
2020-02-07 17:00:00	MSFT	Stock	183.819	183.819	183.51	183.6	23011.0
2020-02-07 18:00:00	MSFT	Stock	183.6	183.75	183.57	183.7	6807.0
2020-02-07 19:00:00	MSFT	Stock	183.7	183.7	183.5	183.63	6679.0
2020-02-07 04:00:00	NVDA	Stock	6.35	6.35	6.325	6.325	12120.0
2020-02-07 05:00:00	NVDA	Stock	6.3	6.3	6.2755	6.2755	40000.0
2020-02-07 06:00:00	NVDA	Stock	6.2935	6.3	6.2935	6.3	15400.0
2020-02-07 07:00:00	NVDA	Stock	6.3068	6.325	6.3062	6.325	679120.0
2020-02-07 08:00:00	NVDA	Stock	6.315	6.328	6.3	6.3125	856760.0
2020-02-07 09:00:00	NVDA	Stock	6.307	6.3343	6.2643	6.2955	27588520.0
2020-02-07 10:00:00	NVDA	Stock	6.296	6.3383	6.2788	6.3161	23609760.0
2020-02-07 11:00:00	NVDA	Stock	6.3156	6.3322	6.3059	6.3145	14462000.0
2020-02-07 12:00:00	NVDA	Stock	6.3145	6.3352	6.3135	6.3334	10695280.0
2020-02-07 13:00:00	NVDA	Stock	6.3333	6.3333	6.2845	6.2859	11495760.0
2020-02-07 14:00:00	NVDA	Stock	6.2853	6.2982	6.2693	6.2892	18231120.0
2020-02-07 15:00:00	NVDA	Stock	6.2895	6.297	6.2733	6.292	29627800.0
2020-02-07 16:00:00	NVDA	Stock	6.2898	6.2925	6.275	6.275	18126360.0
2020-02-07 17:00:00	NVDA	Stock	6.2758	6.28	6.2758	6.2763	115200.0
2020-02-07 18:00:00	NVDA	Stock	6.2653	6.2812	6.2653	6.2725	69040.0
2020-02-07 19:00:00	NVDA	Stock	6.275	6.2875	6.275	6.2875	116840.0
2020-02-07 04:00:00	AMZN	Stock	102.1575	102.1575	102.1575	102.1575	2000.0
2020-02-07 05:00:00	AMZN	Stock	102.027	102.053	102.0	102.0	12520.0

> showing 50 of 50,700 rows — these rows as CSV

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