PREVIEW / stock_1hour / 2022-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-27.parquet
  size:    1.4 MB
  rows:    62,714
  symbols: 2,340

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-27 04:00:00	AAPL	Stock	142.0	143.03	142.0	142.55	56513.0
2022-06-27 05:00:00	AAPL	Stock	142.54	142.68	142.19	142.55	13835.0
2022-06-27 06:00:00	AAPL	Stock	142.55	142.57	142.0	142.42	20055.0
2022-06-27 07:00:00	AAPL	Stock	142.41	142.97	142.07	142.79	158254.0
2022-06-27 08:00:00	AAPL	Stock	142.5588	142.96	142.16	142.32	372552.0
2022-06-27 09:00:00	AAPL	Stock	142.32	143.49	141.29	141.89	9582841.0
2022-06-27 10:00:00	AAPL	Stock	141.91	142.95	141.69	142.84	9304968.0
2022-06-27 11:00:00	AAPL	Stock	142.8375	143.09	142.225	143.035	5323474.0
2022-06-27 12:00:00	AAPL	Stock	143.0474	143.07	142.07	142.5499	5159949.0
2022-06-27 13:00:00	AAPL	Stock	142.55	142.58	141.565	141.6754	4326252.0
2022-06-27 14:00:00	AAPL	Stock	141.68	142.055	141.5	141.61	4656076.0
2022-06-27 15:00:00	AAPL	Stock	141.62	141.85	140.965	141.71	9438561.0
2022-06-27 16:00:00	AAPL	Stock	141.71	142.087	141.53	141.957	8883625.0
2022-06-27 17:00:00	AAPL	Stock	141.95	141.98	141.92	141.92	22177.0
2022-06-27 18:00:00	AAPL	Stock	141.95	141.95	141.75	141.87	19591.0
2022-06-27 19:00:00	AAPL	Stock	141.87	141.98	141.87	141.98	34506.0
2022-06-27 04:00:00	MSFT	Stock	268.5	270.55	268.5	269.36	10673.0
2022-06-27 05:00:00	MSFT	Stock	269.3	269.7	269.11	269.4	1861.0
2022-06-27 06:00:00	MSFT	Stock	269.32	269.32	268.5	268.82	3343.0
2022-06-27 07:00:00	MSFT	Stock	268.7	269.45	268.7	269.0	15914.0
2022-06-27 08:00:00	MSFT	Stock	269.0979	269.5859	267.75	268.0	53762.0
2022-06-27 09:00:00	MSFT	Stock	267.83	268.74	264.83	265.54	2276148.0
2022-06-27 10:00:00	MSFT	Stock	265.56	267.19	265.195	267.05	1769852.0
2022-06-27 11:00:00	MSFT	Stock	267.07	267.18	265.13	265.98	1364879.0
2022-06-27 12:00:00	MSFT	Stock	265.99	266.125	264.64	265.56	1392253.0
2022-06-27 13:00:00	MSFT	Stock	265.5605	265.68	264.36	264.56	1098724.0
2022-06-27 14:00:00	MSFT	Stock	264.55	265.4516	264.3	264.74	1038664.0
2022-06-27 15:00:00	MSFT	Stock	264.74	265.1086	263.28	264.92	2830825.0
2022-06-27 16:00:00	MSFT	Stock	264.89	265.73	264.75	265.68	5574331.0
2022-06-27 17:00:00	MSFT	Stock	265.512	265.68	265.5	265.6	6328.0
2022-06-27 18:00:00	MSFT	Stock	265.55	265.55	265.18	265.22	3011.0
2022-06-27 19:00:00	MSFT	Stock	265.3001	265.59	265.26	265.44	6882.0
2022-06-27 04:00:00	NVDA	Stock	17.256	17.495	17.256	17.397	465830.0
2022-06-27 05:00:00	NVDA	Stock	17.415	17.415	17.36	17.382	29600.0
2022-06-27 06:00:00	NVDA	Stock	17.381	17.381	17.291	17.336	46530.0
2022-06-27 07:00:00	NVDA	Stock	17.317	17.416	17.302	17.32	451220.0
2022-06-27 08:00:00	NVDA	Stock	17.33	17.4231	17.0832	17.235	1198440.0
2022-06-27 09:00:00	NVDA	Stock	17.25	17.387	16.6255	16.7987	61747450.0
2022-06-27 10:00:00	NVDA	Stock	16.802	17.1011	16.673	17.07	70342010.0
2022-06-27 11:00:00	NVDA	Stock	17.0755	17.157	16.969	17.0225	53766520.0
2022-06-27 12:00:00	NVDA	Stock	17.024	17.043	16.88	17.01	34999090.0
2022-06-27 13:00:00	NVDA	Stock	17.01	17.039	16.872	16.884	31580630.0
2022-06-27 14:00:00	NVDA	Stock	16.884	17.023	16.863	16.954	27885950.0
2022-06-27 15:00:00	NVDA	Stock	16.956	16.972	16.766	16.87	47159630.0
2022-06-27 16:00:00	NVDA	Stock	16.869	16.925	16.801	16.905	20052960.0
2022-06-27 17:00:00	NVDA	Stock	16.8981	16.913	16.889	16.9009	72540.0
2022-06-27 18:00:00	NVDA	Stock	16.905	16.908	16.871	16.89	51020.0
2022-06-27 19:00:00	NVDA	Stock	16.89	16.9	16.88	16.9	110830.0
2022-06-27 04:00:00	AMZN	Stock	117.41	118.09	116.9	117.46	29767.0
2022-06-27 05:00:00	AMZN	Stock	117.46	117.74	117.35	117.6	15649.0

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

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