PREVIEW / stock_1hour / 2022-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-30.parquet
  size:    1.4 MB
  rows:    63,997
  symbols: 2,471

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-03-30 04:00:00	AAPL	Stock	178.5	178.5	177.7	177.73	20231.0
2022-03-30 05:00:00	AAPL	Stock	177.75	178.07	177.74	178.0	34850.0
2022-03-30 06:00:00	AAPL	Stock	177.82	178.08	177.66	177.83	21473.0
2022-03-30 07:00:00	AAPL	Stock	177.86	178.34	177.8	178.28	111899.0
2022-03-30 08:00:00	AAPL	Stock	178.32	178.52	177.47	178.03	586228.0
2022-03-30 09:00:00	AAPL	Stock	178.07	179.61	177.73	178.74	13073036.0
2022-03-30 10:00:00	AAPL	Stock	178.75	179.5298	177.84	177.9128	11848741.0
2022-03-30 11:00:00	AAPL	Stock	177.92	178.18	177.4686	177.8	8917518.0
2022-03-30 12:00:00	AAPL	Stock	177.79	178.47	177.5	178.395	6556097.0
2022-03-30 13:00:00	AAPL	Stock	178.39	179.35	178.05	178.15	8038784.0
2022-03-30 14:00:00	AAPL	Stock	178.15	178.48	177.62	177.67	5769734.0
2022-03-30 15:00:00	AAPL	Stock	177.665	177.79	176.7	177.725	13265591.0
2022-03-30 16:00:00	AAPL	Stock	177.78	177.99	177.42	177.91	8323257.0
2022-03-30 17:00:00	AAPL	Stock	177.9	177.99	177.89	177.94	45163.0
2022-03-30 18:00:00	AAPL	Stock	177.94	177.99	177.87	177.99	37704.0
2022-03-30 19:00:00	AAPL	Stock	177.99	178.05	177.88	178.02	36355.0
2022-03-30 04:00:00	MSFT	Stock	314.89	315.0	313.67	313.68	8178.0
2022-03-30 05:00:00	MSFT	Stock	313.85	314.0	313.7	314.0	4323.0
2022-03-30 06:00:00	MSFT	Stock	313.8	313.8	313.15	313.55	3465.0
2022-03-30 07:00:00	MSFT	Stock	313.9	314.4	313.8	314.23	6341.0
2022-03-30 08:00:00	MSFT	Stock	314.38	315.0	312.55	313.0	41282.0
2022-03-30 09:00:00	MSFT	Stock	313.0	314.96	312.7	312.92	1964801.0
2022-03-30 10:00:00	MSFT	Stock	312.97	314.125	312.23	312.61	2482279.0
2022-03-30 11:00:00	MSFT	Stock	312.63	313.69	311.58	313.69	1676218.0
2022-03-30 12:00:00	MSFT	Stock	313.67	315.8	313.36	315.66	2285544.0
2022-03-30 13:00:00	MSFT	Stock	315.66	315.95	314.02	314.11	1898976.0
2022-03-30 14:00:00	MSFT	Stock	314.1	314.71	313.47	313.6785	1230419.0
2022-03-30 15:00:00	MSFT	Stock	313.68	314.29	312.32	314.06	3309053.0
2022-03-30 16:00:00	MSFT	Stock	313.86	314.78	313.43	314.5601	4228463.0
2022-03-30 17:00:00	MSFT	Stock	314.59	314.98	314.59	314.6	12831.0
2022-03-30 18:00:00	MSFT	Stock	314.6	314.75	314.6	314.65	1430.0
2022-03-30 19:00:00	MSFT	Stock	314.73	314.78	314.65	314.7	5585.0
2022-03-30 04:00:00	NVDA	Stock	28.48	28.5	28.301	28.325	87320.0
2022-03-30 05:00:00	NVDA	Stock	28.326	28.398	28.326	28.376	54090.0
2022-03-30 06:00:00	NVDA	Stock	28.311	28.365	28.268	28.34	73360.0
2022-03-30 07:00:00	NVDA	Stock	28.325	28.46	28.325	28.45	402730.0
2022-03-30 08:00:00	NVDA	Stock	28.37	29.011	28.217	28.3597	2027600.0
2022-03-30 09:00:00	NVDA	Stock	28.32	28.46	27.955	28.1388	52846500.0
2022-03-30 10:00:00	NVDA	Stock	28.128	28.4955	27.955	28.0795	59431540.0
2022-03-30 11:00:00	NVDA	Stock	28.08	28.13	27.789	28.011	50637780.0
2022-03-30 12:00:00	NVDA	Stock	28.006	28.289	27.931	28.2245	27148670.0
2022-03-30 13:00:00	NVDA	Stock	28.224	28.255	27.883	27.9015	27783060.0
2022-03-30 14:00:00	NVDA	Stock	27.903	27.997	27.712	27.752	40260600.0
2022-03-30 15:00:00	NVDA	Stock	27.755	27.806	27.503	27.692	57151720.0
2022-03-30 16:00:00	NVDA	Stock	27.692	27.78	27.65	27.778	19878150.0
2022-03-30 17:00:00	NVDA	Stock	27.78	27.8172	27.778	27.812	253110.0
2022-03-30 18:00:00	NVDA	Stock	27.802	27.804	27.746	27.749	242910.0
2022-03-30 19:00:00	NVDA	Stock	27.785	27.805	27.75	27.8	298610.0
2022-03-30 06:00:00	AMZN	Stock	168.223	168.223	168.223	168.223	3080.0
2022-03-30 07:00:00	AMZN	Stock	168.72	168.7395	168.65	168.65	6000.0

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

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