PREVIEW / etf_1hour / 2020-09-16

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-16.parquet
  size:    370 KB
  rows:    12,544

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
2020-09-16 04:00:00	SPY	ETF	341.36	342.21	341.25	342.06	15379.0
2020-09-16 05:00:00	SPY	ETF	342.16	342.48	342.0	342.48	13858.0
2020-09-16 06:00:00	SPY	ETF	342.4	342.92	341.97	342.73	58868.0
2020-09-16 07:00:00	SPY	ETF	342.68	342.76	341.89	342.36	241500.0
2020-09-16 08:00:00	SPY	ETF	342.4999	342.81	341.05	342.07	431949.0
2020-09-16 09:00:00	SPY	ETF	342.06	342.1	340.7202	341.419	3967173.0
2020-09-16 10:00:00	SPY	ETF	341.41	341.785	340.31	341.056	6261467.0
2020-09-16 11:00:00	SPY	ETF	341.06	342.36	341.01	341.67	8888439.0
2020-09-16 12:00:00	SPY	ETF	341.68	341.95	341.01	341.195	8561809.0
2020-09-16 13:00:00	SPY	ETF	341.2	341.405	340.41	341.15	4393497.0
2020-09-16 14:00:00	SPY	ETF	341.14	343.06	340.85	341.5589	15786658.0
2020-09-16 15:00:00	SPY	ETF	341.555	341.9278	338.52	338.81	23884835.0
2020-09-16 16:00:00	SPY	ETF	338.8	339.47	338.55	339.24	8453601.0
2020-09-16 17:00:00	SPY	ETF	339.25	339.45	338.82	339.2	241203.0
2020-09-16 18:00:00	SPY	ETF	339.2	339.73	338.91	339.42	112130.0
2020-09-16 19:00:00	SPY	ETF	339.48	339.62	339.06	339.22	71531.0
2020-09-16 04:00:00	QQQ	ETF	280.54	281.59	280.43	281.43	44974.0
2020-09-16 05:00:00	QQQ	ETF	281.55	281.61	281.0	281.06	55178.0
2020-09-16 06:00:00	QQQ	ETF	281.06	281.72	280.76	281.54	44901.0
2020-09-16 07:00:00	QQQ	ETF	281.46	281.46	279.84	280.63	314761.0
2020-09-16 08:00:00	QQQ	ETF	280.6	281.7296	279.21	280.29	280226.0
2020-09-16 09:00:00	QQQ	ETF	280.2	280.36	278.38	279.59	3306527.0
2020-09-16 10:00:00	QQQ	ETF	279.57	279.79	276.9101	277.775	4891594.0
2020-09-16 11:00:00	QQQ	ETF	277.785	279.27	277.71	278.08	3399882.0
2020-09-16 12:00:00	QQQ	ETF	278.09	278.589	277.05	277.46	2710104.0
2020-09-16 13:00:00	QQQ	ETF	277.46	277.81	276.22	277.3721	2579452.0
2020-09-16 14:00:00	QQQ	ETF	277.35	279.1817	276.7708	277.19	5459636.0
2020-09-16 15:00:00	QQQ	ETF	277.19	277.68	274.25	274.435	10281267.0
2020-09-16 16:00:00	QQQ	ETF	274.45	280.0443	274.2	274.86	1560782.0
2020-09-16 17:00:00	QQQ	ETF	274.83	275.24	274.83	274.99	63135.0
2020-09-16 18:00:00	QQQ	ETF	275.03	275.72	274.7	275.42	70650.0
2020-09-16 19:00:00	QQQ	ETF	275.47	275.65	275.12	275.22	54829.0
2020-09-16 04:00:00	IWM	ETF	153.92	154.0	153.9	154.0	755.0
2020-09-16 05:00:00	IWM	ETF	154.2	154.2	154.2	154.2	250.0
2020-09-16 06:00:00	IWM	ETF	154.46	154.56	154.15	154.56	21707.0
2020-09-16 07:00:00	IWM	ETF	154.4	154.6	154.34	154.57	21380.0
2020-09-16 08:00:00	IWM	ETF	154.47	154.7	154.17	154.47	38276.0
2020-09-16 09:00:00	IWM	ETF	154.41	154.52	153.84	154.5	1168018.0
2020-09-16 10:00:00	IWM	ETF	154.5	155.27	154.32	154.65	2244256.0
2020-09-16 11:00:00	IWM	ETF	154.66	155.8	154.64	155.415	2106616.0
2020-09-16 12:00:00	IWM	ETF	155.43	156.01	155.365	155.86	1417310.0
2020-09-16 13:00:00	IWM	ETF	155.86	155.98	155.465	155.88	1707922.0
2020-09-16 14:00:00	IWM	ETF	155.88	156.85	155.73	155.99	3279349.0
2020-09-16 15:00:00	IWM	ETF	156.04	156.13	154.5	154.82	4545352.0
2020-09-16 16:00:00	IWM	ETF	154.82	155.5318	154.57	155.0	2886295.0
2020-09-16 17:00:00	IWM	ETF	155.07	155.08	155.0	155.05	6844.0
2020-09-16 18:00:00	IWM	ETF	155.05	155.29	154.9	155.18	27744.0
2020-09-16 19:00:00	IWM	ETF	155.08	155.19	154.94	154.94	15710.0
2020-09-16 07:00:00	DIA	ETF	282.31	282.31	281.76	282.12	3371.0
2020-09-16 08:00:00	DIA	ETF	282.26	282.38	280.85	282.0002	9017.0

> showing 50 of 12,544 rows — these rows as CSV

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