PREVIEW / stock_1hour / 2021-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-25.parquet
  size:    1.4 MB
  rows:    64,258
  symbols: 2,977

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-05-25 04:00:00	AAPL	Stock	127.99	128.0	127.76	127.87	19624.0
2021-05-25 05:00:00	AAPL	Stock	127.91	127.91	127.83	127.85	11965.0
2021-05-25 06:00:00	AAPL	Stock	127.88	127.9	127.63	127.69	3813.0
2021-05-25 07:00:00	AAPL	Stock	127.65	127.96	127.6	127.89	65448.0
2021-05-25 08:00:00	AAPL	Stock	127.6701	127.97	127.1	127.66	400083.0
2021-05-25 09:00:00	AAPL	Stock	127.64	128.32	126.89	126.945	10764156.0
2021-05-25 10:00:00	AAPL	Stock	126.945	127.28	126.76	127.125	10303222.0
2021-05-25 11:00:00	AAPL	Stock	127.13	127.17	126.665	126.8	6873115.0
2021-05-25 12:00:00	AAPL	Stock	126.8	127.07	126.72	126.82	4309156.0
2021-05-25 13:00:00	AAPL	Stock	126.825	127.0	126.61	126.88	4277599.0
2021-05-25 14:00:00	AAPL	Stock	126.885	126.92	126.56	126.66	4264670.0
2021-05-25 15:00:00	AAPL	Stock	126.655	126.96	126.32	126.94	8872792.0
2021-05-25 16:00:00	AAPL	Stock	126.9	126.98	126.87	126.92	5523807.0
2021-05-25 17:00:00	AAPL	Stock	126.94	127.15	126.91	126.94	50936.0
2021-05-25 18:00:00	AAPL	Stock	126.95	127.15	126.65	127.1	74252.0
2021-05-25 19:00:00	AAPL	Stock	127.1	127.19	127.05	127.11	57950.0
2021-05-25 04:00:00	MSFT	Stock	252.0	252.0	251.5	251.5	3272.0
2021-05-25 05:00:00	MSFT	Stock	251.8	252.1	251.3	252.1	4480.0
2021-05-25 06:00:00	MSFT	Stock	252.2	252.2	251.89	251.89	2523.0
2021-05-25 07:00:00	MSFT	Stock	251.62	252.48	251.56	252.48	10579.0
2021-05-25 08:00:00	MSFT	Stock	252.1201	252.4957	250.154	251.97	21751.0
2021-05-25 09:00:00	MSFT	Stock	251.99	252.75	250.82	251.38	1906401.0
2021-05-25 10:00:00	MSFT	Stock	251.4	251.8516	250.82	251.69	1540446.0
2021-05-25 11:00:00	MSFT	Stock	251.71	252.01	251.13	251.7	1549270.0
2021-05-25 12:00:00	MSFT	Stock	251.72	251.94	251.31	251.33	1041314.0
2021-05-25 13:00:00	MSFT	Stock	251.33	251.52	250.86	251.13	1058114.0
2021-05-25 14:00:00	MSFT	Stock	251.14	251.45	250.8901	251.38	1098935.0
2021-05-25 15:00:00	MSFT	Stock	251.38	251.86	251.02	251.85	2463578.0
2021-05-25 16:00:00	MSFT	Stock	251.72	251.97	251.37	251.7	2556186.0
2021-05-25 17:00:00	MSFT	Stock	251.72	251.72	251.6	251.6	2616.0
2021-05-25 18:00:00	MSFT	Stock	251.7	252.4	251.54	252.4	13298.0
2021-05-25 19:00:00	MSFT	Stock	252.05	252.1	251.87	251.95	9661.0
2021-05-25 04:00:00	NVDA	Stock	15.775	15.8125	15.775	15.8125	26480.0
2021-05-25 05:00:00	NVDA	Stock	15.8	15.8752	15.8	15.87	254800.0
2021-05-25 06:00:00	NVDA	Stock	15.8225	15.8225	15.7	15.7062	177560.0
2021-05-25 07:00:00	NVDA	Stock	15.7325	15.8338	15.7025	15.8	1123000.0
2021-05-25 08:00:00	NVDA	Stock	15.8588	15.8588	15.725	15.7625	1680320.0
2021-05-25 09:00:00	NVDA	Stock	15.775	15.8185	15.4838	15.5191	80054000.0
2021-05-25 10:00:00	NVDA	Stock	15.515	15.7	15.4882	15.6889	48515560.0
2021-05-25 11:00:00	NVDA	Stock	15.6855	15.6912	15.4825	15.6045	29249880.0
2021-05-25 12:00:00	NVDA	Stock	15.6079	15.615	15.5338	15.5693	14389120.0
2021-05-25 13:00:00	NVDA	Stock	15.5688	15.6493	15.518	15.6164	17056040.0
2021-05-25 14:00:00	NVDA	Stock	15.6195	15.65	15.5702	15.6292	11406280.0
2021-05-25 15:00:00	NVDA	Stock	15.6338	15.65	15.549	15.6485	31088760.0
2021-05-25 16:00:00	NVDA	Stock	15.6478	15.65	15.6225	15.6425	23485080.0
2021-05-25 17:00:00	NVDA	Stock	15.65	15.6692	15.64	15.6692	836880.0
2021-05-25 18:00:00	NVDA	Stock	15.6692	15.7412	15.6685	15.725	927400.0
2021-05-25 19:00:00	NVDA	Stock	15.725	15.7415	15.7128	15.7148	551640.0
2021-05-25 06:00:00	AMZN	Stock	163.0	163.0	163.0	163.0	4000.0
2021-05-25 07:00:00	AMZN	Stock	163.145	163.85	163.1	163.7	64040.0

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

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