PREVIEW / stock_1hour / 2019-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-01-04.parquet
  size:    1.1 MB
  rows:    50,161
  symbols: 2,704

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
2019-01-04 04:00:00	AAPL	Stock	35.95	36.1625	35.9125	35.9575	173108.0
2019-01-04 05:00:00	AAPL	Stock	35.98	36.2375	35.9625	36.2025	138888.0
2019-01-04 06:00:00	AAPL	Stock	36.2025	36.2375	36.0375	36.0825	211804.0
2019-01-04 07:00:00	AAPL	Stock	36.0525	36.115	35.965	36.0375	511928.0
2019-01-04 08:00:00	AAPL	Stock	35.9775	36.12	35.9375	35.9775	1547472.0
2019-01-04 09:00:00	AAPL	Stock	35.9775	36.3525	35.9	36.3475	35415888.0
2019-01-04 10:00:00	AAPL	Stock	36.345	36.81	36.295	36.7975	44250172.0
2019-01-04 11:00:00	AAPL	Stock	36.7975	36.9925	36.7425	36.775	25558492.0
2019-01-04 12:00:00	AAPL	Stock	36.775	36.965	36.7125	36.88	16621808.0
2019-01-04 13:00:00	AAPL	Stock	36.8825	37.1375	36.8675	36.9638	20028152.0
2019-01-04 14:00:00	AAPL	Stock	36.965	37.0875	36.7875	36.7915	15641968.0
2019-01-04 15:00:00	AAPL	Stock	36.79	37.0725	36.77	37.065	27686720.0
2019-01-04 16:00:00	AAPL	Stock	37.065	37.0848	36.772	37.0025	15561584.0
2019-01-04 17:00:00	AAPL	Stock	37.0	37.0225	37.0	37.0075	138340.0
2019-01-04 18:00:00	AAPL	Stock	37.0075	37.05	37.005	37.045	59964.0
2019-01-04 19:00:00	AAPL	Stock	37.0375	37.1	37.0225	37.1	117172.0
2019-01-04 04:00:00	MSFT	Stock	98.23	99.2	98.05	99.0	2330.0
2019-01-04 05:00:00	MSFT	Stock	99.15	99.29	98.9	99.14	2929.0
2019-01-04 06:00:00	MSFT	Stock	99.15	99.49	99.09	99.2	11082.0
2019-01-04 07:00:00	MSFT	Stock	99.2	99.25	98.71	98.83	57990.0
2019-01-04 08:00:00	MSFT	Stock	98.9	99.25	98.6	98.95	108119.0
2019-01-04 09:00:00	MSFT	Stock	98.9	100.44	98.8	100.355	4579598.0
2019-01-04 10:00:00	MSFT	Stock	100.36	101.96	99.58	101.69	7033638.0
2019-01-04 11:00:00	MSFT	Stock	101.68	102.08	101.271	101.72	5629611.0
2019-01-04 12:00:00	MSFT	Stock	101.7	102.37	101.37	102.143	3523659.0
2019-01-04 13:00:00	MSFT	Stock	102.145	102.51	101.91	102.05	3257373.0
2019-01-04 14:00:00	MSFT	Stock	102.06	102.35	101.63	101.675	3289901.0
2019-01-04 15:00:00	MSFT	Stock	101.67	102.05	101.42	101.93	6574778.0
2019-01-04 16:00:00	MSFT	Stock	101.93	102.06	101.84	101.92	5969588.0
2019-01-04 17:00:00	MSFT	Stock	101.9	101.9	101.85	101.9	2099.0
2019-01-04 18:00:00	MSFT	Stock	101.9	102.1	101.85	102.06	10459.0
2019-01-04 19:00:00	MSFT	Stock	102.0	102.15	102.0	102.15	5894.0
2019-01-04 04:00:00	NVDA	Stock	3.2688	3.272	3.2688	3.272	8000.0
2019-01-04 05:00:00	NVDA	Stock	3.272	3.272	3.272	3.272	4000.0
2019-01-04 06:00:00	NVDA	Stock	3.2628	3.2733	3.2625	3.2733	112000.0
2019-01-04 07:00:00	NVDA	Stock	3.2725	3.2748	3.2525	3.2575	1383720.0
2019-01-04 08:00:00	NVDA	Stock	3.2748	3.2748	3.2413	3.2628	4032120.0
2019-01-04 09:00:00	NVDA	Stock	3.2585	3.3097	3.2425	3.3011	95237680.0
2019-01-04 10:00:00	NVDA	Stock	3.3018	3.38	3.294	3.3772	113144040.0
2019-01-04 11:00:00	NVDA	Stock	3.3768	3.4045	3.3525	3.3972	73228160.0
2019-01-04 12:00:00	NVDA	Stock	3.395	3.4368	3.3932	3.4035	59850080.0
2019-01-04 13:00:00	NVDA	Stock	3.4055	3.4432	3.3955	3.401	51907200.0
2019-01-04 14:00:00	NVDA	Stock	3.4025	3.4147	3.3815	3.383	52192800.0
2019-01-04 15:00:00	NVDA	Stock	3.3825	3.4053	3.3763	3.4048	73124720.0
2019-01-04 16:00:00	NVDA	Stock	3.4048	3.405	3.3975	3.4013	2021400.0
2019-01-04 17:00:00	NVDA	Stock	3.4013	3.4013	3.3998	3.3998	788520.0
2019-01-04 18:00:00	NVDA	Stock	3.3998	3.4062	3.3998	3.4062	223800.0
2019-01-04 19:00:00	NVDA	Stock	3.4042	3.419	3.4042	3.4075	474080.0
2019-01-04 04:00:00	AMZN	Stock	76.0	76.5	75.901	76.44	82000.0
2019-01-04 05:00:00	AMZN	Stock	76.372	76.4	76.2985	76.4	17780.0

> showing 50 of 50,161 rows — these rows as CSV

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