PREVIEW / etf_1hour / 2020-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-02.parquet
  size:    367 KB
  rows:    12,632

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-06-02 04:00:00	SPY	ETF	305.53	307.23	305.52	306.91	63498.0
2020-06-02 05:00:00	SPY	ETF	306.91	307.88	306.81	307.63	65103.0
2020-06-02 06:00:00	SPY	ETF	307.57	307.75	307.36	307.41	75257.0
2020-06-02 07:00:00	SPY	ETF	307.37	307.42	306.8	306.97	178593.0
2020-06-02 08:00:00	SPY	ETF	307.2501	307.4	304.02	306.7	579383.0
2020-06-02 09:00:00	SPY	ETF	306.74	306.78	305.52	306.27	7208216.0
2020-06-02 10:00:00	SPY	ETF	306.28	307.26	305.83	306.3867	9917625.0
2020-06-02 11:00:00	SPY	ETF	306.37	306.41	305.1	305.86	9978403.0
2020-06-02 12:00:00	SPY	ETF	305.84	306.55	305.76	306.405	4352067.0
2020-06-02 13:00:00	SPY	ETF	306.42	307.14	306.375	307.06	6577418.0
2020-06-02 14:00:00	SPY	ETF	307.06	307.19	306.15	306.79	7677988.0
2020-06-02 15:00:00	SPY	ETF	306.79	308.13	306.03	308.13	20805854.0
2020-06-02 16:00:00	SPY	ETF	308.11	308.24	307.72	308.1	4907876.0
2020-06-02 17:00:00	SPY	ETF	308.1202	308.21	308.05	308.14	145731.0
2020-06-02 18:00:00	SPY	ETF	308.16	308.32	307.79	307.93	309542.0
2020-06-02 19:00:00	SPY	ETF	307.95	309.07	307.92	308.89	320420.0
2020-06-02 04:00:00	QQQ	ETF	234.68	235.5	234.62	235.31	61087.0
2020-06-02 05:00:00	QQQ	ETF	235.31	235.9	235.3	235.85	26752.0
2020-06-02 06:00:00	QQQ	ETF	235.79	236.0	235.51	235.67	56631.0
2020-06-02 07:00:00	QQQ	ETF	235.6	235.63	234.94	234.94	128461.0
2020-06-02 08:00:00	QQQ	ETF	235.4999	235.605	233.63	234.6	269700.0
2020-06-02 09:00:00	QQQ	ETF	234.63	234.64	233.31	233.9321	3917085.0
2020-06-02 10:00:00	QQQ	ETF	233.94	234.59	232.76	233.21	4945706.0
2020-06-02 11:00:00	QQQ	ETF	233.22	233.24	232.01	232.79	5555057.0
2020-06-02 12:00:00	QQQ	ETF	232.77	233.73	232.75	233.6488	1997576.0
2020-06-02 13:00:00	QQQ	ETF	233.66	234.565	233.6112	234.4799	2172045.0
2020-06-02 14:00:00	QQQ	ETF	234.5	234.71	234.01	234.46	3104725.0
2020-06-02 15:00:00	QQQ	ETF	234.48	235.69	234.0	235.67	5411970.0
2020-06-02 16:00:00	QQQ	ETF	235.66	235.79	235.35	235.76	831432.0
2020-06-02 17:00:00	QQQ	ETF	235.76	235.79	235.5	235.65	28326.0
2020-06-02 18:00:00	QQQ	ETF	235.65	235.72	235.21	235.34	70931.0
2020-06-02 19:00:00	QQQ	ETF	235.32	236.2	235.32	236.14	209022.0
2020-06-02 04:00:00	IWM	ETF	140.13	141.52	139.99	141.2	27818.0
2020-06-02 05:00:00	IWM	ETF	141.24	141.6	140.95	141.47	31174.0
2020-06-02 06:00:00	IWM	ETF	141.42	141.6	141.33	141.48	8949.0
2020-06-02 07:00:00	IWM	ETF	141.43	141.47	141.06	141.22	84984.0
2020-06-02 08:00:00	IWM	ETF	141.2301	141.59	139.48	140.98	102433.0
2020-06-02 09:00:00	IWM	ETF	141.091	141.23	139.93	141.07	2604670.0
2020-06-02 10:00:00	IWM	ETF	141.075	141.855	140.16	140.69	4251382.0
2020-06-02 11:00:00	IWM	ETF	140.69	141.165	139.56	140.97	3147949.0
2020-06-02 12:00:00	IWM	ETF	140.96	141.68	140.88	141.51	2079151.0
2020-06-02 13:00:00	IWM	ETF	141.5	141.74	141.25	141.37	1469800.0
2020-06-02 14:00:00	IWM	ETF	141.37	141.6	140.78	141.505	2026023.0
2020-06-02 15:00:00	IWM	ETF	141.495	141.57	140.49	141.36	5142380.0
2020-06-02 16:00:00	IWM	ETF	141.37	141.45	141.19	141.44	888762.0
2020-06-02 17:00:00	IWM	ETF	141.19	141.5	141.01	141.31	49022.0
2020-06-02 18:00:00	IWM	ETF	141.31	141.45	141.14	141.21	118966.0
2020-06-02 19:00:00	IWM	ETF	141.31	142.0	141.31	141.94	192539.0
2020-06-02 04:00:00	DIA	ETF	255.47	256.74	255.47	256.74	2013.0
2020-06-02 05:00:00	DIA	ETF	256.61	257.22	256.45	257.22	3143.0

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

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