PREVIEW / stock_1hour / 2021-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-20.parquet
  size:    1.5 MB
  rows:    67,144
  symbols: 2,647

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-12-20 04:00:00	AAPL	Stock	167.98	168.49	167.05	167.7	76320.0
2021-12-20 05:00:00	AAPL	Stock	167.77	167.99	167.45	167.91	49795.0
2021-12-20 06:00:00	AAPL	Stock	167.9	168.5	167.71	168.38	62480.0
2021-12-20 07:00:00	AAPL	Stock	168.39	168.79	167.81	167.81	268522.0
2021-12-20 08:00:00	AAPL	Stock	168.4999	168.8292	167.5	167.93	832249.0
2021-12-20 09:00:00	AAPL	Stock	167.95	169.95	167.46	169.55	13414618.0
2021-12-20 10:00:00	AAPL	Stock	169.55	169.58	167.7201	168.391	14714334.0
2021-12-20 11:00:00	AAPL	Stock	168.39	169.69	167.95	169.5421	10444708.0
2021-12-20 12:00:00	AAPL	Stock	169.535	170.58	168.89	169.025	10417108.0
2021-12-20 13:00:00	AAPL	Stock	169.03	170.07	168.82	169.76	7260417.0
2021-12-20 14:00:00	AAPL	Stock	169.76	170.29	169.36	169.95	7909982.0
2021-12-20 15:00:00	AAPL	Stock	169.95	170.43	169.09	169.88	14054227.0
2021-12-20 16:00:00	AAPL	Stock	169.84	170.45	169.5	170.25	10339838.0
2021-12-20 17:00:00	AAPL	Stock	170.27	170.28	169.75	170.15	266581.0
2021-12-20 18:00:00	AAPL	Stock	170.15	171.38	170.15	171.36	84193.0
2021-12-20 19:00:00	AAPL	Stock	171.36	171.38	170.84	171.04	85552.0
2021-12-20 04:00:00	MSFT	Stock	319.3	319.3	317.37	318.78	11719.0
2021-12-20 05:00:00	MSFT	Stock	318.8	319.01	318.5	318.99	3013.0
2021-12-20 06:00:00	MSFT	Stock	318.98	319.49	318.81	319.49	2297.0
2021-12-20 07:00:00	MSFT	Stock	319.8	319.9	319.2	319.5	31407.0
2021-12-20 08:00:00	MSFT	Stock	319.7885	319.9199	318.31	318.75	86268.0
2021-12-20 09:00:00	MSFT	Stock	318.9	322.8	318.9	321.38	2115399.0
2021-12-20 10:00:00	MSFT	Stock	321.29	321.5154	318.65	319.36	2432033.0
2021-12-20 11:00:00	MSFT	Stock	319.36	319.69	317.57	319.21	2329238.0
2021-12-20 12:00:00	MSFT	Stock	319.23	320.28	318.43	318.73	1389018.0
2021-12-20 13:00:00	MSFT	Stock	318.7	319.47	317.975	318.77	1567388.0
2021-12-20 14:00:00	MSFT	Stock	318.77	320.14	318.58	319.32	1544211.0
2021-12-20 15:00:00	MSFT	Stock	319.31	320.46	318.64	320.17	2909714.0
2021-12-20 16:00:00	MSFT	Stock	319.91	321.0	319.36	320.9	4993345.0
2021-12-20 17:00:00	MSFT	Stock	320.85	320.9	319.91	320.8899	107661.0
2021-12-20 18:00:00	MSFT	Stock	320.85	321.9999	320.85	321.9999	12499.0
2021-12-20 19:00:00	MSFT	Stock	321.81	321.91	321.5	321.75	9197.0
2021-12-20 04:00:00	NVDA	Stock	27.19	27.214	26.51	26.991	1185000.0
2021-12-20 05:00:00	NVDA	Stock	26.998	27.098	26.85	27.052	263480.0
2021-12-20 06:00:00	NVDA	Stock	27.001	27.16	26.969	27.12	234020.0
2021-12-20 07:00:00	NVDA	Stock	27.137	27.247	27.0	27.019	928090.0
2021-12-20 08:00:00	NVDA	Stock	27.225	27.236	26.871	27.012	2876360.0
2021-12-20 09:00:00	NVDA	Stock	27.0026	27.938	27.0	27.864	65496820.0
2021-12-20 10:00:00	NVDA	Stock	27.84	28.144	27.52	27.582	66363980.0
2021-12-20 11:00:00	NVDA	Stock	27.574	27.648	27.22	27.481	44889430.0
2021-12-20 12:00:00	NVDA	Stock	27.478	27.58	27.1741	27.213	28488220.0
2021-12-20 13:00:00	NVDA	Stock	27.2047	27.543	27.147	27.44	25113970.0
2021-12-20 14:00:00	NVDA	Stock	27.446	27.643	27.323	27.496	30505510.0
2021-12-20 15:00:00	NVDA	Stock	27.5	27.928	27.5	27.716	60618910.0
2021-12-20 16:00:00	NVDA	Stock	27.719	28.11	27.61	27.95	15590310.0
2021-12-20 17:00:00	NVDA	Stock	27.96	27.965	27.8	27.86	268030.0
2021-12-20 18:00:00	NVDA	Stock	27.865	28.2	27.865	28.15	678780.0
2021-12-20 19:00:00	NVDA	Stock	28.152	28.225	28.08	28.188	758790.0
2021-12-20 04:00:00	AMZN	Stock	166.8	167.3615	166.8	167.35	14340.0
2021-12-20 07:00:00	AMZN	Stock	167.95	168.05	167.75	167.75	49160.0

> showing 50 of 67,144 rows — these rows as CSV

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