PREVIEW / etf_1hour / 2019-08-28

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-28.parquet
  size:    332 KB
  rows:    10,786

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-08-28 04:00:00	SPY	ETF	287.02	287.67	286.5	287.02	15954.0
2019-08-28 05:00:00	SPY	ETF	287.12	287.4	286.9	286.9	6131.0
2019-08-28 06:00:00	SPY	ETF	287.12	287.47	286.62	286.88	31110.0
2019-08-28 07:00:00	SPY	ETF	286.88	286.95	285.86	286.09	249947.0
2019-08-28 08:00:00	SPY	ETF	286.25	287.52	285.46	286.3	399612.0
2019-08-28 09:00:00	SPY	ETF	286.28	287.21	285.25	287.14	10244302.0
2019-08-28 10:00:00	SPY	ETF	287.14	288.205	286.91	287.92	8527406.0
2019-08-28 11:00:00	SPY	ETF	287.92	288.81	287.55	288.5	8320174.0
2019-08-28 12:00:00	SPY	ETF	288.495	288.76	288.17	288.71	4433176.0
2019-08-28 13:00:00	SPY	ETF	288.71	288.74	288.0	288.48	4632776.0
2019-08-28 14:00:00	SPY	ETF	288.49	288.99	288.38	288.945	5392553.0
2019-08-28 15:00:00	SPY	ETF	288.94	289.07	288.27	288.83	11564068.0
2019-08-28 16:00:00	SPY	ETF	288.83	289.07	288.17	288.37	3824182.0
2019-08-28 17:00:00	SPY	ETF	288.41	288.89	288.3	288.55	387461.0
2019-08-28 18:00:00	SPY	ETF	288.52	289.02	288.36	288.76	859851.0
2019-08-28 19:00:00	SPY	ETF	288.7	288.7	288.33	288.51	90538.0
2019-08-28 04:00:00	QQQ	ETF	184.61	185.1	184.09	184.56	31388.0
2019-08-28 05:00:00	QQQ	ETF	184.5	184.82	184.35	184.5	28831.0
2019-08-28 06:00:00	QQQ	ETF	184.55	184.85	184.26	184.42	29920.0
2019-08-28 07:00:00	QQQ	ETF	184.49	184.5	183.73	183.9	183678.0
2019-08-28 08:00:00	QQQ	ETF	184.06	184.69	183.39	183.97	260829.0
2019-08-28 09:00:00	QQQ	ETF	183.94	184.36	182.91	184.0432	3671221.0
2019-08-28 10:00:00	QQQ	ETF	184.065	184.82	183.88	184.61	4254082.0
2019-08-28 11:00:00	QQQ	ETF	184.63	185.25	184.24	185.04	2635519.0
2019-08-28 12:00:00	QQQ	ETF	185.03	185.11	184.67	185.04	1236212.0
2019-08-28 13:00:00	QQQ	ETF	185.05	185.05	184.44	184.81	1285530.0
2019-08-28 14:00:00	QQQ	ETF	184.8	185.25	184.68	185.19	1170346.0
2019-08-28 15:00:00	QQQ	ETF	185.18	185.4	184.82	185.11	3243742.0
2019-08-28 16:00:00	QQQ	ETF	185.09	185.27	184.64	184.82	1314228.0
2019-08-28 17:00:00	QQQ	ETF	184.67	185.0	184.67	184.92	11026.0
2019-08-28 18:00:00	QQQ	ETF	184.91	185.03	184.72	184.98	27766.0
2019-08-28 19:00:00	QQQ	ETF	184.93	184.95	184.71	184.82	35812.0
2019-08-28 04:00:00	IWM	ETF	144.85	144.85	144.85	144.85	600.0
2019-08-28 05:00:00	IWM	ETF	144.98	145.06	144.98	145.05	2500.0
2019-08-28 06:00:00	IWM	ETF	145.2	145.22	144.85	144.98	7000.0
2019-08-28 07:00:00	IWM	ETF	144.95	144.95	144.38	144.54	37133.0
2019-08-28 08:00:00	IWM	ETF	144.5	144.71	144.21	144.64	61722.0
2019-08-28 09:00:00	IWM	ETF	144.61	145.53	144.25	145.48	3096508.0
2019-08-28 10:00:00	IWM	ETF	145.48	146.36	145.1	146.2633	3677686.0
2019-08-28 11:00:00	IWM	ETF	146.255	147.385	146.11	147.12	3113562.0
2019-08-28 12:00:00	IWM	ETF	147.11	147.18	146.8	147.1235	1389430.0
2019-08-28 13:00:00	IWM	ETF	147.12	147.1367	146.62	146.8	1059472.0
2019-08-28 14:00:00	IWM	ETF	146.8	147.06	146.73	146.97	995377.0
2019-08-28 15:00:00	IWM	ETF	146.98	146.98	146.44	146.53	3393785.0
2019-08-28 16:00:00	IWM	ETF	146.53	146.72	146.25	146.25	789340.0
2019-08-28 17:00:00	IWM	ETF	146.5	146.61	146.38	146.47	509767.0
2019-08-28 18:00:00	IWM	ETF	146.45	146.54	146.4	146.54	17500.0
2019-08-28 19:00:00	IWM	ETF	146.41	146.45	146.33	146.33	4800.0
2019-08-28 06:00:00	DIA	ETF	257.8	257.8	257.8	257.8	100.0
2019-08-28 07:00:00	DIA	ETF	257.74	257.74	256.91	257.04	6600.0

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

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