PREVIEW / stock_1hour / 2021-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-23.parquet
  size:    1.5 MB
  rows:    67,065
  symbols: 2,915

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-03-23 04:00:00	AAPL	Stock	123.02	123.02	122.31	122.68	25562.0
2021-03-23 05:00:00	AAPL	Stock	122.68	122.87	122.2	122.5	18667.0
2021-03-23 06:00:00	AAPL	Stock	122.35	122.93	122.35	122.72	29511.0
2021-03-23 07:00:00	AAPL	Stock	122.84	123.31	122.76	123.11	160546.0
2021-03-23 08:00:00	AAPL	Stock	122.8818	123.698	122.86	123.42	456653.0
2021-03-23 09:00:00	AAPL	Stock	123.42	123.69	122.5382	122.7591	9836567.0
2021-03-23 10:00:00	AAPL	Stock	122.755	123.76	122.6	123.24	13298208.0
2021-03-23 11:00:00	AAPL	Stock	123.24	124.24	122.84	123.18	13761844.0
2021-03-23 12:00:00	AAPL	Stock	123.175	123.36	122.66	123.149	7384488.0
2021-03-23 13:00:00	AAPL	Stock	123.1499	123.615	122.92	123.0498	6523698.0
2021-03-23 14:00:00	AAPL	Stock	123.045	123.43	122.52	122.5358	7502518.0
2021-03-23 15:00:00	AAPL	Stock	122.5213	122.82	122.14	122.535	14124976.0
2021-03-23 16:00:00	AAPL	Stock	122.54	122.69	122.51	122.66	8943080.0
2021-03-23 17:00:00	AAPL	Stock	122.62	122.68	122.55	122.58	54171.0
2021-03-23 18:00:00	AAPL	Stock	122.62	122.62	122.3	122.41	330421.0
2021-03-23 19:00:00	AAPL	Stock	122.4	122.45	122.31	122.45	62212.0
2021-03-23 04:00:00	MSFT	Stock	236.38	236.38	235.9	236.1	2606.0
2021-03-23 05:00:00	MSFT	Stock	235.56	235.56	235.01	235.01	8125.0
2021-03-23 06:00:00	MSFT	Stock	235.18	236.15	235.18	236.15	6032.0
2021-03-23 07:00:00	MSFT	Stock	235.93	236.64	235.58	236.64	6011.0
2021-03-23 08:00:00	MSFT	Stock	235.93	237.0	235.401	237.0	20533.0
2021-03-23 09:00:00	MSFT	Stock	236.95	238.94	236.65	237.93	2500305.0
2021-03-23 10:00:00	MSFT	Stock	237.84	239.87	237.57	239.86	3009811.0
2021-03-23 11:00:00	MSFT	Stock	239.83	241.05	239.76	240.12	3142255.0
2021-03-23 12:00:00	MSFT	Stock	240.16	240.55	238.95	240.01	1808475.0
2021-03-23 13:00:00	MSFT	Stock	240.02	240.68	239.6	239.8637	1705070.0
2021-03-23 14:00:00	MSFT	Stock	239.89	240.91	239.36	239.38	2071062.0
2021-03-23 15:00:00	MSFT	Stock	239.36	239.57	237.07	237.5	5541710.0
2021-03-23 16:00:00	MSFT	Stock	237.58	237.97	237.49	237.77	4551767.0
2021-03-23 17:00:00	MSFT	Stock	237.85	237.85	237.58	237.7	7243.0
2021-03-23 18:00:00	MSFT	Stock	237.7	237.9	237.58	237.89	7822.0
2021-03-23 19:00:00	MSFT	Stock	237.74	237.85	237.54	237.54	9798.0
2021-03-23 04:00:00	NVDA	Stock	13.125	13.125	13.0625	13.085	16000.0
2021-03-23 05:00:00	NVDA	Stock	13.085	13.085	13.085	13.085	4000.0
2021-03-23 06:00:00	NVDA	Stock	13.0752	13.125	13.0752	13.11	14120.0
2021-03-23 07:00:00	NVDA	Stock	13.1798	13.2455	13.15	13.225	232440.0
2021-03-23 08:00:00	NVDA	Stock	13.2363	13.2472	13.1625	13.2155	526040.0
2021-03-23 09:00:00	NVDA	Stock	13.2122	13.323	13.1652	13.2598	22080840.0
2021-03-23 10:00:00	NVDA	Stock	13.2592	13.3445	13.1611	13.2803	24765280.0
2021-03-23 11:00:00	NVDA	Stock	13.2768	13.3215	13.1952	13.22	12667120.0
2021-03-23 12:00:00	NVDA	Stock	13.2173	13.2608	13.1572	13.247	7666200.0
2021-03-23 13:00:00	NVDA	Stock	13.246	13.2752	13.1505	13.1658	8455760.0
2021-03-23 14:00:00	NVDA	Stock	13.1682	13.2625	13.1288	13.1305	9629920.0
2021-03-23 15:00:00	NVDA	Stock	13.1325	13.1748	13.0213	13.0688	27545240.0
2021-03-23 16:00:00	NVDA	Stock	13.0708	13.0908	13.0708	13.0868	14353240.0
2021-03-23 17:00:00	NVDA	Stock	13.091	13.1125	13.091	13.1125	96440.0
2021-03-23 18:00:00	NVDA	Stock	13.0875	13.0875	13.05	13.0748	134040.0
2021-03-23 19:00:00	NVDA	Stock	13.0625	13.0748	13.0538	13.055	85960.0
2021-03-23 05:00:00	AMZN	Stock	155.3	155.3	155.3	155.3	4000.0
2021-03-23 06:00:00	AMZN	Stock	155.75	155.75	155.3	155.3	4040.0

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

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