PREVIEW / etf_1hour / 2018-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-20.parquet
  size:    313 KB
  rows:    10,300

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-09-20 04:00:00	SPY	ETF	291.48	291.55	291.33	291.37	11647.0
2018-09-20 05:00:00	SPY	ETF	291.47	291.73	291.44	291.65	9632.0
2018-09-20 06:00:00	SPY	ETF	291.53	291.73	291.51	291.67	7750.0
2018-09-20 07:00:00	SPY	ETF	291.66	292.13	291.63	292.13	154481.0
2018-09-20 08:00:00	SPY	ETF	292.13	292.63	291.3	292.55	555828.0
2018-09-20 09:00:00	SPY	ETF	292.55	293.01	292.42	292.71	8620821.0
2018-09-20 10:00:00	SPY	ETF	292.71	293.19	292.68	292.95	13703225.0
2018-09-20 11:00:00	SPY	ETF	292.955	293.47	292.94	293.47	10568690.0
2018-09-20 12:00:00	SPY	ETF	293.465	293.6	293.305	293.555	7409410.0
2018-09-20 13:00:00	SPY	ETF	293.54	293.72	293.355	293.47	10886889.0
2018-09-20 14:00:00	SPY	ETF	293.475	293.73	293.38	293.67	7609721.0
2018-09-20 15:00:00	SPY	ETF	293.675	293.94	293.46	293.55	27204757.0
2018-09-20 16:00:00	SPY	ETF	293.54	293.92	293.49	293.91	8956548.0
2018-09-20 17:00:00	SPY	ETF	293.88	293.95	293.5102	293.79	938949.0
2018-09-20 18:00:00	SPY	ETF	293.77	293.85	293.65	293.76	132030.0
2018-09-20 19:00:00	SPY	ETF	293.76	293.93	293.71	293.89	33969.0
2018-09-20 04:00:00	QQQ	ETF	182.76	182.89	182.7	182.7	7641.0
2018-09-20 05:00:00	QQQ	ETF	182.91	183.17	182.87	183.15	26378.0
2018-09-20 06:00:00	QQQ	ETF	183.14	183.17	183.01	183.09	18118.0
2018-09-20 07:00:00	QQQ	ETF	183.11	183.58	183.08	183.58	143597.0
2018-09-20 08:00:00	QQQ	ETF	183.57	184.07	182.79	183.99	325770.0
2018-09-20 09:00:00	QQQ	ETF	184.0	184.33	183.5199	184.22	5287428.0
2018-09-20 10:00:00	QQQ	ETF	184.22	184.88	184.21	184.34	5436633.0
2018-09-20 11:00:00	QQQ	ETF	184.34	184.91	184.2901	184.65	3641342.0
2018-09-20 12:00:00	QQQ	ETF	184.65	184.81	184.3591	184.7246	2135974.0
2018-09-20 13:00:00	QQQ	ETF	184.73	184.81	184.5	184.73	2056829.0
2018-09-20 14:00:00	QQQ	ETF	184.72	184.78	184.5	184.75	2168855.0
2018-09-20 15:00:00	QQQ	ETF	184.75	184.97	184.61	184.64	5708209.0
2018-09-20 16:00:00	QQQ	ETF	184.64	185.02	184.57	184.99	1434568.0
2018-09-20 17:00:00	QQQ	ETF	184.91	184.96	184.73	184.74	68815.0
2018-09-20 18:00:00	QQQ	ETF	184.74	184.8	184.61	184.74	47610.0
2018-09-20 19:00:00	QQQ	ETF	184.74	184.89	184.72	184.88	29598.0
2018-09-20 06:00:00	IWM	ETF	169.88	169.88	169.8	169.85	23531.0
2018-09-20 07:00:00	IWM	ETF	169.87	170.06	169.87	170.05	17000.0
2018-09-20 08:00:00	IWM	ETF	169.65	170.39	169.65	170.24	280597.0
2018-09-20 09:00:00	IWM	ETF	170.24	170.39	169.81	170.31	2495963.0
2018-09-20 10:00:00	IWM	ETF	170.3	170.65	169.96	170.44	2876441.0
2018-09-20 11:00:00	IWM	ETF	170.45	170.74	170.25	170.64	1562594.0
2018-09-20 12:00:00	IWM	ETF	170.65	171.01	170.56	170.98	1600507.0
2018-09-20 13:00:00	IWM	ETF	170.975	171.13	170.805	170.98	1204776.0
2018-09-20 14:00:00	IWM	ETF	170.98	171.3	170.92	171.14	1619825.0
2018-09-20 15:00:00	IWM	ETF	171.13	171.29	171.04	171.22	2806349.0
2018-09-20 16:00:00	IWM	ETF	171.22	171.65	171.0565	171.62	1046977.0
2018-09-20 17:00:00	IWM	ETF	171.51	171.52	171.5	171.5	4115.0
2018-09-20 18:00:00	IWM	ETF	171.48	171.52	171.45	171.49	9800.0
2018-09-20 19:00:00	IWM	ETF	171.49	171.53	171.49	171.52	3600.0
2018-09-20 05:00:00	DIA	ETF	264.85	264.85	264.85	264.85	200.0
2018-09-20 06:00:00	DIA	ETF	264.98	265.12	264.98	265.12	1290.0
2018-09-20 07:00:00	DIA	ETF	265.0	265.36	265.0	265.36	801.0
2018-09-20 08:00:00	DIA	ETF	265.0	265.97	265.0	265.97	5662.0

> showing 50 of 10,300 rows — these rows as CSV

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