PREVIEW / stock_1hour / 2022-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-25.parquet
  size:    1.4 MB
  rows:    63,186
  symbols: 2,542

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
2022-02-25 04:00:00	AAPL	Stock	162.79	162.79	160.53	161.82	31306.0
2022-02-25 05:00:00	AAPL	Stock	161.85	162.28	161.74	162.07	19624.0
2022-02-25 06:00:00	AAPL	Stock	162.01	162.71	161.33	162.2	39116.0
2022-02-25 07:00:00	AAPL	Stock	162.1	163.8	162.0	163.49	115271.0
2022-02-25 08:00:00	AAPL	Stock	162.41	164.74	161.0	164.13	775087.0
2022-02-25 09:00:00	AAPL	Stock	164.04	164.35	161.12	161.26	10362192.0
2022-02-25 10:00:00	AAPL	Stock	161.24	163.54	160.8738	163.155	12809916.0
2022-02-25 11:00:00	AAPL	Stock	163.15	164.65	162.82	164.5725	10769137.0
2022-02-25 12:00:00	AAPL	Stock	164.58	164.84	163.85	164.075	7916930.0
2022-02-25 13:00:00	AAPL	Stock	164.075	165.01	163.48	164.55	8325118.0
2022-02-25 14:00:00	AAPL	Stock	164.555	165.01	164.02	164.425	7387534.0
2022-02-25 15:00:00	AAPL	Stock	164.43	165.12	163.98	164.87	13162620.0
2022-02-25 16:00:00	AAPL	Stock	164.85	165.0	164.7	164.88	6495437.0
2022-02-25 17:00:00	AAPL	Stock	164.89	164.89	164.42	164.55	108151.0
2022-02-25 18:00:00	AAPL	Stock	164.55	164.6	164.33	164.4	40692.0
2022-02-25 19:00:00	AAPL	Stock	164.4	164.45	164.15	164.34	48241.0
2022-02-25 04:00:00	MSFT	Stock	291.67	293.0	290.7	293.0	10015.0
2022-02-25 05:00:00	MSFT	Stock	292.2	293.93	292.2	293.0	4973.0
2022-02-25 06:00:00	MSFT	Stock	293.0	293.62	291.45	292.5	4473.0
2022-02-25 07:00:00	MSFT	Stock	292.9	296.07	291.73	295.49	27131.0
2022-02-25 08:00:00	MSFT	Stock	293.0001	297.5	293.0	295.7	72184.0
2022-02-25 09:00:00	MSFT	Stock	295.65	296.19	291.655	292.51	3168162.0
2022-02-25 10:00:00	MSFT	Stock	292.44	296.1	291.8	295.07	3301373.0
2022-02-25 11:00:00	MSFT	Stock	295.07	297.17	294.2099	297.1	2462200.0
2022-02-25 12:00:00	MSFT	Stock	297.1	297.4	295.07	295.28	2074975.0
2022-02-25 13:00:00	MSFT	Stock	295.3	296.45	294.56	295.88	1953650.0
2022-02-25 14:00:00	MSFT	Stock	295.89	296.69	294.94	296.01	1938924.0
2022-02-25 15:00:00	MSFT	Stock	296.0	297.63	295.2	297.34	4095454.0
2022-02-25 16:00:00	MSFT	Stock	297.38	297.9	297.01	297.63	3023400.0
2022-02-25 17:00:00	MSFT	Stock	297.51	297.6	297.0101	297.0101	9618.0
2022-02-25 18:00:00	MSFT	Stock	297.1	297.2	297.05	297.06	6934.0
2022-02-25 19:00:00	MSFT	Stock	297.1	297.15	296.73	296.73	9176.0
2022-02-25 04:00:00	NVDA	Stock	23.29	23.47	23.066	23.444	170490.0
2022-02-25 05:00:00	NVDA	Stock	23.45	23.701	23.421	23.561	214380.0
2022-02-25 06:00:00	NVDA	Stock	23.524	23.617	23.34	23.5	90260.0
2022-02-25 07:00:00	NVDA	Stock	23.52	23.95	23.405	23.85	706120.0
2022-02-25 08:00:00	NVDA	Stock	23.434	24.18	23.4	23.96	2957210.0
2022-02-25 09:00:00	NVDA	Stock	23.955	24.111	23.458	23.522	58537800.0
2022-02-25 10:00:00	NVDA	Stock	23.521	24.08	23.381	23.984	76538940.0
2022-02-25 11:00:00	NVDA	Stock	23.9805	24.217	23.84	24.1407	48913040.0
2022-02-25 12:00:00	NVDA	Stock	24.147	24.192	23.721	23.89	37556760.0
2022-02-25 13:00:00	NVDA	Stock	23.8855	24.025	23.576	23.769	45764820.0
2022-02-25 14:00:00	NVDA	Stock	23.777	23.92	23.501	23.821	55185400.0
2022-02-25 15:00:00	NVDA	Stock	23.815	24.189	23.7418	24.157	56465750.0
2022-02-25 16:00:00	NVDA	Stock	24.164	24.183	23.8844	24.166	18162910.0
2022-02-25 17:00:00	NVDA	Stock	24.166	24.201	24.1	24.12	552380.0
2022-02-25 18:00:00	NVDA	Stock	24.12	24.12	24.05	24.073	250330.0
2022-02-25 19:00:00	NVDA	Stock	24.068	24.12	24.053	24.09	193040.0
2022-02-25 04:00:00	AMZN	Stock	150.0	150.0	150.0	150.0	2000.0
2022-02-25 05:00:00	AMZN	Stock	150.4	150.4	150.4	150.4	2780.0

> showing 50 of 63,186 rows — these rows as CSV

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