PREVIEW / stock_1hour / 2018-03-05

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-05.parquet
  size:    1.1 MB
  rows:    49,750
  symbols: 2,882

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
2018-03-05 04:00:00	AAPL	Stock	44.025	44.025	43.85	43.9975	61828.0
2018-03-05 05:00:00	AAPL	Stock	43.9975	44.0525	43.95	44.0525	65676.0
2018-03-05 06:00:00	AAPL	Stock	44.07	44.075	43.975	44.005	42536.0
2018-03-05 07:00:00	AAPL	Stock	43.975	43.9975	43.8175	43.8375	277388.0
2018-03-05 08:00:00	AAPL	Stock	43.9875	44.02	43.8375	43.8875	301404.0
2018-03-05 09:00:00	AAPL	Stock	43.8875	44.145	43.63	43.83	18155840.0
2018-03-05 10:00:00	AAPL	Stock	43.8275	44.1175	43.6925	44.1025	15339136.0
2018-03-05 11:00:00	AAPL	Stock	44.1	44.3575	44.0375	44.32	12314944.0
2018-03-05 12:00:00	AAPL	Stock	44.32	44.405	44.1825	44.345	9649800.0
2018-03-05 13:00:00	AAPL	Stock	44.3475	44.435	44.2098	44.3525	8879560.0
2018-03-05 14:00:00	AAPL	Stock	44.3542	44.3575	44.1175	44.3395	10553232.0
2018-03-05 15:00:00	AAPL	Stock	44.3375	44.4	44.1875	44.2075	15795800.0
2018-03-05 16:00:00	AAPL	Stock	44.205	44.2325	44.135	44.155	8968912.0
2018-03-05 17:00:00	AAPL	Stock	44.15	44.2	44.15	44.17	42408.0
2018-03-05 18:00:00	AAPL	Stock	44.17	44.195	44.16	44.16	17164.0
2018-03-05 19:00:00	AAPL	Stock	44.1875	44.2475	44.1875	44.2225	22744.0
2018-03-05 07:00:00	MSFT	Stock	93.0	93.05	92.73	92.9	1461.0
2018-03-05 08:00:00	MSFT	Stock	93.0	93.07	92.5	92.78	55813.0
2018-03-05 09:00:00	MSFT	Stock	92.77	93.2	92.26	92.955	3424617.0
2018-03-05 10:00:00	MSFT	Stock	92.96	93.11	92.31	92.92	2641880.0
2018-03-05 11:00:00	MSFT	Stock	92.92	93.63	92.86	93.577	2374654.0
2018-03-05 12:00:00	MSFT	Stock	93.575	93.83	93.41	93.81	1769251.0
2018-03-05 13:00:00	MSFT	Stock	93.82	94.09	93.55	93.71	1838319.0
2018-03-05 14:00:00	MSFT	Stock	93.71	94.05	93.404	94.005	2042743.0
2018-03-05 15:00:00	MSFT	Stock	94.0	94.27	93.62	93.64	4306393.0
2018-03-05 16:00:00	MSFT	Stock	93.64	93.72	93.49	93.59	3050418.0
2018-03-05 17:00:00	MSFT	Stock	93.55	93.59	93.5	93.55	3400.0
2018-03-05 18:00:00	MSFT	Stock	93.52	93.58	93.52	93.58	1360.0
2018-03-05 19:00:00	MSFT	Stock	93.52	93.64	93.52	93.64	2590.0
2018-03-05 04:00:00	NVDA	Stock	5.92	5.92	5.885	5.8938	178440.0
2018-03-05 05:00:00	NVDA	Stock	5.9108	5.9362	5.9108	5.9362	50560.0
2018-03-05 06:00:00	NVDA	Stock	5.9333	5.9333	5.9333	5.9333	5600.0
2018-03-05 07:00:00	NVDA	Stock	5.9125	5.9133	5.8765	5.8765	946360.0
2018-03-05 08:00:00	NVDA	Stock	5.875	5.9255	5.875	5.88	1336240.0
2018-03-05 09:00:00	NVDA	Stock	5.877	5.88	5.738	5.7868	117408840.0
2018-03-05 10:00:00	NVDA	Stock	5.7868	5.85	5.7415	5.8472	107988800.0
2018-03-05 11:00:00	NVDA	Stock	5.8472	5.9025	5.8358	5.8828	82228280.0
2018-03-05 12:00:00	NVDA	Stock	5.8822	5.9023	5.8455	5.8925	61644080.0
2018-03-05 13:00:00	NVDA	Stock	5.8928	5.9312	5.8838	5.9025	78791800.0
2018-03-05 14:00:00	NVDA	Stock	5.9035	5.9268	5.8778	5.9078	55903160.0
2018-03-05 15:00:00	NVDA	Stock	5.9072	5.926	5.8718	5.891	93170840.0
2018-03-05 16:00:00	NVDA	Stock	5.8912	5.8925	5.8875	5.8898	5043200.0
2018-03-05 17:00:00	NVDA	Stock	5.891	5.9	5.8875	5.9	446800.0
2018-03-05 18:00:00	NVDA	Stock	5.9	5.9125	5.9	5.9075	319280.0
2018-03-05 19:00:00	NVDA	Stock	5.9125	5.9198	5.9075	5.9125	684520.0
2018-03-05 04:00:00	AMZN	Stock	75.18	75.18	75.18	75.18	8060.0
2018-03-05 05:00:00	AMZN	Stock	75.258	75.325	75.249	75.325	21180.0
2018-03-05 06:00:00	AMZN	Stock	75.4	75.475	75.3	75.3	65520.0
2018-03-05 07:00:00	AMZN	Stock	75.225	75.2995	75.0375	75.0375	273660.0
2018-03-05 08:00:00	AMZN	Stock	75.3	75.3	74.92	74.95	1012280.0

> showing 50 of 49,750 rows — these rows as CSV

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