PREVIEW / etf_1hour / 2019-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-08.parquet
  size:    343 KB
  rows:    11,177

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-08 04:00:00	SPY	ETF	288.7	288.82	287.88	288.63	21591.0
2019-08-08 05:00:00	SPY	ETF	288.62	289.04	288.4	288.74	22009.0
2019-08-08 06:00:00	SPY	ETF	288.87	289.1	288.4	288.45	19053.0
2019-08-08 07:00:00	SPY	ETF	288.41	288.59	288.1	288.4	277412.0
2019-08-08 08:00:00	SPY	ETF	288.41	289.14	288.1001	289.03	763394.0
2019-08-08 09:00:00	SPY	ETF	289.04	290.34	287.97	290.1284	10643535.0
2019-08-08 10:00:00	SPY	ETF	290.15	291.4563	290.07	291.31	11704027.0
2019-08-08 11:00:00	SPY	ETF	291.315	292.19	290.88	292.13	9118087.0
2019-08-08 12:00:00	SPY	ETF	292.12	292.86	292.0	292.84	9708141.0
2019-08-08 13:00:00	SPY	ETF	292.85	293.02	292.23	292.64	5927437.0
2019-08-08 14:00:00	SPY	ETF	292.64	292.85	292.135	292.65	7628071.0
2019-08-08 15:00:00	SPY	ETF	292.645	293.56	292.32	293.55	18544831.0
2019-08-08 16:00:00	SPY	ETF	293.56	293.75	288.8425	293.57	8817261.0
2019-08-08 17:00:00	SPY	ETF	293.58	293.62	292.05	292.7	1160106.0
2019-08-08 18:00:00	SPY	ETF	292.61	292.87	291.29	292.2	663806.0
2019-08-08 19:00:00	SPY	ETF	292.14	293.19	291.82	293.12	212076.0
2019-08-08 04:00:00	QQQ	ETF	184.77	184.86	184.11	184.74	99038.0
2019-08-08 05:00:00	QQQ	ETF	184.78	185.0	184.59	184.9	40723.0
2019-08-08 06:00:00	QQQ	ETF	184.99	185.19	184.64	184.7	32132.0
2019-08-08 07:00:00	QQQ	ETF	184.69	184.85	184.39	184.65	173814.0
2019-08-08 08:00:00	QQQ	ETF	184.7301	185.15	184.47	184.91	243475.0
2019-08-08 09:00:00	QQQ	ETF	184.92	185.725	184.57	185.568	4837567.0
2019-08-08 10:00:00	QQQ	ETF	185.57	186.77	185.48	186.69	5432651.0
2019-08-08 11:00:00	QQQ	ETF	186.685	187.23	186.36	187.155	3067003.0
2019-08-08 12:00:00	QQQ	ETF	187.16	187.58	186.96	187.5	2755545.0
2019-08-08 13:00:00	QQQ	ETF	187.51	187.69	187.15	187.5351	2168309.0
2019-08-08 14:00:00	QQQ	ETF	187.52	187.85	187.22	187.59	2176776.0
2019-08-08 15:00:00	QQQ	ETF	187.58	188.32	187.42	188.28	7385432.0
2019-08-08 16:00:00	QQQ	ETF	188.29	188.47	188.17	188.2	1754878.0
2019-08-08 17:00:00	QQQ	ETF	188.28	188.28	186.96	187.51	373741.0
2019-08-08 18:00:00	QQQ	ETF	187.53	187.66	186.48	187.16	455030.0
2019-08-08 19:00:00	QQQ	ETF	187.17	187.97	186.91	187.89	83755.0
2019-08-08 04:00:00	IWM	ETF	149.68	149.68	149.5	149.5	5300.0
2019-08-08 05:00:00	IWM	ETF	149.57	149.73	149.57	149.62	6400.0
2019-08-08 06:00:00	IWM	ETF	149.67	149.67	149.55	149.55	3500.0
2019-08-08 07:00:00	IWM	ETF	149.38	149.44	149.2	149.4	4600.0
2019-08-08 08:00:00	IWM	ETF	149.42	149.85	149.26	149.73	125082.0
2019-08-08 09:00:00	IWM	ETF	149.71	150.86	149.71	150.68	2686976.0
2019-08-08 10:00:00	IWM	ETF	150.7	151.76	150.61	151.71	2035890.0
2019-08-08 11:00:00	IWM	ETF	151.7165	152.14	151.55	152.035	2129689.0
2019-08-08 12:00:00	IWM	ETF	152.035	152.27	151.81	152.08	1595203.0
2019-08-08 13:00:00	IWM	ETF	152.08	152.33	151.93	152.24	1353868.0
2019-08-08 14:00:00	IWM	ETF	152.24	152.44	151.92	152.36	1360517.0
2019-08-08 15:00:00	IWM	ETF	152.35	152.63	152.22	152.55	3654455.0
2019-08-08 16:00:00	IWM	ETF	152.54	152.68	152.43	152.49	1166441.0
2019-08-08 17:00:00	IWM	ETF	152.49	152.54	151.44	152.54	55422.0
2019-08-08 18:00:00	IWM	ETF	152.04	152.09	151.26	151.65	25455.0
2019-08-08 19:00:00	IWM	ETF	151.8	152.29	151.6	152.24	12453.0
2019-08-08 06:00:00	DIA	ETF	260.55	260.55	260.14	260.14	8350.0
2019-08-08 07:00:00	DIA	ETF	260.14	260.24	259.92	260.24	3850.0

> showing 50 of 11,177 rows — these rows as CSV

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