PREVIEW / etf_1hour / 2019-05-16

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-16.parquet
  size:    323 KB
  rows:    10,711

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-05-16 04:00:00	SPY	ETF	284.67	285.25	284.49	285.23	8603.0
2019-05-16 05:00:00	SPY	ETF	285.42	285.63	285.2	285.63	15255.0
2019-05-16 06:00:00	SPY	ETF	285.67	286.5	285.65	286.35	98993.0
2019-05-16 07:00:00	SPY	ETF	286.35	286.58	286.05	286.3	460037.0
2019-05-16 08:00:00	SPY	ETF	286.47	286.53	284.48	286.16	578400.0
2019-05-16 09:00:00	SPY	ETF	286.13	287.76	285.72	287.63	8061690.0
2019-05-16 10:00:00	SPY	ETF	287.63	288.58	287.57	288.5491	10961120.0
2019-05-16 11:00:00	SPY	ETF	288.545	289.04	288.19	288.81	7932715.0
2019-05-16 12:00:00	SPY	ETF	288.81	289.21	288.41	288.57	7074568.0
2019-05-16 13:00:00	SPY	ETF	288.58	288.78	287.98	288.13	5453947.0
2019-05-16 14:00:00	SPY	ETF	288.125	288.6998	287.88	288.31	5962187.0
2019-05-16 15:00:00	SPY	ETF	288.3	288.3	287.1	287.63	17892174.0
2019-05-16 16:00:00	SPY	ETF	287.63	287.84	287.55	287.77	9931339.0
2019-05-16 17:00:00	SPY	ETF	287.8	287.91	287.7	287.82	178950.0
2019-05-16 18:00:00	SPY	ETF	287.81	287.93	287.7	287.83	138853.0
2019-05-16 19:00:00	SPY	ETF	287.84	288.05	287.76	288.02	38499.0
2019-05-16 04:00:00	QQQ	ETF	182.75	183.2	182.5	183.09	29946.0
2019-05-16 05:00:00	QQQ	ETF	183.2	183.5	183.15	183.45	15920.0
2019-05-16 06:00:00	QQQ	ETF	183.52	184.18	183.5	184.01	105395.0
2019-05-16 07:00:00	QQQ	ETF	184.0	184.18	183.69	183.88	149151.0
2019-05-16 08:00:00	QQQ	ETF	184.1399	184.15	182.2	183.45	471403.0
2019-05-16 09:00:00	QQQ	ETF	183.43	184.71	182.95	184.6	5097573.0
2019-05-16 10:00:00	QQQ	ETF	184.61	185.7	184.46	185.63	6341039.0
2019-05-16 11:00:00	QQQ	ETF	185.63	186.0	185.29	185.86	3959848.0
2019-05-16 12:00:00	QQQ	ETF	185.87	186.07	185.38	185.5	3446577.0
2019-05-16 13:00:00	QQQ	ETF	185.51	185.63	184.9	185.05	3338078.0
2019-05-16 14:00:00	QQQ	ETF	185.06	185.59	184.87	185.35	3141752.0
2019-05-16 15:00:00	QQQ	ETF	185.33	185.33	184.51	184.92	6266246.0
2019-05-16 16:00:00	QQQ	ETF	184.91	185.3	184.87	185.18	1024074.0
2019-05-16 17:00:00	QQQ	ETF	185.26	185.27	184.93	185.04	334301.0
2019-05-16 18:00:00	QQQ	ETF	185.07	185.2	185.03	185.09	22555.0
2019-05-16 19:00:00	QQQ	ETF	185.11	185.29	185.11	185.26	75309.0
2019-05-16 05:00:00	IWM	ETF	154.21	154.32	154.21	154.3	16682.0
2019-05-16 06:00:00	IWM	ETF	154.37	154.7	154.37	154.7	18164.0
2019-05-16 07:00:00	IWM	ETF	154.7	154.78	154.57	154.57	27852.0
2019-05-16 08:00:00	IWM	ETF	154.73	154.82	154.52	154.63	25653.0
2019-05-16 09:00:00	IWM	ETF	154.56	155.75	154.41	155.7	1883542.0
2019-05-16 10:00:00	IWM	ETF	155.71	156.13	155.545	155.88	1964900.0
2019-05-16 11:00:00	IWM	ETF	155.88	156.175	155.52	156.01	1130989.0
2019-05-16 12:00:00	IWM	ETF	156.02	156.09	155.53	155.61	926492.0
2019-05-16 13:00:00	IWM	ETF	155.61	155.8	155.29	155.42	1012869.0
2019-05-16 14:00:00	IWM	ETF	155.42	155.62	155.131	155.3	1044174.0
2019-05-16 15:00:00	IWM	ETF	155.3	155.3	154.63	155.06	3500409.0
2019-05-16 16:00:00	IWM	ETF	155.06	155.16	154.99	155.05	643230.0
2019-05-16 17:00:00	IWM	ETF	155.11	155.16	155.11	155.16	1500.0
2019-05-16 18:00:00	IWM	ETF	155.16	155.16	155.16	155.16	440.0
2019-05-16 19:00:00	IWM	ETF	155.13	155.23	155.13	155.23	3800.0
2019-05-16 05:00:00	DIA	ETF	257.3	257.3	257.26	257.26	250.0
2019-05-16 06:00:00	DIA	ETF	257.72	257.76	257.72	257.76	700.0
2019-05-16 07:00:00	DIA	ETF	258.12	258.25	258.07	258.07	7390.0

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

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