PREVIEW / stock_1hour / 2020-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-12.parquet
  size:    1.2 MB
  rows:    51,936
  symbols: 2,415

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-12 04:00:00	AAPL	Stock	80.305	80.325	80.25	80.3125	16748.0
2020-02-12 05:00:00	AAPL	Stock	80.32	80.32	80.2075	80.2075	8916.0
2020-02-12 06:00:00	AAPL	Stock	80.3	80.315	80.225	80.25	17956.0
2020-02-12 07:00:00	AAPL	Stock	80.25	80.2975	80.155	80.2925	200864.0
2020-02-12 08:00:00	AAPL	Stock	80.25	80.475	80.15	80.4225	385560.0
2020-02-12 09:00:00	AAPL	Stock	80.425	80.9725	80.3075	80.8652	14261688.0
2020-02-12 10:00:00	AAPL	Stock	80.8725	80.913	80.575	80.81	12295348.0
2020-02-12 11:00:00	AAPL	Stock	80.8175	81.16	80.7925	81.0975	11429232.0
2020-02-12 12:00:00	AAPL	Stock	81.095	81.35	81.0	81.3225	9455028.0
2020-02-12 13:00:00	AAPL	Stock	81.325	81.335	81.1575	81.2875	6707172.0
2020-02-12 14:00:00	AAPL	Stock	81.2825	81.3825	81.1825	81.315	6335896.0
2020-02-12 15:00:00	AAPL	Stock	81.3175	81.8025	81.2175	81.8	18368592.0
2020-02-12 16:00:00	AAPL	Stock	81.8	81.8375	81.7	81.8	8826468.0
2020-02-12 17:00:00	AAPL	Stock	81.7775	81.8	81.7	81.7125	200900.0
2020-02-12 18:00:00	AAPL	Stock	81.7	81.8125	81.25	81.3025	296476.0
2020-02-12 19:00:00	AAPL	Stock	81.3875	81.445	81.125	81.2625	399264.0
2020-02-12 04:00:00	MSFT	Stock	185.5	186.37	185.5	186.37	16222.0
2020-02-12 05:00:00	MSFT	Stock	186.27	186.38	186.07	186.38	6469.0
2020-02-12 06:00:00	MSFT	Stock	186.19	186.5	186.19	186.35	7946.0
2020-02-12 07:00:00	MSFT	Stock	186.31	186.49	185.57	185.9	76532.0
2020-02-12 08:00:00	MSFT	Stock	186.4	186.49	184.9	186.04	184921.0
2020-02-12 09:00:00	MSFT	Stock	186.06	186.49	181.85	182.89	9229413.0
2020-02-12 10:00:00	MSFT	Stock	182.89	183.72	182.05	182.535	7688558.0
2020-02-12 11:00:00	MSFT	Stock	182.54	184.94	182.54	184.26	6146294.0
2020-02-12 12:00:00	MSFT	Stock	184.242	185.25	183.97	184.81	3084347.0
2020-02-12 13:00:00	MSFT	Stock	184.81	184.989	183.79	184.01	2620495.0
2020-02-12 14:00:00	MSFT	Stock	184.005	184.09	183.55	183.86	2314309.0
2020-02-12 15:00:00	MSFT	Stock	183.86	184.89	183.59	184.72	4700961.0
2020-02-12 16:00:00	MSFT	Stock	184.72	185.49	183.91	184.65	4968162.0
2020-02-12 17:00:00	MSFT	Stock	184.7	184.71	184.45	184.55	28083.0
2020-02-12 18:00:00	MSFT	Stock	184.56	184.84	183.0	183.21	47470.0
2020-02-12 19:00:00	MSFT	Stock	183.45	183.99	183.3	183.35	53111.0
2020-02-12 04:00:00	NVDA	Stock	6.7255	6.775	6.7255	6.7625	101760.0
2020-02-12 05:00:00	NVDA	Stock	6.7618	6.7618	6.751	6.751	31520.0
2020-02-12 06:00:00	NVDA	Stock	6.76	6.76	6.76	6.76	21960.0
2020-02-12 07:00:00	NVDA	Stock	6.7625	6.7875	6.7495	6.7685	2034720.0
2020-02-12 08:00:00	NVDA	Stock	6.785	6.7872	6.6808	6.7748	3001200.0
2020-02-12 09:00:00	NVDA	Stock	6.7818	6.8	6.7112	6.753	87900240.0
2020-02-12 10:00:00	NVDA	Stock	6.7536	6.7828	6.7276	6.7605	56177160.0
2020-02-12 11:00:00	NVDA	Stock	6.762	6.8075	6.7552	6.7695	43363920.0
2020-02-12 12:00:00	NVDA	Stock	6.7695	6.8072	6.7632	6.8038	35733640.0
2020-02-12 13:00:00	NVDA	Stock	6.8036	6.8064	6.7692	6.7818	24478480.0
2020-02-12 14:00:00	NVDA	Stock	6.7802	6.7882	6.7726	6.7745	28030920.0
2020-02-12 15:00:00	NVDA	Stock	6.7749	6.82	6.772	6.8135	61773080.0
2020-02-12 16:00:00	NVDA	Stock	6.8135	6.8485	6.8125	6.8438	20036120.0
2020-02-12 17:00:00	NVDA	Stock	6.846	6.8463	6.8135	6.825	1381640.0
2020-02-12 18:00:00	NVDA	Stock	6.825	6.8285	6.7625	6.8	1140400.0
2020-02-12 19:00:00	NVDA	Stock	6.8	6.8	6.77	6.785	1605480.0
2020-02-12 04:00:00	AMZN	Stock	107.865	108.1	107.865	108.05	28660.0
2020-02-12 05:00:00	AMZN	Stock	108.2	108.2	108.2	108.2	4560.0

> showing 50 of 51,936 rows — these rows as CSV

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