PREVIEW / stock_1hour / 2020-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-12.parquet
  size:    1.2 MB
  rows:    57,289
  symbols: 2,412

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
2020-06-12 04:00:00	AAPL	Stock	85.25	85.9775	85.245	85.9	51664.0
2020-06-12 05:00:00	AAPL	Stock	85.9	85.9475	85.66	85.8875	34420.0
2020-06-12 06:00:00	AAPL	Stock	85.91	85.95	85.2925	85.625	77360.0
2020-06-12 07:00:00	AAPL	Stock	85.5875	85.9375	85.5	85.7375	437612.0
2020-06-12 08:00:00	AAPL	Stock	85.675	86.0625	85.2857	85.9175	683784.0
2020-06-12 09:00:00	AAPL	Stock	85.875	86.95	85.805	86.6288	21088256.0
2020-06-12 10:00:00	AAPL	Stock	86.6275	86.8	84.2952	84.3075	22030512.0
2020-06-12 11:00:00	AAPL	Stock	84.315	85.595	83.7977	85.57	27409312.0
2020-06-12 12:00:00	AAPL	Stock	85.5725	85.8625	84.715	85.1928	17044268.0
2020-06-12 13:00:00	AAPL	Stock	85.2	85.2325	83.5558	83.6925	18615116.0
2020-06-12 14:00:00	AAPL	Stock	83.6875	84.825	83.5775	84.7775	20241412.0
2020-06-12 15:00:00	AAPL	Stock	84.755	85.25	84.055	84.6325	24672016.0
2020-06-12 16:00:00	AAPL	Stock	84.635	85.0138	84.5025	84.5825	9688976.0
2020-06-12 17:00:00	AAPL	Stock	84.6425	84.6875	84.5	84.55	37568.0
2020-06-12 18:00:00	AAPL	Stock	84.575	84.645	84.54	84.6175	93428.0
2020-06-12 19:00:00	AAPL	Stock	84.6175	84.7	84.5325	84.6	35964.0
2020-06-12 04:00:00	MSFT	Stock	189.38	190.0	189.22	190.0	6566.0
2020-06-12 05:00:00	MSFT	Stock	190.14	190.97	189.7	190.92	5092.0
2020-06-12 06:00:00	MSFT	Stock	190.6	191.0	190.0	190.08	7371.0
2020-06-12 07:00:00	MSFT	Stock	190.27	190.72	189.63	189.93	82141.0
2020-06-12 08:00:00	MSFT	Stock	190.0	190.5	187.3	189.83	246427.0
2020-06-12 09:00:00	MSFT	Stock	189.773	191.72	189.77	190.93	4653341.0
2020-06-12 10:00:00	MSFT	Stock	190.94	191.27	187.96	188.065	4428414.0
2020-06-12 11:00:00	MSFT	Stock	188.04	189.98	187.0	189.83	4799488.0
2020-06-12 12:00:00	MSFT	Stock	189.838	190.19	188.06	188.939	3309194.0
2020-06-12 13:00:00	MSFT	Stock	188.95	189.05	185.25	185.31	3933962.0
2020-06-12 14:00:00	MSFT	Stock	185.32	187.55	185.18	187.1	3726724.0
2020-06-12 15:00:00	MSFT	Stock	187.12	188.85	186.15	187.72	5691517.0
2020-06-12 16:00:00	MSFT	Stock	187.72	187.985	187.3	187.86	4903309.0
2020-06-12 17:00:00	MSFT	Stock	187.8	187.95	187.61	187.93	20945.0
2020-06-12 18:00:00	MSFT	Stock	187.93	188.03	187.9	187.93	6237.0
2020-06-12 19:00:00	MSFT	Stock	188.02	188.45	188.0	188.33	15101.0
2020-06-12 04:00:00	NVDA	Stock	8.9625	9.0948	8.9625	9.0948	23200.0
2020-06-12 05:00:00	NVDA	Stock	9.0748	9.0748	9.04	9.04	130720.0
2020-06-12 06:00:00	NVDA	Stock	9.07	9.0765	9.0375	9.0375	81600.0
2020-06-12 07:00:00	NVDA	Stock	9.0375	9.0625	9.0188	9.0442	1079120.0
2020-06-12 08:00:00	NVDA	Stock	9.025	9.0675	8.9875	9.0438	2144240.0
2020-06-12 09:00:00	NVDA	Stock	9.0472	9.1958	9.0312	9.1502	72509080.0
2020-06-12 10:00:00	NVDA	Stock	9.1514	9.1552	8.9257	8.9276	73868360.0
2020-06-12 11:00:00	NVDA	Stock	8.927	8.9748	8.7985	8.971	81251520.0
2020-06-12 12:00:00	NVDA	Stock	8.9719	9.0178	8.8782	8.935	61335800.0
2020-06-12 13:00:00	NVDA	Stock	8.94	8.945	8.7034	8.7142	67091720.0
2020-06-12 14:00:00	NVDA	Stock	8.7148	8.8901	8.705	8.8859	55916040.0
2020-06-12 15:00:00	NVDA	Stock	8.887	8.9568	8.7908	8.9325	84349120.0
2020-06-12 16:00:00	NVDA	Stock	8.9275	8.9575	8.9275	8.9502	5697320.0
2020-06-12 17:00:00	NVDA	Stock	8.95	8.955	8.9375	8.9538	451480.0
2020-06-12 18:00:00	NVDA	Stock	8.949	8.9545	8.949	8.9545	277520.0
2020-06-12 19:00:00	NVDA	Stock	8.952	8.9582	8.95	8.955	454040.0
2020-06-12 04:00:00	AMZN	Stock	129.5	129.6455	129.3625	129.6455	26040.0
2020-06-12 05:00:00	AMZN	Stock	129.4475	129.4745	129.4475	129.4745	7720.0

> showing 50 of 57,289 rows — these rows as CSV

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