PREVIEW / stock_1hour / 2022-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-04.parquet
  size:    1.4 MB
  rows:    64,616
  symbols: 2,517

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-04-04 04:00:00	AAPL	Stock	174.18	174.41	173.8	174.41	8355.0
2022-04-04 05:00:00	AAPL	Stock	174.4	174.92	174.4	174.92	6175.0
2022-04-04 06:00:00	AAPL	Stock	174.98	175.15	174.86	174.86	15054.0
2022-04-04 07:00:00	AAPL	Stock	174.83	174.93	174.6	174.83	60348.0
2022-04-04 08:00:00	AAPL	Stock	174.8	174.9	173.875	174.26	259162.0
2022-04-04 09:00:00	AAPL	Stock	174.24	177.95	174.24	177.7801	11592368.0
2022-04-04 10:00:00	AAPL	Stock	177.79	178.21	176.73	177.35	12942389.0
2022-04-04 11:00:00	AAPL	Stock	177.36	177.84	177.11	177.245	6381759.0
2022-04-04 12:00:00	AAPL	Stock	177.25	177.8306	177.01	177.2091	5652770.0
2022-04-04 13:00:00	AAPL	Stock	177.2099	177.615	176.92	177.5352	4742912.0
2022-04-04 14:00:00	AAPL	Stock	177.535	177.81	177.02	177.76	5704311.0
2022-04-04 15:00:00	AAPL	Stock	177.76	178.49	177.69	178.465	13070905.0
2022-04-04 16:00:00	AAPL	Stock	178.44	178.55	178.32	178.39	7481427.0
2022-04-04 17:00:00	AAPL	Stock	178.39	178.44	178.25	178.3072	139277.0
2022-04-04 18:00:00	AAPL	Stock	178.3099	178.5	178.23	178.34	31313.0
2022-04-04 19:00:00	AAPL	Stock	178.33	178.37	178.14	178.36	43194.0
2022-04-04 04:00:00	MSFT	Stock	309.01	310.98	309.01	310.62	5650.0
2022-04-04 05:00:00	MSFT	Stock	310.75	311.0	310.75	311.0	2490.0
2022-04-04 06:00:00	MSFT	Stock	311.2	311.25	311.0	311.0	1677.0
2022-04-04 07:00:00	MSFT	Stock	310.82	311.4	310.6	311.06	15741.0
2022-04-04 08:00:00	MSFT	Stock	310.7	311.24	308.647	309.9	82968.0
2022-04-04 09:00:00	MSFT	Stock	309.8	314.33	309.71	313.985	3048552.0
2022-04-04 10:00:00	MSFT	Stock	313.985	314.35	312.11	312.5	2270203.0
2022-04-04 11:00:00	MSFT	Stock	312.5	314.02	312.485	313.3	1598145.0
2022-04-04 12:00:00	MSFT	Stock	313.34	314.1	313.07	313.32	1508870.0
2022-04-04 13:00:00	MSFT	Stock	313.33	313.92	312.71	313.83	1144277.0
2022-04-04 14:00:00	MSFT	Stock	313.86	314.47	313.115	314.15	1256137.0
2022-04-04 15:00:00	MSFT	Stock	314.14	315.11	313.93	315.07	3028476.0
2022-04-04 16:00:00	MSFT	Stock	314.97	315.49	314.97	315.25	4209535.0
2022-04-04 17:00:00	MSFT	Stock	315.32	315.45	315.1	315.15	6876.0
2022-04-04 18:00:00	MSFT	Stock	315.15	315.34	315.08	315.2	18948.0
2022-04-04 19:00:00	MSFT	Stock	315.19	315.37	315.02	315.07	21425.0
2022-04-04 04:00:00	NVDA	Stock	26.824	26.887	26.698	26.875	85150.0
2022-04-04 05:00:00	NVDA	Stock	26.895	27.049	26.895	26.981	116180.0
2022-04-04 06:00:00	NVDA	Stock	26.97	27.05	26.96	26.972	50230.0
2022-04-04 07:00:00	NVDA	Stock	26.97	26.97	26.782	26.849	374760.0
2022-04-04 08:00:00	NVDA	Stock	26.899	26.95	26.67	26.685	928950.0
2022-04-04 09:00:00	NVDA	Stock	26.699	27.329	26.613	27.3169	39650190.0
2022-04-04 10:00:00	NVDA	Stock	27.31	27.473	27.019	27.1351	55157420.0
2022-04-04 11:00:00	NVDA	Stock	27.134	27.558	27.12	27.4	44017130.0
2022-04-04 12:00:00	NVDA	Stock	27.404	27.468	27.303	27.325	21303480.0
2022-04-04 13:00:00	NVDA	Stock	27.325	27.388	27.166	27.348	24537260.0
2022-04-04 14:00:00	NVDA	Stock	27.3472	27.3472	27.08	27.277	33854580.0
2022-04-04 15:00:00	NVDA	Stock	27.274	27.455	27.216	27.3713	45078900.0
2022-04-04 16:00:00	NVDA	Stock	27.369	27.425	27.3	27.396	25973670.0
2022-04-04 17:00:00	NVDA	Stock	27.381	27.408	27.351	27.38	92430.0
2022-04-04 18:00:00	NVDA	Stock	27.377	27.38	27.306	27.35	275990.0
2022-04-04 19:00:00	NVDA	Stock	27.349	27.365	27.286	27.3	185290.0
2022-04-04 07:00:00	AMZN	Stock	164.25	164.25	163.982	164.0	39740.0
2022-04-04 08:00:00	AMZN	Stock	164.1407	164.245	163.95	164.0	56620.0

> showing 50 of 64,616 rows — these rows as CSV

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