PREVIEW / stock_1hour / 2022-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-12.parquet
  size:    1.4 MB
  rows:    65,549
  symbols: 2,490

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-05-12 04:00:00	AAPL	Stock	146.59	146.59	144.66	144.86	82004.0
2022-05-12 05:00:00	AAPL	Stock	144.86	144.86	144.19	144.49	87751.0
2022-05-12 06:00:00	AAPL	Stock	144.42	144.8	144.12	144.68	86723.0
2022-05-12 07:00:00	AAPL	Stock	144.68	145.05	143.43	143.46	428132.0
2022-05-12 08:00:00	AAPL	Stock	144.8205	146.63	142.9	143.02	1985280.0
2022-05-12 09:00:00	AAPL	Stock	143.03	144.11	140.2	141.02	27122379.0
2022-05-12 10:00:00	AAPL	Stock	141.01	146.1281	140.0915	145.6298	27650989.0
2022-05-12 11:00:00	AAPL	Stock	145.63	146.2	141.24	141.25	16343573.0
2022-05-12 12:00:00	AAPL	Stock	141.2451	142.6	140.57	141.8	14594272.0
2022-05-12 13:00:00	AAPL	Stock	141.78	142.47	140.0	140.26	11908224.0
2022-05-12 14:00:00	AAPL	Stock	140.22	140.48	138.8	139.6	18371186.0
2022-05-12 15:00:00	AAPL	Stock	139.61	142.86	139.4	142.59	27034107.0
2022-05-12 16:00:00	AAPL	Stock	142.55	142.99	140.9986	141.34	10558458.0
2022-05-12 17:00:00	AAPL	Stock	141.33	142.56	141.31	142.0831	185278.0
2022-05-12 18:00:00	AAPL	Stock	142.18	142.75	142.18	142.54	149137.0
2022-05-12 19:00:00	AAPL	Stock	142.5001	143.99	142.49	143.9	175704.0
2022-05-12 04:00:00	MSFT	Stock	259.6	259.6	257.5	257.77	12698.0
2022-05-12 05:00:00	MSFT	Stock	257.77	257.77	257.1	257.36	17199.0
2022-05-12 06:00:00	MSFT	Stock	257.45	259.0	257.4	258.62	11690.0
2022-05-12 07:00:00	MSFT	Stock	258.66	259.3	256.53	256.81	48100.0
2022-05-12 08:00:00	MSFT	Stock	258.6825	259.32	256.5722	257.7784	157631.0
2022-05-12 09:00:00	MSFT	Stock	257.6001	259.01	252.98	254.78	4523766.0
2022-05-12 10:00:00	MSFT	Stock	254.76	258.86	253.61	258.34	4898209.0
2022-05-12 11:00:00	MSFT	Stock	258.37	259.88	254.83	254.83	3683358.0
2022-05-12 12:00:00	MSFT	Stock	254.81	256.41	253.7779	254.6	3072696.0
2022-05-12 13:00:00	MSFT	Stock	254.5999	255.14	250.3	250.64	3887413.0
2022-05-12 14:00:00	MSFT	Stock	250.61	251.75	250.02	250.895	3925744.0
2022-05-12 15:00:00	MSFT	Stock	250.92	255.78	250.71	255.37	6556864.0
2022-05-12 16:00:00	MSFT	Stock	255.35	255.91	253.05	253.75	4560134.0
2022-05-12 17:00:00	MSFT	Stock	253.75	255.01	253.75	254.9	29042.0
2022-05-12 18:00:00	MSFT	Stock	254.78	255.8	254.78	255.59	24699.0
2022-05-12 19:00:00	MSFT	Stock	255.5	257.76	255.36	257.6	30845.0
2022-05-12 04:00:00	NVDA	Stock	16.639	16.639	16.301	16.349	389300.0
2022-05-12 05:00:00	NVDA	Stock	16.37	16.37	16.238	16.335	399050.0
2022-05-12 06:00:00	NVDA	Stock	16.301	16.401	16.294	16.345	374390.0
2022-05-12 07:00:00	NVDA	Stock	16.358	16.46	16.2	16.231	1074870.0
2022-05-12 08:00:00	NVDA	Stock	16.3998	16.611	16.1111	16.2	3151810.0
2022-05-12 09:00:00	NVDA	Stock	16.22	16.336	15.648	15.931	94928350.0
2022-05-12 10:00:00	NVDA	Stock	15.911	16.719	15.741	16.672	104931570.0
2022-05-12 11:00:00	NVDA	Stock	16.678	16.788	15.934	15.934	68679130.0
2022-05-12 12:00:00	NVDA	Stock	15.937	16.3225	15.779	16.146	68013870.0
2022-05-12 13:00:00	NVDA	Stock	16.135	16.211	15.657	15.696	46668140.0
2022-05-12 14:00:00	NVDA	Stock	15.693	15.785	15.567	15.636	48021770.0
2022-05-12 15:00:00	NVDA	Stock	15.641	16.195	15.617	16.176	80698250.0
2022-05-12 16:00:00	NVDA	Stock	16.175	16.21	16.011	16.04	20365650.0
2022-05-12 17:00:00	NVDA	Stock	16.03	16.127	15.901	16.043	1092990.0
2022-05-12 18:00:00	NVDA	Stock	16.088	16.17	16.088	16.165	484500.0
2022-05-12 19:00:00	NVDA	Stock	16.155	16.446	16.155	16.42	836070.0
2022-05-12 05:00:00	AMZN	Stock	103.749	103.749	103.749	103.749	2000.0
2022-05-12 06:00:00	AMZN	Stock	104.35	104.35	104.225	104.225	4180.0

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

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