PREVIEW / stock_1hour / 2022-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-08.parquet
  size:    1.4 MB
  rows:    62,376
  symbols: 2,326

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-06-08 04:00:00	AAPL	Stock	147.85	148.53	147.85	148.44	18928.0
2022-06-08 05:00:00	AAPL	Stock	148.44	148.45	148.27	148.45	4869.0
2022-06-08 06:00:00	AAPL	Stock	148.25	148.4	147.88	148.4	17283.0
2022-06-08 07:00:00	AAPL	Stock	148.33	148.94	148.25	148.45	69900.0
2022-06-08 08:00:00	AAPL	Stock	148.2982	148.8499	147.75	148.25	427280.0
2022-06-08 09:00:00	AAPL	Stock	148.25	149.8697	148.0	149.73	8530677.0
2022-06-08 10:00:00	AAPL	Stock	149.73	149.77	148.57	149.01	8291410.0
2022-06-08 11:00:00	AAPL	Stock	149.01	149.6472	148.65	149.06	5208924.0
2022-06-08 12:00:00	AAPL	Stock	149.06	149.37	147.74	148.23	4632904.0
2022-06-08 13:00:00	AAPL	Stock	148.22	148.38	147.46	148.2538	4387432.0
2022-06-08 14:00:00	AAPL	Stock	148.26	148.43	147.57	147.8706	4369768.0
2022-06-08 15:00:00	AAPL	Stock	147.871	148.47	147.5649	148.0	6666078.0
2022-06-08 16:00:00	AAPL	Stock	147.96	148.29	147.78	147.92	4925635.0
2022-06-08 17:00:00	AAPL	Stock	147.96	148.06	147.88	147.94	36243.0
2022-06-08 18:00:00	AAPL	Stock	147.96	148.05	147.91	148.0	19553.0
2022-06-08 19:00:00	AAPL	Stock	147.97	148.05	147.87	147.92	24788.0
2022-06-08 04:00:00	MSFT	Stock	271.45	271.55	270.93	271.5	1468.0
2022-06-08 05:00:00	MSFT	Stock	271.3	271.3	271.3	271.3	100.0
2022-06-08 06:00:00	MSFT	Stock	271.4	272.0	271.02	271.99	3820.0
2022-06-08 07:00:00	MSFT	Stock	271.75	272.34	271.73	271.87	3783.0
2022-06-08 08:00:00	MSFT	Stock	272.176	272.34	271.01	271.4	30239.0
2022-06-08 09:00:00	MSFT	Stock	271.29	272.92	270.65	272.17	1623094.0
2022-06-08 10:00:00	MSFT	Stock	272.2	273.0	271.1	271.32	1769750.0
2022-06-08 11:00:00	MSFT	Stock	271.33	272.62	270.96	272.03	1262976.0
2022-06-08 12:00:00	MSFT	Stock	272.025	272.35	270.62	271.19	1360976.0
2022-06-08 13:00:00	MSFT	Stock	271.2	271.24	269.82	270.7	916579.0
2022-06-08 14:00:00	MSFT	Stock	270.71	271.04	269.61	270.81	1135080.0
2022-06-08 15:00:00	MSFT	Stock	270.8	271.5	269.79	270.46	2147792.0
2022-06-08 16:00:00	MSFT	Stock	270.41	270.41	270.11	270.41	2694983.0
2022-06-08 17:00:00	MSFT	Stock	270.4	270.5	270.4	270.5	13286.0
2022-06-08 18:00:00	MSFT	Stock	270.3	270.4	270.3	270.4	710.0
2022-06-08 19:00:00	MSFT	Stock	270.55	270.55	270.55	270.55	100.0
2022-06-08 04:00:00	NVDA	Stock	18.859	18.915	18.859	18.878	72780.0
2022-06-08 05:00:00	NVDA	Stock	18.895	18.91	18.866	18.91	36250.0
2022-06-08 06:00:00	NVDA	Stock	18.861	18.886	18.8	18.886	107340.0
2022-06-08 07:00:00	NVDA	Stock	18.861	19.018	18.855	18.975	353840.0
2022-06-08 08:00:00	NVDA	Stock	18.88	19.023	18.829	18.8869	1097160.0
2022-06-08 09:00:00	NVDA	Stock	18.87	19.18	18.651	19.148	50323720.0
2022-06-08 10:00:00	NVDA	Stock	19.147	19.173	18.892	18.9925	52613330.0
2022-06-08 11:00:00	NVDA	Stock	18.991	18.997	18.8	18.801	34838600.0
2022-06-08 12:00:00	NVDA	Stock	18.802	18.8558	18.535	18.665	38163220.0
2022-06-08 13:00:00	NVDA	Stock	18.664	18.74	18.585	18.7256	33484610.0
2022-06-08 14:00:00	NVDA	Stock	18.729	18.787	18.595	18.633	27850450.0
2022-06-08 15:00:00	NVDA	Stock	18.635	18.72	18.548	18.648	42822640.0
2022-06-08 16:00:00	NVDA	Stock	18.648	18.675	18.619	18.675	15171020.0
2022-06-08 17:00:00	NVDA	Stock	18.677	18.677	18.633	18.645	186410.0
2022-06-08 18:00:00	NVDA	Stock	18.641	18.652	18.618	18.652	178250.0
2022-06-08 19:00:00	NVDA	Stock	18.646	18.685	18.64	18.64	263630.0
2022-06-08 04:00:00	AMZN	Stock	122.44	122.8	122.4	122.69	14938.0
2022-06-08 05:00:00	AMZN	Stock	122.61	122.9	122.56	122.75	20646.0

> showing 50 of 62,376 rows — these rows as CSV

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