PREVIEW / etf_1hour / 2018-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-20.parquet
  size:    304 KB
  rows:    9,975

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-08-20 04:00:00	SPY	ETF	285.75	285.87	285.65	285.65	18648.0
2018-08-20 05:00:00	SPY	ETF	285.64	285.72	285.59	285.72	8700.0
2018-08-20 06:00:00	SPY	ETF	285.64	285.65	285.48	285.55	19150.0
2018-08-20 07:00:00	SPY	ETF	285.57	285.78	285.36	285.4	47336.0
2018-08-20 08:00:00	SPY	ETF	285.43	285.78	284.76	285.37	182126.0
2018-08-20 09:00:00	SPY	ETF	285.38	286.0	285.0	285.36	6098175.0
2018-08-20 10:00:00	SPY	ETF	285.355	285.7	285.06	285.17	5452297.0
2018-08-20 11:00:00	SPY	ETF	285.16	285.71	285.08	285.51	5044944.0
2018-08-20 12:00:00	SPY	ETF	285.53	285.82	285.4599	285.76	5498418.0
2018-08-20 13:00:00	SPY	ETF	285.77	285.86	285.62	285.84	2215802.0
2018-08-20 14:00:00	SPY	ETF	285.8467	285.92	285.65	285.765	3432164.0
2018-08-20 15:00:00	SPY	ETF	285.76	285.97	285.61	285.71	7836061.0
2018-08-20 16:00:00	SPY	ETF	285.7	285.85	285.5	285.62	2477022.0
2018-08-20 17:00:00	SPY	ETF	285.67	285.67	285.55	285.62	140468.0
2018-08-20 18:00:00	SPY	ETF	285.63	285.67	285.54	285.59	52549.0
2018-08-20 19:00:00	SPY	ETF	285.62	285.62	285.47	285.52	22214.0
2018-08-20 04:00:00	QQQ	ETF	180.5	180.73	180.5	180.5	14448.0
2018-08-20 05:00:00	QQQ	ETF	180.49	180.55	180.43	180.55	10090.0
2018-08-20 06:00:00	QQQ	ETF	180.44	180.49	180.35	180.41	12455.0
2018-08-20 07:00:00	QQQ	ETF	180.41	180.59	180.2	180.24	36553.0
2018-08-20 08:00:00	QQQ	ETF	180.24	180.6	180.12	180.16	107837.0
2018-08-20 09:00:00	QQQ	ETF	180.12	180.36	179.21	179.3046	3602229.0
2018-08-20 10:00:00	QQQ	ETF	179.3	179.66	179.0	179.14	4046519.0
2018-08-20 11:00:00	QQQ	ETF	179.14	179.6	179.02	179.325	2977896.0
2018-08-20 12:00:00	QQQ	ETF	179.34	179.77	179.24	179.715	1874883.0
2018-08-20 13:00:00	QQQ	ETF	179.715	179.99	179.57	179.99	1338635.0
2018-08-20 14:00:00	QQQ	ETF	179.985	180.105	179.71	179.81	1315915.0
2018-08-20 15:00:00	QQQ	ETF	179.815	179.94	179.655	179.7	3485378.0
2018-08-20 16:00:00	QQQ	ETF	179.7	179.95	179.68	179.71	349954.0
2018-08-20 17:00:00	QQQ	ETF	179.8	179.82	179.7	179.75	4054.0
2018-08-20 18:00:00	QQQ	ETF	179.71	179.75	179.65	179.7	12077.0
2018-08-20 19:00:00	QQQ	ETF	179.73	179.73	179.63	179.66	9368.0
2018-08-20 04:00:00	IWM	ETF	168.9	168.91	168.8	168.8	2950.0
2018-08-20 05:00:00	IWM	ETF	168.77	168.77	168.75	168.75	1400.0
2018-08-20 06:00:00	IWM	ETF	168.76	168.8	168.74	168.75	7641.0
2018-08-20 07:00:00	IWM	ETF	168.77	168.85	168.64	168.65	5853.0
2018-08-20 08:00:00	IWM	ETF	168.73	168.82	168.64	168.68	65516.0
2018-08-20 09:00:00	IWM	ETF	168.7	169.08	168.64	168.73	1639982.0
2018-08-20 10:00:00	IWM	ETF	168.75	169.07	167.83	168.07	1998312.0
2018-08-20 11:00:00	IWM	ETF	168.07	168.96	168.04	168.77	1308576.0
2018-08-20 12:00:00	IWM	ETF	168.78	168.95	168.74	168.85	729103.0
2018-08-20 13:00:00	IWM	ETF	168.86	169.15	168.735	169.12	787205.0
2018-08-20 14:00:00	IWM	ETF	169.125	169.18	168.91	168.98	951325.0
2018-08-20 15:00:00	IWM	ETF	168.97	169.06	168.77	168.79	2366016.0
2018-08-20 16:00:00	IWM	ETF	168.82	168.9	168.2983	168.75	455175.0
2018-08-20 17:00:00	IWM	ETF	168.75	168.82	168.75	168.82	4747.0
2018-08-20 18:00:00	IWM	ETF	168.75	168.79	168.75	168.75	13800.0
2018-08-20 19:00:00	IWM	ETF	168.76	168.77	168.72	168.72	8282.0
2018-08-20 04:00:00	DIA	ETF	257.4	257.4	257.4	257.4	200.0
2018-08-20 05:00:00	DIA	ETF	257.23	257.28	257.23	257.28	654.0

> showing 50 of 9,975 rows — these rows as CSV

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