PREVIEW / stock_1hour / 2019-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-03.parquet
  size:    1.1 MB
  rows:    50,338
  symbols: 2,630

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-04-03 04:00:00	AAPL	Stock	48.6775	48.7975	48.675	48.7275	16060.0
2019-04-03 05:00:00	AAPL	Stock	48.7175	48.735	48.665	48.725	42588.0
2019-04-03 06:00:00	AAPL	Stock	48.7125	48.7125	48.475	48.55	55928.0
2019-04-03 07:00:00	AAPL	Stock	48.555	48.595	48.4125	48.42	235740.0
2019-04-03 08:00:00	AAPL	Stock	48.56	48.595	48.2225	48.29	631360.0
2019-04-03 09:00:00	AAPL	Stock	48.3125	48.7975	48.2875	48.7125	14931012.0
2019-04-03 10:00:00	AAPL	Stock	48.7075	49.0188	48.6225	49.0025	14907752.0
2019-04-03 11:00:00	AAPL	Stock	49.005	49.125	48.945	49.0725	10481096.0
2019-04-03 12:00:00	AAPL	Stock	49.073	49.1125	48.89	48.895	5809848.0
2019-04-03 13:00:00	AAPL	Stock	48.8925	48.97	48.685	48.7375	7014116.0
2019-04-03 14:00:00	AAPL	Stock	48.735	48.87	48.6625	48.72	6420924.0
2019-04-03 15:00:00	AAPL	Stock	48.7225	48.865	48.59	48.8375	12027208.0
2019-04-03 16:00:00	AAPL	Stock	48.8375	48.8625	48.77	48.8375	9887624.0
2019-04-03 17:00:00	AAPL	Stock	48.85	48.8875	48.85	48.85	22020.0
2019-04-03 18:00:00	AAPL	Stock	48.85	48.895	48.85	48.8675	52060.0
2019-04-03 19:00:00	AAPL	Stock	48.875	48.895	48.8625	48.895	25924.0
2019-04-03 04:00:00	MSFT	Stock	119.6	119.94	119.6	119.94	1295.0
2019-04-03 05:00:00	MSFT	Stock	119.81	119.89	119.81	119.88	2229.0
2019-04-03 06:00:00	MSFT	Stock	119.87	119.87	119.7	119.7	2191.0
2019-04-03 07:00:00	MSFT	Stock	119.7	119.8	119.6	119.7	21829.0
2019-04-03 08:00:00	MSFT	Stock	119.8	119.9	119.6	119.65	36132.0
2019-04-03 09:00:00	MSFT	Stock	119.73	120.01	119.23	119.49	2829252.0
2019-04-03 10:00:00	MSFT	Stock	119.49	119.86	119.15	119.85	2389690.0
2019-04-03 11:00:00	MSFT	Stock	119.85	120.43	119.85	120.21	2943511.0
2019-04-03 12:00:00	MSFT	Stock	120.21	120.296	120.05	120.195	1357542.0
2019-04-03 13:00:00	MSFT	Stock	120.195	120.23	119.63	119.67	1508538.0
2019-04-03 14:00:00	MSFT	Stock	119.67	119.8	119.47	119.59	1606664.0
2019-04-03 15:00:00	MSFT	Stock	119.59	120.0	119.33	119.97	3362839.0
2019-04-03 16:00:00	MSFT	Stock	119.97	120.13	119.92	120.1	3785030.0
2019-04-03 17:00:00	MSFT	Stock	120.2	120.2	120.029	120.15	1925.0
2019-04-03 18:00:00	MSFT	Stock	120.18	120.18	120.01	120.05	1530.0
2019-04-03 19:00:00	MSFT	Stock	120.06	120.17	120.01	120.1	1711.0
2019-04-03 04:00:00	NVDA	Stock	4.5925	4.6195	4.5925	4.6128	241520.0
2019-04-03 05:00:00	NVDA	Stock	4.6165	4.6165	4.6165	4.6165	8000.0
2019-04-03 06:00:00	NVDA	Stock	4.6218	4.627	4.6218	4.6268	42240.0
2019-04-03 07:00:00	NVDA	Stock	4.625	4.6362	4.62	4.6325	1069560.0
2019-04-03 08:00:00	NVDA	Stock	4.6212	4.645	4.6208	4.6338	3622600.0
2019-04-03 09:00:00	NVDA	Stock	4.6305	4.7345	4.62	4.7032	207989320.0
2019-04-03 10:00:00	NVDA	Stock	4.7032	4.75	4.6948	4.7412	137080560.0
2019-04-03 11:00:00	NVDA	Stock	4.7422	4.7708	4.7412	4.7693	98629760.0
2019-04-03 12:00:00	NVDA	Stock	4.7698	4.775	4.7231	4.7312	84206080.0
2019-04-03 13:00:00	NVDA	Stock	4.7307	4.7519	4.705	4.7078	58046880.0
2019-04-03 14:00:00	NVDA	Stock	4.707	4.733	4.6914	4.7125	60144280.0
2019-04-03 15:00:00	NVDA	Stock	4.7125	4.7245	4.6868	4.7155	92995600.0
2019-04-03 16:00:00	NVDA	Stock	4.7155	4.7285	4.6953	4.7285	5090560.0
2019-04-03 17:00:00	NVDA	Stock	4.725	4.7362	4.7248	4.7325	454160.0
2019-04-03 18:00:00	NVDA	Stock	4.7325	4.7345	4.7288	4.7325	251560.0
2019-04-03 19:00:00	NVDA	Stock	4.7325	4.7345	4.7288	4.733	203120.0
2019-04-03 04:00:00	AMZN	Stock	91.28	91.28	91.28	91.28	2000.0
2019-04-03 05:00:00	AMZN	Stock	91.363	91.363	91.3075	91.3175	10000.0

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

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