PREVIEW / stock_1hour / 2020-10-08

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-08.parquet
  size:    1.3 MB
  rows:    58,212
  symbols: 2,520

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-10-08 04:00:00	AAPL	Stock	116.0	116.1	115.78	116.03	50903.0
2020-10-08 05:00:00	AAPL	Stock	116.05	116.34	116.01	116.19	38598.0
2020-10-08 06:00:00	AAPL	Stock	116.1	116.34	115.79	115.99	38435.0
2020-10-08 07:00:00	AAPL	Stock	115.91	116.28	115.8	116.25	345691.0
2020-10-08 08:00:00	AAPL	Stock	116.0	116.5	115.85	116.18	782737.0
2020-10-08 09:00:00	AAPL	Stock	116.18	116.4	115.36	115.528	13657498.0
2020-10-08 10:00:00	AAPL	Stock	115.525	115.69	115.05	115.265	11405036.0
2020-10-08 11:00:00	AAPL	Stock	115.27	115.78	114.92	115.23	11710960.0
2020-10-08 12:00:00	AAPL	Stock	115.24	115.54	115.16	115.26	6800060.0
2020-10-08 13:00:00	AAPL	Stock	115.265	115.3	114.65	114.715	7973776.0
2020-10-08 14:00:00	AAPL	Stock	114.71	115.14	114.59	115.1	7921951.0
2020-10-08 15:00:00	AAPL	Stock	115.105	115.13	114.78	114.97	9856918.0
2020-10-08 16:00:00	AAPL	Stock	114.97	115.19	114.83	115.08	5377175.0
2020-10-08 17:00:00	AAPL	Stock	115.08	115.16	115.02	115.12	149033.0
2020-10-08 18:00:00	AAPL	Stock	115.13	115.199	115.05	115.19	393695.0
2020-10-08 19:00:00	AAPL	Stock	115.2	115.28	115.17	115.27	171831.0
2020-10-08 04:00:00	MSFT	Stock	210.37	210.8	210.37	210.44	1710.0
2020-10-08 05:00:00	MSFT	Stock	210.33	210.6	210.31	210.31	1940.0
2020-10-08 06:00:00	MSFT	Stock	210.14	210.54	209.79	210.27	12712.0
2020-10-08 07:00:00	MSFT	Stock	210.07	210.79	209.8	210.61	36726.0
2020-10-08 08:00:00	MSFT	Stock	209.977	211.0	209.8	210.51	63120.0
2020-10-08 09:00:00	MSFT	Stock	210.6	210.88	209.21	209.64	2208464.0
2020-10-08 10:00:00	MSFT	Stock	209.63	209.86	208.32	209.5	2543122.0
2020-10-08 11:00:00	MSFT	Stock	209.5	210.77	209.39	210.07	2380211.0
2020-10-08 12:00:00	MSFT	Stock	210.08	211.19	210.05	210.782	1544846.0
2020-10-08 13:00:00	MSFT	Stock	210.84	210.869	209.85	209.88	1398379.0
2020-10-08 14:00:00	MSFT	Stock	209.88	210.63	209.8	210.13	1422003.0
2020-10-08 15:00:00	MSFT	Stock	210.12	210.67	209.8	210.63	2816084.0
2020-10-08 16:00:00	MSFT	Stock	210.58	210.95	210.2	210.89	2241124.0
2020-10-08 17:00:00	MSFT	Stock	210.81	210.94	210.77	210.89	7507.0
2020-10-08 18:00:00	MSFT	Stock	210.9	211.3	210.7	211.05	13184.0
2020-10-08 19:00:00	MSFT	Stock	211.01	211.29	211.0	211.29	6922.0
2020-10-08 04:00:00	NVDA	Stock	14.0972	14.0972	14.0972	14.0972	4000.0
2020-10-08 05:00:00	NVDA	Stock	14.08	14.1	14.08	14.1	45320.0
2020-10-08 06:00:00	NVDA	Stock	14.1218	14.125	14.1218	14.125	16960.0
2020-10-08 07:00:00	NVDA	Stock	14.082	14.1118	14.0625	14.1118	427840.0
2020-10-08 08:00:00	NVDA	Stock	14.0875	14.134	14.0502	14.1125	2365200.0
2020-10-08 09:00:00	NVDA	Stock	14.1135	14.125	13.815	13.8388	66411320.0
2020-10-08 10:00:00	NVDA	Stock	13.8425	13.8708	13.758	13.8365	67377000.0
2020-10-08 11:00:00	NVDA	Stock	13.8318	13.925	13.8042	13.8583	55967920.0
2020-10-08 12:00:00	NVDA	Stock	13.8615	13.9152	13.8122	13.8205	26443600.0
2020-10-08 13:00:00	NVDA	Stock	13.8245	13.8325	13.779	13.7805	25278640.0
2020-10-08 14:00:00	NVDA	Stock	13.7801	13.8348	13.77	13.8075	20731480.0
2020-10-08 15:00:00	NVDA	Stock	13.8058	13.8498	13.7618	13.8448	41940120.0
2020-10-08 16:00:00	NVDA	Stock	13.8388	13.86	13.695	13.7825	10260880.0
2020-10-08 17:00:00	NVDA	Stock	13.785	13.8058	13.775	13.8	325120.0
2020-10-08 18:00:00	NVDA	Stock	13.8075	13.836	13.8075	13.83	448800.0
2020-10-08 19:00:00	NVDA	Stock	13.8332	13.8388	13.8025	13.81	473120.0
2020-10-08 06:00:00	AMZN	Stock	160.5975	160.5975	160.5975	160.5975	4320.0
2020-10-08 07:00:00	AMZN	Stock	160.4155	160.9475	160.356	160.8	248360.0

> showing 50 of 58,212 rows — these rows as CSV

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