PREVIEW / stock_1hour / 2021-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-27.parquet
  size:    1.4 MB
  rows:    65,597
  symbols: 2,728

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
2021-09-27 04:00:00	AAPL	Stock	147.0	147.28	146.92	146.99	13461.0
2021-09-27 05:00:00	AAPL	Stock	146.98	147.03	146.27	146.34	25440.0
2021-09-27 06:00:00	AAPL	Stock	146.3	146.5	145.75	145.85	45406.0
2021-09-27 07:00:00	AAPL	Stock	145.97	146.2	145.84	146.05	194945.0
2021-09-27 08:00:00	AAPL	Stock	146.1899	146.25	145.4	145.72	784311.0
2021-09-27 09:00:00	AAPL	Stock	145.72	145.96	143.82	144.319	12983203.0
2021-09-27 10:00:00	AAPL	Stock	144.33	145.655	144.21	145.255	11316858.0
2021-09-27 11:00:00	AAPL	Stock	145.2537	145.5955	144.53	144.8	7709769.0
2021-09-27 12:00:00	AAPL	Stock	144.79	145.21	144.09	145.1	5675924.0
2021-09-27 13:00:00	AAPL	Stock	145.09	145.54	145.035	145.515	4429652.0
2021-09-27 14:00:00	AAPL	Stock	145.52	145.76	145.44	145.54	4638831.0
2021-09-27 15:00:00	AAPL	Stock	145.5457	145.77	145.2	145.38	9198266.0
2021-09-27 16:00:00	AAPL	Stock	145.4	145.44	145.21	145.24	7739472.0
2021-09-27 17:00:00	AAPL	Stock	145.27	145.27	145.0	145.04	109772.0
2021-09-27 18:00:00	AAPL	Stock	145.03	145.1	144.92	144.96	92333.0
2021-09-27 19:00:00	AAPL	Stock	144.97	145.05	144.94	145.0	34525.0
2021-09-27 04:00:00	MSFT	Stock	300.0	300.0	299.35	299.35	962.0
2021-09-27 05:00:00	MSFT	Stock	299.5	299.8	298.82	298.82	4466.0
2021-09-27 06:00:00	MSFT	Stock	298.34	298.6	297.31	297.45	6334.0
2021-09-27 07:00:00	MSFT	Stock	297.7	297.87	297.05	297.75	51695.0
2021-09-27 08:00:00	MSFT	Stock	297.22	300.098	296.18	297.11	65752.0
2021-09-27 09:00:00	MSFT	Stock	297.02	297.0854	293.6	294.28	3132574.0
2021-09-27 10:00:00	MSFT	Stock	294.28	296.22	293.72	295.21	2467003.0
2021-09-27 11:00:00	MSFT	Stock	295.21	296.09	293.23	293.64	2267416.0
2021-09-27 12:00:00	MSFT	Stock	293.62	293.95	292.9449	293.26	1406366.0
2021-09-27 13:00:00	MSFT	Stock	293.25	294.399	293.13	294.0	1338110.0
2021-09-27 14:00:00	MSFT	Stock	294.01	294.43	293.63	293.7	1373384.0
2021-09-27 15:00:00	MSFT	Stock	293.7	294.86	293.67	294.17	2664760.0
2021-09-27 16:00:00	MSFT	Stock	294.17	294.29	293.99	294.03	2989027.0
2021-09-27 17:00:00	MSFT	Stock	294.09	294.12	293.98	293.99	10155.0
2021-09-27 18:00:00	MSFT	Stock	294.05	294.11	293.9501	293.99	10942.0
2021-09-27 19:00:00	MSFT	Stock	294.02	294.15	293.8	294.15	6339.0
2021-09-27 04:00:00	NVDA	Stock	22.093	22.159	22.05	22.05	30700.0
2021-09-27 05:00:00	NVDA	Stock	22.024	22.039	21.926	21.93	22360.0
2021-09-27 06:00:00	NVDA	Stock	21.914	21.93	21.85	21.85	53400.0
2021-09-27 07:00:00	NVDA	Stock	21.878	21.914	21.834	21.842	420000.0
2021-09-27 08:00:00	NVDA	Stock	21.85	22.0258	21.727	21.785	1252360.0
2021-09-27 09:00:00	NVDA	Stock	21.7721	21.799	21.325	21.45	38252780.0
2021-09-27 10:00:00	NVDA	Stock	21.45	21.645	21.332	21.6033	38549460.0
2021-09-27 11:00:00	NVDA	Stock	21.601	21.714	21.471	21.517	31475630.0
2021-09-27 12:00:00	NVDA	Stock	21.514	21.5837	21.468	21.526	14668960.0
2021-09-27 13:00:00	NVDA	Stock	21.522	21.669	21.515	21.663	13046900.0
2021-09-27 14:00:00	NVDA	Stock	21.664	21.7711	21.648	21.714	15871200.0
2021-09-27 15:00:00	NVDA	Stock	21.709	21.769	21.633	21.656	25198460.0
2021-09-27 16:00:00	NVDA	Stock	21.656	21.672	21.575	21.617	15519740.0
2021-09-27 17:00:00	NVDA	Stock	21.601	21.612	21.577	21.577	107440.0
2021-09-27 18:00:00	NVDA	Stock	21.596	21.635	21.577	21.58	177770.0
2021-09-27 19:00:00	NVDA	Stock	21.6	21.6	21.576	21.59	122120.0
2021-09-27 04:00:00	AMZN	Stock	171.25	171.25	171.25	171.25	2000.0
2021-09-27 05:00:00	AMZN	Stock	171.2235	171.2235	170.611	170.611	43540.0

> showing 50 of 65,597 rows — these rows as CSV

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