PREVIEW / etf_1hour / 2020-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-30.parquet
  size:    362 KB
  rows:    12,532

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-30 04:00:00	SPY	ETF	304.0	304.2	303.37	303.46	90148.0
2020-06-30 05:00:00	SPY	ETF	303.48	304.37	303.2	304.3	143312.0
2020-06-30 06:00:00	SPY	ETF	304.29	304.7	304.19	304.4	56964.0
2020-06-30 07:00:00	SPY	ETF	304.34	305.54	304.2	304.71	378263.0
2020-06-30 08:00:00	SPY	ETF	305.4399	305.4501	303.4	304.05	357883.0
2020-06-30 09:00:00	SPY	ETF	304.02	305.375	303.65	304.79	7643584.0
2020-06-30 10:00:00	SPY	ETF	304.8	306.68	304.73	306.56	11342363.0
2020-06-30 11:00:00	SPY	ETF	306.57	307.33	306.27	306.79	7863002.0
2020-06-30 12:00:00	SPY	ETF	306.79	307.53	306.2	306.31	7641278.0
2020-06-30 13:00:00	SPY	ETF	306.31	306.63	305.69	306.52	5023477.0
2020-06-30 14:00:00	SPY	ETF	306.51	307.43	306.033	307.415	8757435.0
2020-06-30 15:00:00	SPY	ETF	307.42	310.2	306.67	308.57	36916864.0
2020-06-30 16:00:00	SPY	ETF	308.56	309.09	308.18	308.5901	21410507.0
2020-06-30 17:00:00	SPY	ETF	308.63	308.63	308.25	308.6	1981755.0
2020-06-30 18:00:00	SPY	ETF	308.6	308.89	308.34	308.35	185571.0
2020-06-30 19:00:00	SPY	ETF	308.38	308.76	308.1	308.28	380770.0
2020-06-30 04:00:00	QQQ	ETF	243.35	243.47	242.87	243.1	37234.0
2020-06-30 05:00:00	QQQ	ETF	242.95	243.4	242.85	243.4	25797.0
2020-06-30 06:00:00	QQQ	ETF	243.48	243.5	243.09	243.12	40777.0
2020-06-30 07:00:00	QQQ	ETF	243.1	243.65	242.97	243.27	142625.0
2020-06-30 08:00:00	QQQ	ETF	243.2901	244.35	242.5	242.78	131991.0
2020-06-30 09:00:00	QQQ	ETF	242.8	244.82	242.53	244.55	4134957.0
2020-06-30 10:00:00	QQQ	ETF	244.54	245.56	244.43	245.47	4083037.0
2020-06-30 11:00:00	QQQ	ETF	245.47	246.09	245.37	245.8301	2962968.0
2020-06-30 12:00:00	QQQ	ETF	245.83	246.47	245.32	245.53	2934952.0
2020-06-30 13:00:00	QQQ	ETF	245.54	245.81	244.905	245.63	2392478.0
2020-06-30 14:00:00	QQQ	ETF	245.65	246.45	245.22	246.425	3606522.0
2020-06-30 15:00:00	QQQ	ETF	246.43	248.16	245.79	247.28	9332235.0
2020-06-30 16:00:00	QQQ	ETF	247.24	247.68	247.04	247.36	1425094.0
2020-06-30 17:00:00	QQQ	ETF	247.31	247.6	247.2	247.3	253055.0
2020-06-30 18:00:00	QQQ	ETF	247.32	247.6	247.2	247.25	62473.0
2020-06-30 19:00:00	QQQ	ETF	247.3	247.6	247.05	247.17	56029.0
2020-06-30 04:00:00	IWM	ETF	140.67	140.78	140.31	140.34	6641.0
2020-06-30 05:00:00	IWM	ETF	140.4	140.89	140.34	140.89	16344.0
2020-06-30 06:00:00	IWM	ETF	140.85	141.25	140.79	140.99	14499.0
2020-06-30 07:00:00	IWM	ETF	140.98	142.34	140.88	141.71	149691.0
2020-06-30 08:00:00	IWM	ETF	141.01	142.19	140.45	140.85	235685.0
2020-06-30 09:00:00	IWM	ETF	141.0	141.74	140.59	141.17	2975150.0
2020-06-30 10:00:00	IWM	ETF	141.15	142.39	140.86	142.36	3552140.0
2020-06-30 11:00:00	IWM	ETF	142.365	143.255	142.335	142.81	4446942.0
2020-06-30 12:00:00	IWM	ETF	142.81	143.51	142.26	142.32	3329272.0
2020-06-30 13:00:00	IWM	ETF	142.31	142.62	141.92	142.615	1528255.0
2020-06-30 14:00:00	IWM	ETF	142.61	142.98	142.34	142.9	1848928.0
2020-06-30 15:00:00	IWM	ETF	142.91	143.62	142.5	143.11	5919451.0
2020-06-30 16:00:00	IWM	ETF	143.15	143.36	142.82	143.08	1549367.0
2020-06-30 17:00:00	IWM	ETF	143.23	143.23	142.9	142.97	338730.0
2020-06-30 18:00:00	IWM	ETF	143.14	143.26	142.86	142.86	126670.0
2020-06-30 19:00:00	IWM	ETF	142.85	143.18	142.61	142.74	86328.0
2020-06-30 04:00:00	DIA	ETF	255.47	255.47	254.45	254.73	3448.0
2020-06-30 05:00:00	DIA	ETF	254.69	255.31	254.63	255.18	5070.0

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

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