PREVIEW / stock_1hour / 2020-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-05.parquet
  size:    1.2 MB
  rows:    52,599
  symbols: 2,432

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-03-05 04:00:00	AAPL	Stock	74.215	74.495	74.0	74.2575	79644.0
2020-03-05 05:00:00	AAPL	Stock	74.255	74.255	73.8375	73.8375	103448.0
2020-03-05 06:00:00	AAPL	Stock	73.875	74.1725	73.7425	73.9025	123404.0
2020-03-05 07:00:00	AAPL	Stock	73.985	74.35	73.8625	74.1275	728988.0
2020-03-05 08:00:00	AAPL	Stock	74.2	74.35	73.625	73.95	1191544.0
2020-03-05 09:00:00	AAPL	Stock	73.905	74.3575	73.525	73.865	20925356.0
2020-03-05 10:00:00	AAPL	Stock	73.855	74.81	73.575	74.42	23482112.0
2020-03-05 11:00:00	AAPL	Stock	74.42	74.8875	74.2125	74.3525	16148520.0
2020-03-05 12:00:00	AAPL	Stock	74.3475	74.445	73.305	73.55	17756020.0
2020-03-05 13:00:00	AAPL	Stock	73.5462	74.2125	73.345	74.01	16440076.0
2020-03-05 14:00:00	AAPL	Stock	74.0025	74.0025	73.445	73.615	13335012.0
2020-03-05 15:00:00	AAPL	Stock	73.6125	73.7425	72.8525	73.23	32563580.0
2020-03-05 16:00:00	AAPL	Stock	73.23	73.2725	73.0375	73.2175	14942076.0
2020-03-05 17:00:00	AAPL	Stock	73.2175	73.245	73.1275	73.21	86068.0
2020-03-05 18:00:00	AAPL	Stock	73.1875	73.4125	73.09	73.3525	211492.0
2020-03-05 19:00:00	AAPL	Stock	73.3625	73.6	73.2	73.2375	267608.0
2020-03-05 04:00:00	MSFT	Stock	167.99	167.99	166.9	167.14	14593.0
2020-03-05 05:00:00	MSFT	Stock	167.14	167.14	165.87	166.0	11164.0
2020-03-05 06:00:00	MSFT	Stock	166.2	167.0	165.8	166.66	16959.0
2020-03-05 07:00:00	MSFT	Stock	166.7	166.94	166.06	166.15	71823.0
2020-03-05 08:00:00	MSFT	Stock	166.45	167.0	165.75	166.35	145208.0
2020-03-05 09:00:00	MSFT	Stock	166.2	168.87	165.1	167.1	4922545.0
2020-03-05 10:00:00	MSFT	Stock	167.09	169.67	166.43	169.064	4741463.0
2020-03-05 11:00:00	MSFT	Stock	169.07	170.87	167.945	168.36	4631496.0
2020-03-05 12:00:00	MSFT	Stock	168.37	168.78	166.13	166.8	4024930.0
2020-03-05 13:00:00	MSFT	Stock	166.78	168.49	166.46	167.797	3827217.0
2020-03-05 14:00:00	MSFT	Stock	167.78	167.97	166.6	167.18	3139782.0
2020-03-05 15:00:00	MSFT	Stock	167.205	167.61	165.69	166.24	8670611.0
2020-03-05 16:00:00	MSFT	Stock	166.23	166.74	165.84	166.65	6687189.0
2020-03-05 17:00:00	MSFT	Stock	166.46	166.65	166.31	166.65	9219.0
2020-03-05 18:00:00	MSFT	Stock	166.55	166.9	166.2	166.7	28174.0
2020-03-05 19:00:00	MSFT	Stock	166.72	167.3	166.39	166.75	22924.0
2020-03-05 04:00:00	NVDA	Stock	6.9882	6.9882	6.9028	6.925	107280.0
2020-03-05 05:00:00	NVDA	Stock	6.9168	6.94	6.9025	6.94	89200.0
2020-03-05 06:00:00	NVDA	Stock	6.9335	6.947	6.9	6.9448	134080.0
2020-03-05 07:00:00	NVDA	Stock	6.91	6.966	6.91	6.9262	1530960.0
2020-03-05 08:00:00	NVDA	Stock	6.9458	6.9642	6.897	6.9248	2680960.0
2020-03-05 09:00:00	NVDA	Stock	6.915	7.0108	6.8403	6.8975	69858960.0
2020-03-05 10:00:00	NVDA	Stock	6.8933	7.0424	6.8713	6.9795	75822760.0
2020-03-05 11:00:00	NVDA	Stock	6.9798	7.08	6.9708	6.9963	53036800.0
2020-03-05 12:00:00	NVDA	Stock	6.9972	7.0038	6.8312	6.8356	60720440.0
2020-03-05 13:00:00	NVDA	Stock	6.8312	6.9242	6.8052	6.894	54612240.0
2020-03-05 14:00:00	NVDA	Stock	6.8935	6.8935	6.8162	6.8659	33038080.0
2020-03-05 15:00:00	NVDA	Stock	6.866	6.883	6.7875	6.8323	81914160.0
2020-03-05 16:00:00	NVDA	Stock	6.8323	6.89	6.8115	6.8585	31223160.0
2020-03-05 17:00:00	NVDA	Stock	6.8575	6.875	6.8375	6.85	761120.0
2020-03-05 18:00:00	NVDA	Stock	6.8748	6.8875	6.85	6.8875	348160.0
2020-03-05 19:00:00	NVDA	Stock	6.885	6.9025	6.8788	6.9	1255840.0
2020-03-05 04:00:00	AMZN	Stock	97.0	97.0	96.9	97.0	17240.0
2020-03-05 05:00:00	AMZN	Stock	96.756	96.8	96.7	96.7	157480.0

> showing 50 of 52,599 rows — these rows as CSV

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