PREVIEW / stock_1hour / 2022-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-03.parquet
  size:    1.5 MB
  rows:    65,900
  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
2022-01-03 04:00:00	AAPL	Stock	178.26	178.34	177.76	178.08	39767.0
2022-01-03 05:00:00	AAPL	Stock	178.08	178.22	177.99	178.17	34709.0
2022-01-03 06:00:00	AAPL	Stock	178.17	178.46	178.16	178.45	24005.0
2022-01-03 07:00:00	AAPL	Stock	178.46	178.5	178.09	178.22	70022.0
2022-01-03 08:00:00	AAPL	Stock	178.37	178.48	177.57	177.65	336538.0
2022-01-03 09:00:00	AAPL	Stock	177.64	180.93	177.5	180.45	12894057.0
2022-01-03 10:00:00	AAPL	Stock	180.46	181.43	180.2713	180.96	12817320.0
2022-01-03 11:00:00	AAPL	Stock	180.95	181.77	180.39	181.47	9409836.0
2022-01-03 12:00:00	AAPL	Stock	181.47	182.1675	181.075	181.69	7256820.0
2022-01-03 13:00:00	AAPL	Stock	181.6904	182.88	181.64	182.365	9391830.0
2022-01-03 14:00:00	AAPL	Stock	182.3742	182.465	181.66	181.88	7665642.0
2022-01-03 15:00:00	AAPL	Stock	181.87	182.2	181.195	182.0	12702402.0
2022-01-03 16:00:00	AAPL	Stock	182.0	182.3	181.7	182.14	17168841.0
2022-01-03 17:00:00	AAPL	Stock	182.13	182.2	182.01	182.11	51509.0
2022-01-03 18:00:00	AAPL	Stock	182.12	182.19	181.9	181.91	59675.0
2022-01-03 19:00:00	AAPL	Stock	181.93	182.0	181.75	181.99	57219.0
2022-01-03 04:00:00	MSFT	Stock	338.0	338.4	336.46	336.7	11038.0
2022-01-03 05:00:00	MSFT	Stock	336.78	337.16	336.7	337.16	7932.0
2022-01-03 06:00:00	MSFT	Stock	337.35	337.98	337.35	337.8	4154.0
2022-01-03 07:00:00	MSFT	Stock	337.5	337.8	337.5	337.6	11983.0
2022-01-03 08:00:00	MSFT	Stock	337.75	337.89	336.12	336.12	40914.0
2022-01-03 09:00:00	MSFT	Stock	336.15	338.0	329.78	330.3252	3207537.0
2022-01-03 10:00:00	MSFT	Stock	330.36	332.755	329.86	332.17	3322803.0
2022-01-03 11:00:00	MSFT	Stock	332.18	332.71	331.0893	331.7	1996894.0
2022-01-03 12:00:00	MSFT	Stock	331.69	332.96	331.31	332.22	1502519.0
2022-01-03 13:00:00	MSFT	Stock	332.23	333.909	331.794	333.532	1462443.0
2022-01-03 14:00:00	MSFT	Stock	333.5488	334.33	333.36	333.54	1343509.0
2022-01-03 15:00:00	MSFT	Stock	333.53	334.77	333.2	334.74	2866735.0
2022-01-03 16:00:00	MSFT	Stock	334.735	335.25	334.39	334.89	5151108.0
2022-01-03 17:00:00	MSFT	Stock	334.88	335.1	334.75	335.1	16443.0
2022-01-03 18:00:00	MSFT	Stock	335.23	335.25	334.65	334.65	18714.0
2022-01-03 19:00:00	MSFT	Stock	334.52	334.52	334.0	334.11	31074.0
2022-01-03 04:00:00	NVDA	Stock	29.7	29.86	29.67	29.793	163380.0
2022-01-03 05:00:00	NVDA	Stock	29.84	29.938	29.815	29.938	121800.0
2022-01-03 06:00:00	NVDA	Stock	29.927	29.99	29.92	29.945	169810.0
2022-01-03 07:00:00	NVDA	Stock	29.92	29.94	29.827	29.883	857760.0
2022-01-03 08:00:00	NVDA	Stock	29.87	29.974	29.7	29.701	1642910.0
2022-01-03 09:00:00	NVDA	Stock	29.7	30.711	29.677	30.0958	72088330.0
2022-01-03 10:00:00	NVDA	Stock	30.105	30.571	30.079	30.512	55356050.0
2022-01-03 11:00:00	NVDA	Stock	30.511	30.651	30.1547	30.178	34797680.0
2022-01-03 12:00:00	NVDA	Stock	30.17	30.314	30.05	30.196	21578220.0
2022-01-03 13:00:00	NVDA	Stock	30.202	30.278	29.913	29.964	26659480.0
2022-01-03 14:00:00	NVDA	Stock	29.964	30.247	29.934	30.1188	22666090.0
2022-01-03 15:00:00	NVDA	Stock	30.12	30.205	29.9851	30.116	30104690.0
2022-01-03 16:00:00	NVDA	Stock	30.116	30.149	30.1	30.125	16998640.0
2022-01-03 17:00:00	NVDA	Stock	30.1217	30.157	30.121	30.134	352700.0
2022-01-03 18:00:00	NVDA	Stock	30.13	30.17	30.05	30.075	309190.0
2022-01-03 19:00:00	NVDA	Stock	30.075	30.143	30.029	30.135	326040.0
2022-01-03 04:00:00	AMZN	Stock	167.6685	167.6685	167.6	167.6	6200.0
2022-01-03 05:00:00	AMZN	Stock	167.67	167.67	167.6	167.6	4000.0

> showing 50 of 65,900 rows — these rows as CSV

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