PREVIEW / stock_1hour / 2021-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-12.parquet
  size:    1.4 MB
  rows:    62,917
  symbols: 2,670

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-10-12 04:00:00	AAPL	Stock	142.3	142.5	142.2	142.35	114608.0
2021-10-12 05:00:00	AAPL	Stock	142.46	142.8	142.4	142.7	20948.0
2021-10-12 06:00:00	AAPL	Stock	142.75	143.0	142.66	143.0	12135.0
2021-10-12 07:00:00	AAPL	Stock	143.01	143.22	142.9	143.0	133867.0
2021-10-12 08:00:00	AAPL	Stock	143.02	143.44	142.9	143.21	384664.0
2021-10-12 09:00:00	AAPL	Stock	143.18	143.45	141.885	141.885	8735822.0
2021-10-12 10:00:00	AAPL	Stock	141.885	142.29	141.42	141.53	9439937.0
2021-10-12 11:00:00	AAPL	Stock	141.54	142.31	141.54	142.3	6016745.0
2021-10-12 12:00:00	AAPL	Stock	142.3	142.98	141.8	141.85	7806258.0
2021-10-12 13:00:00	AAPL	Stock	141.85	142.11	141.63	141.8953	4191724.0
2021-10-12 14:00:00	AAPL	Stock	141.89	142.48	141.8001	141.96	4525666.0
2021-10-12 15:00:00	AAPL	Stock	141.97	142.005	141.0401	141.46	10338396.0
2021-10-12 16:00:00	AAPL	Stock	141.46	141.56	139.27	139.91	12672457.0
2021-10-12 17:00:00	AAPL	Stock	139.91	139.93	139.36	139.4301	318038.0
2021-10-12 18:00:00	AAPL	Stock	139.41	139.58	139.38	139.53	128235.0
2021-10-12 19:00:00	AAPL	Stock	139.55	139.68	139.5	139.63	149835.0
2021-10-12 04:00:00	MSFT	Stock	293.9	294.1	293.62	294.1	2652.0
2021-10-12 05:00:00	MSFT	Stock	294.49	294.88	294.49	294.83	449.0
2021-10-12 06:00:00	MSFT	Stock	294.71	295.3	294.52	295.3	4280.0
2021-10-12 07:00:00	MSFT	Stock	295.3	295.39	294.63	294.85	32336.0
2021-10-12 08:00:00	MSFT	Stock	295.4742	296.11	294.72	295.22	34279.0
2021-10-12 09:00:00	MSFT	Stock	295.22	295.82	292.7	292.999	1661273.0
2021-10-12 10:00:00	MSFT	Stock	292.98	294.16	292.79	292.9	1750677.0
2021-10-12 11:00:00	MSFT	Stock	292.94	294.2499	292.9	294.2201	1098139.0
2021-10-12 12:00:00	MSFT	Stock	294.24	294.9	293.76	293.95	1048210.0
2021-10-12 13:00:00	MSFT	Stock	293.92	294.145	293.47	293.66	827730.0
2021-10-12 14:00:00	MSFT	Stock	293.63	294.95	293.55	293.72	1203355.0
2021-10-12 15:00:00	MSFT	Stock	293.74	293.85	292.35	292.88	2279485.0
2021-10-12 16:00:00	MSFT	Stock	292.88	293.34	292.12	292.45	2589377.0
2021-10-12 17:00:00	MSFT	Stock	292.35	292.45	292.2	292.2	7452.0
2021-10-12 18:00:00	MSFT	Stock	292.2	292.34	292.16	292.3	4969.0
2021-10-12 19:00:00	MSFT	Stock	292.39	292.7	292.27	292.35	9248.0
2021-10-12 04:00:00	NVDA	Stock	20.585	20.674	20.563	20.668	22420.0
2021-10-12 05:00:00	NVDA	Stock	20.69	20.79	20.69	20.75	209050.0
2021-10-12 06:00:00	NVDA	Stock	20.77	20.83	20.77	20.824	49860.0
2021-10-12 07:00:00	NVDA	Stock	20.82	20.849	20.781	20.785	264480.0
2021-10-12 08:00:00	NVDA	Stock	20.82	20.878	20.6433	20.838	620560.0
2021-10-12 09:00:00	NVDA	Stock	20.818	21.057	20.732	20.7575	23470370.0
2021-10-12 10:00:00	NVDA	Stock	20.755	20.944	20.661	20.671	26493880.0
2021-10-12 11:00:00	NVDA	Stock	20.68	20.829	20.675	20.8279	13024430.0
2021-10-12 12:00:00	NVDA	Stock	20.83	20.87	20.623	20.64	11121180.0
2021-10-12 13:00:00	NVDA	Stock	20.639	20.665	20.528	20.625	11834610.0
2021-10-12 14:00:00	NVDA	Stock	20.624	20.765	20.612	20.685	12944880.0
2021-10-12 15:00:00	NVDA	Stock	20.686	20.733	20.596	20.668	16439860.0
2021-10-12 16:00:00	NVDA	Stock	20.671	20.679	20.511	20.56	12045770.0
2021-10-12 17:00:00	NVDA	Stock	20.572	20.572	20.54	20.55	74740.0
2021-10-12 18:00:00	NVDA	Stock	20.556	20.587	20.55	20.55	68840.0
2021-10-12 19:00:00	NVDA	Stock	20.588	20.591	20.541	20.57	126950.0
2021-10-12 07:00:00	AMZN	Stock	162.78	162.78	162.78	162.78	2000.0
2021-10-12 08:00:00	AMZN	Stock	162.65	163.1	162.65	162.7	36980.0

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

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