PREVIEW / etf_1hour / 2020-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-20.parquet
  size:    362 KB
  rows:    11,965

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-20 04:00:00	SPY	ETF	337.59	338.3	337.59	338.25	13633.0
2020-02-20 05:00:00	SPY	ETF	338.28	338.28	337.83	337.98	13570.0
2020-02-20 06:00:00	SPY	ETF	337.95	338.11	337.61	337.61	57789.0
2020-02-20 07:00:00	SPY	ETF	337.66	337.95	337.61	337.85	142577.0
2020-02-20 08:00:00	SPY	ETF	337.94	338.8	337.3	337.6299	353217.0
2020-02-20 09:00:00	SPY	ETF	337.61	338.42	337.55	338.25	4627744.0
2020-02-20 10:00:00	SPY	ETF	338.26	338.64	338.16	338.385	4211938.0
2020-02-20 11:00:00	SPY	ETF	338.39	338.4	333.6817	335.48	23521084.0
2020-02-20 12:00:00	SPY	ETF	335.465	335.77	334.58	335.73	10408908.0
2020-02-20 13:00:00	SPY	ETF	335.71	336.63	335.5	335.85	8089993.0
2020-02-20 14:00:00	SPY	ETF	335.855	337.13	335.85	336.7	7071468.0
2020-02-20 15:00:00	SPY	ETF	336.705	337.25	336.1	336.98	9549368.0
2020-02-20 16:00:00	SPY	ETF	336.98	337.16	336.5	336.51	4192578.0
2020-02-20 17:00:00	SPY	ETF	336.5	336.65	336.35	336.45	134383.0
2020-02-20 18:00:00	SPY	ETF	336.49	336.65	335.22	335.36	195091.0
2020-02-20 19:00:00	SPY	ETF	335.38	336.28	335.36	336.0	75290.0
2020-02-20 04:00:00	QQQ	ETF	236.78	237.03	236.71	237.01	34663.0
2020-02-20 05:00:00	QQQ	ETF	236.92	236.95	236.66	236.81	22933.0
2020-02-20 06:00:00	QQQ	ETF	236.81	236.86	236.46	236.46	19743.0
2020-02-20 07:00:00	QQQ	ETF	236.48	236.75	236.47	236.65	72232.0
2020-02-20 08:00:00	QQQ	ETF	236.61	237.25	236.13	236.36	354000.0
2020-02-20 09:00:00	QQQ	ETF	236.37	236.79	236.0	236.675	2351285.0
2020-02-20 10:00:00	QQQ	ETF	236.69	236.95	236.27	236.38	2760772.0
2020-02-20 11:00:00	QQQ	ETF	236.38	236.38	231.88	233.49	11811695.0
2020-02-20 12:00:00	QQQ	ETF	233.5	233.53	232.64	233.5	5844282.0
2020-02-20 13:00:00	QQQ	ETF	233.49	234.325	233.25	233.6	2984846.0
2020-02-20 14:00:00	QQQ	ETF	233.6	234.87	233.6	234.45	2566020.0
2020-02-20 15:00:00	QQQ	ETF	234.46	234.95	233.9	234.73	3570260.0
2020-02-20 16:00:00	QQQ	ETF	234.72	234.87	234.4	234.4	2183729.0
2020-02-20 17:00:00	QQQ	ETF	234.34	234.78	234.25	234.25	241722.0
2020-02-20 18:00:00	QQQ	ETF	234.3	234.45	233.1	233.3	195142.0
2020-02-20 19:00:00	QQQ	ETF	233.34	234.2	233.26	233.92	132583.0
2020-02-20 04:00:00	IWM	ETF	168.18	168.18	168.18	168.18	323.0
2020-02-20 05:00:00	IWM	ETF	168.19	168.2	168.05	168.15	11850.0
2020-02-20 06:00:00	IWM	ETF	168.16	168.16	167.96	167.96	6900.0
2020-02-20 07:00:00	IWM	ETF	168.1	168.1	167.99	167.99	6900.0
2020-02-20 08:00:00	IWM	ETF	168.13	168.55	167.81	167.84	31400.0
2020-02-20 09:00:00	IWM	ETF	167.91	168.89	167.84	168.77	1334317.0
2020-02-20 10:00:00	IWM	ETF	168.77	169.105	168.7	168.9502	1890489.0
2020-02-20 11:00:00	IWM	ETF	168.952	169.05	166.59	167.4	3440642.0
2020-02-20 12:00:00	IWM	ETF	167.39	168.02	166.98	167.98	1976583.0
2020-02-20 13:00:00	IWM	ETF	167.97	168.47	167.82	168.36	1373211.0
2020-02-20 14:00:00	IWM	ETF	168.37	169.01	167.7	168.72	1660251.0
2020-02-20 15:00:00	IWM	ETF	168.74	169.1	168.35	168.81	2567667.0
2020-02-20 16:00:00	IWM	ETF	168.82	168.89	168.3898	168.55	2203350.0
2020-02-20 17:00:00	IWM	ETF	168.5	168.63	168.4	168.6	6470.0
2020-02-20 18:00:00	IWM	ETF	168.5	168.81	167.94	167.94	20833.0
2020-02-20 19:00:00	IWM	ETF	168.12	168.5	168.12	168.39	13050.0
2020-02-20 05:00:00	DIA	ETF	293.76	293.76	293.76	293.76	500.0
2020-02-20 06:00:00	DIA	ETF	293.67	293.67	293.56	293.56	1100.0

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

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