PREVIEW / stock_1hour / 2022-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-18.parquet
  size:    1.5 MB
  rows:    66,964
  symbols: 2,622

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-01-18 04:00:00	AAPL	Stock	170.85	170.89	169.62	170.21	51593.0
2022-01-18 05:00:00	AAPL	Stock	170.39	170.73	170.01	170.16	15780.0
2022-01-18 06:00:00	AAPL	Stock	170.15	170.3	169.65	170.1	20366.0
2022-01-18 07:00:00	AAPL	Stock	170.23	170.89	170.0	170.6	246619.0
2022-01-18 08:00:00	AAPL	Stock	170.4171	173.07	170.0	170.67	671049.0
2022-01-18 09:00:00	AAPL	Stock	170.65	172.54	170.52	171.11	10915533.0
2022-01-18 10:00:00	AAPL	Stock	171.11	172.32	170.79	171.0801	9736016.0
2022-01-18 11:00:00	AAPL	Stock	171.1	171.22	170.2	171.1244	8032038.0
2022-01-18 12:00:00	AAPL	Stock	171.14	171.28	169.6	169.76	7264841.0
2022-01-18 13:00:00	AAPL	Stock	169.75	170.44	169.57	170.345	6601612.0
2022-01-18 14:00:00	AAPL	Stock	170.33	170.79	170.01	170.57	6240930.0
2022-01-18 15:00:00	AAPL	Stock	170.5701	170.77	169.405	169.83	13095450.0
2022-01-18 16:00:00	AAPL	Stock	169.91	170.25	169.7	170.21	14688031.0
2022-01-18 17:00:00	AAPL	Stock	170.21	170.21	169.85	169.92	41826.0
2022-01-18 18:00:00	AAPL	Stock	169.91	170.25	169.5	169.5	69479.0
2022-01-18 19:00:00	AAPL	Stock	169.54	169.65	169.3101	169.3101	74525.0
2022-01-18 04:00:00	MSFT	Stock	305.99	305.99	303.32	304.4	27278.0
2022-01-18 05:00:00	MSFT	Stock	304.7	305.0	303.97	304.25	8656.0
2022-01-18 06:00:00	MSFT	Stock	304.13	304.55	303.55	304.27	11716.0
2022-01-18 07:00:00	MSFT	Stock	304.42	305.28	304.1	305.15	46673.0
2022-01-18 08:00:00	MSFT	Stock	304.78	307.48	300.45	306.01	662576.0
2022-01-18 09:00:00	MSFT	Stock	306.05	308.1499	302.38	307.07	4875019.0
2022-01-18 10:00:00	MSFT	Stock	307.11	309.8	306.08	306.71	4237924.0
2022-01-18 11:00:00	MSFT	Stock	306.72	306.79	304.58	306.4089	2759923.0
2022-01-18 12:00:00	MSFT	Stock	306.42	306.66	304.46	304.69	1820621.0
2022-01-18 13:00:00	MSFT	Stock	304.69	304.9309	303.3001	304.2031	2591968.0
2022-01-18 14:00:00	MSFT	Stock	304.21	304.96	303.66	304.2897	1907342.0
2022-01-18 15:00:00	MSFT	Stock	304.285	304.5099	301.74	302.77	5064053.0
2022-01-18 16:00:00	MSFT	Stock	302.65	303.48	302.65	303.16	6364707.0
2022-01-18 17:00:00	MSFT	Stock	303.19	303.26	302.68	302.8	21497.0
2022-01-18 18:00:00	MSFT	Stock	302.8	303.1	302.24	302.53	44143.0
2022-01-18 19:00:00	MSFT	Stock	302.6	302.7	301.85	301.85	49872.0
2022-01-18 04:00:00	NVDA	Stock	26.277	26.334	26.075	26.2	291430.0
2022-01-18 05:00:00	NVDA	Stock	26.19	26.279	26.19	26.197	118880.0
2022-01-18 06:00:00	NVDA	Stock	26.21	26.289	26.204	26.252	46700.0
2022-01-18 07:00:00	NVDA	Stock	26.247	26.46	26.234	26.446	608080.0
2022-01-18 08:00:00	NVDA	Stock	26.2502	26.942	26.25	26.4912	2154820.0
2022-01-18 09:00:00	NVDA	Stock	26.477	26.648	25.975	26.281	49517340.0
2022-01-18 10:00:00	NVDA	Stock	26.282	26.638	26.097	26.1664	51943530.0
2022-01-18 11:00:00	NVDA	Stock	26.157	26.51	26.05	26.4005	31975680.0
2022-01-18 12:00:00	NVDA	Stock	26.405	26.459	26.038	26.052	27014510.0
2022-01-18 13:00:00	NVDA	Stock	26.051	26.129	25.904	26.035	33355820.0
2022-01-18 14:00:00	NVDA	Stock	26.033	26.215	25.94	26.1425	27374430.0
2022-01-18 15:00:00	NVDA	Stock	26.147	26.158	25.77	25.903	48826310.0
2022-01-18 16:00:00	NVDA	Stock	25.903	25.95	25.849	25.926	36958840.0
2022-01-18 17:00:00	NVDA	Stock	25.94	25.94	25.859	25.875	289870.0
2022-01-18 18:00:00	NVDA	Stock	25.884	25.922	25.8	25.803	321640.0
2022-01-18 19:00:00	NVDA	Stock	25.818	25.854	25.75	25.75	356260.0
2022-01-18 04:00:00	AMZN	Stock	159.25	159.25	158.75	158.75	7300.0
2022-01-18 05:00:00	AMZN	Stock	158.811	158.811	158.811	158.811	2000.0

> showing 50 of 66,964 rows — these rows as CSV

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