PREVIEW / stock_1hour / 2020-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-20.parquet
  size:    1.2 MB
  rows:    55,460
  symbols: 2,378

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-05-20 04:00:00	AAPL	Stock	78.755	79.0475	78.755	79.0475	22152.0
2020-05-20 05:00:00	AAPL	Stock	79.0675	79.1925	79.0675	79.1925	7200.0
2020-05-20 06:00:00	AAPL	Stock	79.13	79.375	79.13	79.3625	32104.0
2020-05-20 07:00:00	AAPL	Stock	79.3075	79.375	79.075	79.2225	216964.0
2020-05-20 08:00:00	AAPL	Stock	79.2	79.36	78.285	79.1375	388068.0
2020-05-20 09:00:00	AAPL	Stock	79.2	79.7575	79.05	79.7175	16663108.0
2020-05-20 10:00:00	AAPL	Stock	79.7225	79.765	79.38	79.6212	13125836.0
2020-05-20 11:00:00	AAPL	Stock	79.6225	79.88	79.5725	79.8125	11399164.0
2020-05-20 12:00:00	AAPL	Stock	79.8175	79.87	79.2775	79.655	11112824.0
2020-05-20 13:00:00	AAPL	Stock	79.655	79.715	79.355	79.5312	7902196.0
2020-05-20 14:00:00	AAPL	Stock	79.535	79.7375	79.33	79.7	9818328.0
2020-05-20 15:00:00	AAPL	Stock	79.7	79.84	79.505	79.79	14286996.0
2020-05-20 16:00:00	AAPL	Stock	79.8075	79.8875	79.7575	79.875	8939060.0
2020-05-20 17:00:00	AAPL	Stock	79.8875	79.8975	79.775	79.88	45312.0
2020-05-20 18:00:00	AAPL	Stock	79.88	79.9	79.7625	79.8075	64020.0
2020-05-20 19:00:00	AAPL	Stock	79.8125	79.8125	79.72	79.79	56960.0
2020-05-20 04:00:00	MSFT	Stock	184.15	185.5	184.15	185.45	1680.0
2020-05-20 05:00:00	MSFT	Stock	185.14	185.6	185.14	185.6	3399.0
2020-05-20 06:00:00	MSFT	Stock	185.55	185.6	185.31	185.55	3590.0
2020-05-20 07:00:00	MSFT	Stock	185.25	185.4	185.0	185.09	24456.0
2020-05-20 08:00:00	MSFT	Stock	185.196	185.43	183.12	185.19	45274.0
2020-05-20 09:00:00	MSFT	Stock	185.2	185.3	184.5	185.005	3473371.0
2020-05-20 10:00:00	MSFT	Stock	185.0	185.16	184.31	184.36	3667387.0
2020-05-20 11:00:00	MSFT	Stock	184.36	185.0	184.34	184.87	2767367.0
2020-05-20 12:00:00	MSFT	Stock	184.88	185.01	183.94	184.5	2566012.0
2020-05-20 13:00:00	MSFT	Stock	184.51	184.91	184.17	184.805	2170121.0
2020-05-20 14:00:00	MSFT	Stock	184.805	185.51	184.21	185.435	3389450.0
2020-05-20 15:00:00	MSFT	Stock	185.43	185.85	184.81	185.66	4293151.0
2020-05-20 16:00:00	MSFT	Stock	185.66	185.85	184.828	185.85	4520864.0
2020-05-20 17:00:00	MSFT	Stock	185.85	185.85	185.66	185.74	9780.0
2020-05-20 18:00:00	MSFT	Stock	185.7	185.88	185.57	185.6	14969.0
2020-05-20 19:00:00	MSFT	Stock	185.6	185.66	185.39	185.44	19651.0
2020-05-20 04:00:00	NVDA	Stock	8.9002	8.9625	8.9002	8.9595	52520.0
2020-05-20 05:00:00	NVDA	Stock	8.9463	9.0	8.9463	9.0	61760.0
2020-05-20 06:00:00	NVDA	Stock	8.9875	8.9993	8.9875	8.9925	55600.0
2020-05-20 07:00:00	NVDA	Stock	8.9875	8.9925	8.9698	8.9818	988880.0
2020-05-20 08:00:00	NVDA	Stock	8.9875	9.025	8.7835	8.9925	3044440.0
2020-05-20 09:00:00	NVDA	Stock	8.994	9.043	8.9195	9.0	95735320.0
2020-05-20 10:00:00	NVDA	Stock	8.9982	9.0125	8.9	8.934	107163160.0
2020-05-20 11:00:00	NVDA	Stock	8.9353	9.0062	8.9342	8.9648	52797440.0
2020-05-20 12:00:00	NVDA	Stock	8.9648	8.975	8.891	8.929	44123720.0
2020-05-20 13:00:00	NVDA	Stock	8.9302	8.9625	8.8888	8.9392	36969600.0
2020-05-20 14:00:00	NVDA	Stock	8.9405	8.975	8.8995	8.9686	42221360.0
2020-05-20 15:00:00	NVDA	Stock	8.9692	9.0103	8.9402	8.97	82697480.0
2020-05-20 16:00:00	NVDA	Stock	8.97	8.9963	8.97	8.9912	3456840.0
2020-05-20 17:00:00	NVDA	Stock	8.9912	9.0395	8.985	9.0375	1550920.0
2020-05-20 18:00:00	NVDA	Stock	9.0318	9.0395	9.0175	9.03	1248840.0
2020-05-20 19:00:00	NVDA	Stock	9.0325	9.0372	9.025	9.0312	1325600.0
2020-05-20 04:00:00	AMZN	Stock	123.25	123.25	123.25	123.25	5700.0
2020-05-20 05:00:00	AMZN	Stock	123.5	123.5	123.5	123.5	5980.0

> showing 50 of 55,460 rows — these rows as CSV

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