PREVIEW / stock_1hour / 2020-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-18.parquet
  size:    1.2 MB
  rows:    56,590
  symbols: 2,382

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-18 04:00:00	AAPL	Stock	77.465	77.7	77.465	77.5775	25216.0
2020-05-18 05:00:00	AAPL	Stock	77.625	77.625	77.1425	77.32	56072.0
2020-05-18 06:00:00	AAPL	Stock	77.3625	77.5	77.235	77.5	32280.0
2020-05-18 07:00:00	AAPL	Stock	77.4925	78.325	77.3925	78.3	430732.0
2020-05-18 08:00:00	AAPL	Stock	77.725	78.605	77.1175	78.3	1045016.0
2020-05-18 09:00:00	AAPL	Stock	78.2975	78.32	77.581	78.0945	17639312.0
2020-05-18 10:00:00	AAPL	Stock	78.095	78.4525	77.8525	78.41	17007236.0
2020-05-18 11:00:00	AAPL	Stock	78.4075	78.535	78.285	78.495	11889744.0
2020-05-18 12:00:00	AAPL	Stock	78.4925	78.75	78.4375	78.7195	11432928.0
2020-05-18 13:00:00	AAPL	Stock	78.7225	79.05	78.6925	78.8425	12481988.0
2020-05-18 14:00:00	AAPL	Stock	78.8475	78.935	78.6175	78.73	8578316.0
2020-05-18 15:00:00	AAPL	Stock	78.7325	79.125	78.5082	78.7225	19830516.0
2020-05-18 16:00:00	AAPL	Stock	78.7225	78.8125	78.6275	78.6875	11510072.0
2020-05-18 17:00:00	AAPL	Stock	78.65	78.725	78.6125	78.665	26880.0
2020-05-18 18:00:00	AAPL	Stock	78.6625	78.975	78.66	78.8925	67708.0
2020-05-18 19:00:00	AAPL	Stock	78.8875	78.9875	78.775	78.925	60908.0
2020-05-18 04:00:00	MSFT	Stock	184.2	185.2	184.2	185.0	8056.0
2020-05-18 05:00:00	MSFT	Stock	184.96	184.96	184.68	184.68	1698.0
2020-05-18 06:00:00	MSFT	Stock	184.8	185.16	184.61	185.1	7775.0
2020-05-18 07:00:00	MSFT	Stock	185.03	186.2	184.75	186.2	64518.0
2020-05-18 08:00:00	MSFT	Stock	184.9	186.68	183.61	186.0	186488.0
2020-05-18 09:00:00	MSFT	Stock	185.85	186.12	183.96	184.68	4506554.0
2020-05-18 10:00:00	MSFT	Stock	184.68	185.57	184.52	185.57	4447819.0
2020-05-18 11:00:00	MSFT	Stock	185.57	185.699	184.83	185.131	3482899.0
2020-05-18 12:00:00	MSFT	Stock	185.135	185.42	184.79	185.24	2532002.0
2020-05-18 13:00:00	MSFT	Stock	185.25	186.2	185.195	185.76	3006095.0
2020-05-18 14:00:00	MSFT	Stock	185.76	186.0	184.87	184.93	2803282.0
2020-05-18 15:00:00	MSFT	Stock	184.93	186.0	184.58	184.9	5658165.0
2020-05-18 16:00:00	MSFT	Stock	184.9	185.265	184.5	184.91	4246703.0
2020-05-18 17:00:00	MSFT	Stock	184.88	185.0	184.71	184.75	7225.0
2020-05-18 18:00:00	MSFT	Stock	184.95	185.35	184.72	185.2	20015.0
2020-05-18 19:00:00	MSFT	Stock	185.19	185.44	185.0	185.2	10651.0
2020-05-18 04:00:00	NVDA	Stock	8.6308	8.6622	8.6235	8.6235	188400.0
2020-05-18 05:00:00	NVDA	Stock	8.6272	8.63	8.6088	8.625	118760.0
2020-05-18 06:00:00	NVDA	Stock	8.6248	8.675	8.6248	8.6718	238680.0
2020-05-18 07:00:00	NVDA	Stock	8.651	8.767	8.65	8.767	4133640.0
2020-05-18 08:00:00	NVDA	Stock	8.7695	8.818	8.4698	8.7625	6228640.0
2020-05-18 09:00:00	NVDA	Stock	8.7688	8.9165	8.6963	8.7705	162769040.0
2020-05-18 10:00:00	NVDA	Stock	8.7709	8.822	8.7	8.818	112117400.0
2020-05-18 11:00:00	NVDA	Stock	8.8185	8.8195	8.7512	8.79	69259680.0
2020-05-18 12:00:00	NVDA	Stock	8.7923	8.8138	8.7505	8.8	61380000.0
2020-05-18 13:00:00	NVDA	Stock	8.8013	8.8725	8.7975	8.8149	64672560.0
2020-05-18 14:00:00	NVDA	Stock	8.8165	8.8325	8.708	8.7252	66863160.0
2020-05-18 15:00:00	NVDA	Stock	8.7255	8.7953	8.6805	8.7505	112077560.0
2020-05-18 16:00:00	NVDA	Stock	8.7502	8.7625	8.7376	8.7475	9466720.0
2020-05-18 17:00:00	NVDA	Stock	8.7438	8.7548	8.7438	8.7502	238880.0
2020-05-18 18:00:00	NVDA	Stock	8.75	8.7625	8.7455	8.755	1275480.0
2020-05-18 19:00:00	NVDA	Stock	8.755	8.755	8.7463	8.7508	476040.0
2020-05-18 07:00:00	AMZN	Stock	120.3	120.845	120.2105	120.6025	212780.0
2020-05-18 08:00:00	AMZN	Stock	120.7992	120.825	120.015	120.3	395020.0

> showing 50 of 56,590 rows — these rows as CSV

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