PREVIEW / etf_1hour / 2020-02-21

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-21.parquet
  size:    364 KB
  rows:    12,016

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-02-21 04:00:00	SPY	ETF	335.41	335.52	334.89	334.96	28272.0
2020-02-21 05:00:00	SPY	ETF	335.05	335.69	335.05	335.54	25966.0
2020-02-21 06:00:00	SPY	ETF	335.45	335.7	335.17	335.4	52945.0
2020-02-21 07:00:00	SPY	ETF	335.47	335.98	335.36	335.82	138647.0
2020-02-21 08:00:00	SPY	ETF	335.5	335.95	334.32	335.3	365037.0
2020-02-21 09:00:00	SPY	ETF	335.28	335.82	333.43	334.1	16929027.0
2020-02-21 10:00:00	SPY	ETF	334.09	334.59	333.02	333.84	18971559.0
2020-02-21 11:00:00	SPY	ETF	333.84	334.73	333.7	334.41	8852821.0
2020-02-21 12:00:00	SPY	ETF	334.41	334.82	333.775	333.98	7111590.0
2020-02-21 13:00:00	SPY	ETF	333.97	334.28	332.59	333.08	11322281.0
2020-02-21 14:00:00	SPY	ETF	333.0667	333.54	332.75	333.33	10198987.0
2020-02-21 15:00:00	SPY	ETF	333.29	333.94	332.58	333.49	20204304.0
2020-02-21 16:00:00	SPY	ETF	333.5	333.83	333.43	333.59	17778828.0
2020-02-21 17:00:00	SPY	ETF	333.59	337.0594	333.43	333.48	492387.0
2020-02-21 18:00:00	SPY	ETF	333.48	333.59	333.39	333.49	74488.0
2020-02-21 19:00:00	SPY	ETF	333.49	333.5	333.32	333.32	46185.0
2020-02-21 04:00:00	QQQ	ETF	233.36	233.55	232.93	232.99	56327.0
2020-02-21 05:00:00	QQQ	ETF	233.16	233.59	233.16	233.56	21523.0
2020-02-21 06:00:00	QQQ	ETF	233.46	233.64	233.22	233.45	26086.0
2020-02-21 07:00:00	QQQ	ETF	233.48	234.03	233.39	233.9	158168.0
2020-02-21 08:00:00	QQQ	ETF	233.4401	234.0299	232.75	233.63	264418.0
2020-02-21 09:00:00	QQQ	ETF	233.61	234.08	231.01	231.79	8048743.0
2020-02-21 10:00:00	QQQ	ETF	231.78	232.23	230.82	231.63	7115935.0
2020-02-21 11:00:00	QQQ	ETF	231.665	232.17	231.341	231.86	3827251.0
2020-02-21 12:00:00	QQQ	ETF	231.88	232.34	230.93	231.13	3120293.0
2020-02-21 13:00:00	QQQ	ETF	231.13	231.42	229.3211	229.87	7288226.0
2020-02-21 14:00:00	QQQ	ETF	229.86	230.307	229.36	230.11	5718261.0
2020-02-21 15:00:00	QQQ	ETF	230.1	230.8	229.39	230.31	8705482.0
2020-02-21 16:00:00	QQQ	ETF	230.32	233.6273	230.25	230.38	3035909.0
2020-02-21 17:00:00	QQQ	ETF	230.44	230.52	230.17	230.23	3335815.0
2020-02-21 18:00:00	QQQ	ETF	230.22	230.35	230.1	230.26	28101.0
2020-02-21 19:00:00	QQQ	ETF	230.17	230.23	230.01	230.1	16895.0
2020-02-21 04:00:00	IWM	ETF	168.0	168.0	167.93	167.93	6438.0
2020-02-21 05:00:00	IWM	ETF	168.25	168.25	168.15	168.15	300.0
2020-02-21 06:00:00	IWM	ETF	168.02	168.19	168.02	168.06	19300.0
2020-02-21 07:00:00	IWM	ETF	168.1	168.34	168.09	168.27	68690.0
2020-02-21 08:00:00	IWM	ETF	168.24	168.24	167.84	167.84	50097.0
2020-02-21 09:00:00	IWM	ETF	167.84	168.44	166.94	167.12	2989408.0
2020-02-21 10:00:00	IWM	ETF	167.125	167.31	166.3295	166.98	2899161.0
2020-02-21 11:00:00	IWM	ETF	166.998	167.71	166.88	167.6	1376021.0
2020-02-21 12:00:00	IWM	ETF	167.61	167.87	167.42	167.535	973091.0
2020-02-21 13:00:00	IWM	ETF	167.54	167.69	166.82	167.02	1143122.0
2020-02-21 14:00:00	IWM	ETF	167.01	167.2	166.755	166.94	1393816.0
2020-02-21 15:00:00	IWM	ETF	166.94	167.28	166.66	167.06	3047903.0
2020-02-21 16:00:00	IWM	ETF	167.04	167.2048	167.04	167.1	1324610.0
2020-02-21 17:00:00	IWM	ETF	167.09	167.11	167.01	167.06	3478.0
2020-02-21 18:00:00	IWM	ETF	167.11	167.11	167.11	167.11	200.0
2020-02-21 04:00:00	DIA	ETF	290.3	290.55	290.15	290.55	900.0
2020-02-21 06:00:00	DIA	ETF	290.76	290.76	290.76	290.76	500.0
2020-02-21 07:00:00	DIA	ETF	290.74	291.0	290.69	290.99	6849.0

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

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