PREVIEW / stock_1hour / 2020-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-11.parquet
  size:    1.2 MB
  rows:    56,640
  symbols: 2,381

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-05-11 04:00:00	AAPL	Stock	77.785	77.9125	77.355	77.375	85708.0
2020-05-11 05:00:00	AAPL	Stock	77.375	77.4375	77.15	77.4025	52688.0
2020-05-11 06:00:00	AAPL	Stock	77.4	77.425	77.0025	77.165	30808.0
2020-05-11 07:00:00	AAPL	Stock	77.1875	77.3225	76.87	76.95	560988.0
2020-05-11 08:00:00	AAPL	Stock	77.0	77.3125	76.7525	76.8375	661104.0
2020-05-11 09:00:00	AAPL	Stock	76.8375	77.6225	76.81	77.4625	18427964.0
2020-05-11 10:00:00	AAPL	Stock	77.4525	78.16	77.43	77.9818	22861776.0
2020-05-11 11:00:00	AAPL	Stock	77.99	78.4575	77.9725	78.3188	14068048.0
2020-05-11 12:00:00	AAPL	Stock	78.315	78.435	78.1725	78.3105	9397468.0
2020-05-11 13:00:00	AAPL	Stock	78.31	78.8025	78.235	78.7125	14778336.0
2020-05-11 14:00:00	AAPL	Stock	78.7075	79.0675	78.6275	79.0125	12759936.0
2020-05-11 15:00:00	AAPL	Stock	79.015	79.2625	78.7475	78.7512	20248824.0
2020-05-11 16:00:00	AAPL	Stock	78.7525	78.81	78.6425	78.74	4753512.0
2020-05-11 17:00:00	AAPL	Stock	78.7425	78.7875	78.69	78.7375	49292.0
2020-05-11 18:00:00	AAPL	Stock	78.7475	78.9875	78.7475	78.945	126428.0
2020-05-11 19:00:00	AAPL	Stock	78.875	78.95	78.79	78.8025	139908.0
2020-05-11 04:00:00	MSFT	Stock	185.51	185.51	184.0	184.27	22699.0
2020-05-11 05:00:00	MSFT	Stock	184.15	184.57	183.91	184.33	6823.0
2020-05-11 06:00:00	MSFT	Stock	183.82	184.38	183.78	183.97	6588.0
2020-05-11 07:00:00	MSFT	Stock	183.97	184.2	183.1	183.14	21855.0
2020-05-11 08:00:00	MSFT	Stock	183.85	184.1	182.7	183.094	86872.0
2020-05-11 09:00:00	MSFT	Stock	183.14	185.104	182.85	184.52	3615077.0
2020-05-11 10:00:00	MSFT	Stock	184.52	185.48	184.45	185.025	3634033.0
2020-05-11 11:00:00	MSFT	Stock	185.03	185.578	184.95	185.45	2416546.0
2020-05-11 12:00:00	MSFT	Stock	185.44	185.79	185.22	185.78	2163336.0
2020-05-11 13:00:00	MSFT	Stock	185.775	187.13	185.66	186.958	2702339.0
2020-05-11 14:00:00	MSFT	Stock	186.96	187.33	186.57	187.24	2052252.0
2020-05-11 15:00:00	MSFT	Stock	187.23	187.51	186.63	186.65	3905164.0
2020-05-11 16:00:00	MSFT	Stock	186.71	186.96	186.3	186.7	2431379.0
2020-05-11 17:00:00	MSFT	Stock	186.69	186.75	186.59	186.7	5326.0
2020-05-11 18:00:00	MSFT	Stock	186.7	187.15	186.66	186.95	46473.0
2020-05-11 19:00:00	MSFT	Stock	186.95	186.95	186.0	186.5	27533.0
2020-05-11 04:00:00	NVDA	Stock	7.85	7.855	7.775	7.775	139040.0
2020-05-11 05:00:00	NVDA	Stock	7.7755	7.782	7.7755	7.782	13440.0
2020-05-11 07:00:00	NVDA	Stock	7.7598	7.8075	7.743	7.7532	1199560.0
2020-05-11 08:00:00	NVDA	Stock	7.775	7.8	7.719	7.7596	2145240.0
2020-05-11 09:00:00	NVDA	Stock	7.7498	7.9905	7.7498	7.9762	87412320.0
2020-05-11 10:00:00	NVDA	Stock	7.9752	8.037	7.9708	7.9939	82872280.0
2020-05-11 11:00:00	NVDA	Stock	7.995	8.0625	7.9848	8.0588	61014480.0
2020-05-11 12:00:00	NVDA	Stock	8.0585	8.0898	8.0375	8.0515	54327200.0
2020-05-11 13:00:00	NVDA	Stock	8.0498	8.1027	8.041	8.079	38914680.0
2020-05-11 14:00:00	NVDA	Stock	8.079	8.1117	8.068	8.096	31482400.0
2020-05-11 15:00:00	NVDA	Stock	8.097	8.1125	8.0628	8.0632	51702560.0
2020-05-11 16:00:00	NVDA	Stock	8.0655	8.075	8.0567	8.0655	12320520.0
2020-05-11 17:00:00	NVDA	Stock	8.0718	8.0822	8.0625	8.0675	498920.0
2020-05-11 18:00:00	NVDA	Stock	8.07	8.0922	8.07	8.0922	134400.0
2020-05-11 19:00:00	NVDA	Stock	8.0888	8.0972	8.0755	8.0875	434880.0
2020-05-11 06:00:00	AMZN	Stock	118.515	118.515	118.515	118.515	4720.0
2020-05-11 07:00:00	AMZN	Stock	118.625	118.745	118.405	118.405	64520.0
2020-05-11 08:00:00	AMZN	Stock	118.8878	118.8878	118.396	118.5205	229400.0

> showing 50 of 56,640 rows — these rows as CSV

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