PREVIEW / etf_1hour / 2019-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-10.parquet
  size:    338 KB
  rows:    11,020

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-10-10 04:00:00	SPY	ETF	290.49	291.49	290.44	290.94	35978.0
2019-10-10 05:00:00	SPY	ETF	291.14	291.23	290.8	291.15	21550.0
2019-10-10 06:00:00	SPY	ETF	291.15	291.73	290.89	290.99	67713.0
2019-10-10 07:00:00	SPY	ETF	290.96	291.05	290.36	290.62	362567.0
2019-10-10 08:00:00	SPY	ETF	290.76	291.24	290.22	291.03	357589.0
2019-10-10 09:00:00	SPY	ETF	291.01	293.28	290.83	293.17	9078336.0
2019-10-10 10:00:00	SPY	ETF	293.19	293.7922	292.565	293.7901	8595350.0
2019-10-10 11:00:00	SPY	ETF	293.8	294.21	293.63	293.99	5249939.0
2019-10-10 12:00:00	SPY	ETF	293.98	294.04	292.76	293.27	5110703.0
2019-10-10 13:00:00	SPY	ETF	293.27	293.66	292.61	293.4	5013793.0
2019-10-10 14:00:00	SPY	ETF	293.4	293.55	292.04	292.8352	7784965.0
2019-10-10 15:00:00	SPY	ETF	292.83	293.5	292.74	293.24	10948579.0
2019-10-10 16:00:00	SPY	ETF	293.25	294.75	293.1562	294.32	3518899.0
2019-10-10 17:00:00	SPY	ETF	294.3	294.59	294.16	294.18	173225.0
2019-10-10 18:00:00	SPY	ETF	294.3	295.1	293.83	294.28	361007.0
2019-10-10 19:00:00	SPY	ETF	294.23	294.31	293.7	294.13	121026.0
2019-10-10 04:00:00	QQQ	ETF	186.79	187.47	186.65	187.19	40437.0
2019-10-10 05:00:00	QQQ	ETF	187.26	187.35	187.01	187.25	13905.0
2019-10-10 06:00:00	QQQ	ETF	187.19	187.71	187.16	187.26	60007.0
2019-10-10 07:00:00	QQQ	ETF	187.2	187.22	186.59	186.93	357799.0
2019-10-10 08:00:00	QQQ	ETF	187.0	187.44	186.6	187.16	270663.0
2019-10-10 09:00:00	QQQ	ETF	187.16	188.85	187.01	188.72	5207726.0
2019-10-10 10:00:00	QQQ	ETF	188.73	189.17	188.38	189.15	3138304.0
2019-10-10 11:00:00	QQQ	ETF	189.16	189.43	189.02	189.19	1997075.0
2019-10-10 12:00:00	QQQ	ETF	189.19	189.22	188.13	188.53	1844405.0
2019-10-10 13:00:00	QQQ	ETF	188.52	188.7175	187.99	188.56	1412201.0
2019-10-10 14:00:00	QQQ	ETF	188.55	188.66	187.55	188.31	2475815.0
2019-10-10 15:00:00	QQQ	ETF	188.3	188.83	188.26	188.66	2854304.0
2019-10-10 16:00:00	QQQ	ETF	188.63	189.75	188.6082	189.5	1136166.0
2019-10-10 17:00:00	QQQ	ETF	189.53	189.67	188.81	189.25	361259.0
2019-10-10 18:00:00	QQQ	ETF	189.31	190.06	189.05	189.4	253251.0
2019-10-10 19:00:00	QQQ	ETF	189.35	189.47	189.09	189.39	75788.0
2019-10-10 04:00:00	IWM	ETF	146.9	147.0	146.87	147.0	5800.0
2019-10-10 05:00:00	IWM	ETF	147.31	147.31	147.13	147.28	3699.0
2019-10-10 06:00:00	IWM	ETF	147.35	147.46	147.3	147.3	6100.0
2019-10-10 07:00:00	IWM	ETF	147.16	147.21	146.98	147.07	9000.0
2019-10-10 08:00:00	IWM	ETF	147.18	147.3599	147.01	147.28	30350.0
2019-10-10 09:00:00	IWM	ETF	147.29	148.5	147.2	148.35	3179250.0
2019-10-10 10:00:00	IWM	ETF	148.36	148.43	147.59	148.43	1725917.0
2019-10-10 11:00:00	IWM	ETF	148.448	148.5	148.01	148.14	1039770.0
2019-10-10 12:00:00	IWM	ETF	148.12	148.12	147.53	147.79	912900.0
2019-10-10 13:00:00	IWM	ETF	147.8	147.88	147.27	147.74	1010648.0
2019-10-10 14:00:00	IWM	ETF	147.73	147.84	147.1	147.74	1227905.0
2019-10-10 15:00:00	IWM	ETF	147.72	148.04	147.52	147.73	3342768.0
2019-10-10 16:00:00	IWM	ETF	147.74	148.61	147.67	148.38	905455.0
2019-10-10 17:00:00	IWM	ETF	148.38	148.49	148.13	148.13	6395.0
2019-10-10 18:00:00	IWM	ETF	148.35	148.74	147.72	148.31	56367.0
2019-10-10 19:00:00	IWM	ETF	148.26	148.28	148.1	148.24	11320.0
2019-10-10 04:00:00	DIA	ETF	262.5	263.26	262.5	263.26	1150.0
2019-10-10 05:00:00	DIA	ETF	263.28	263.32	263.28	263.3	3517.0

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

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