PREVIEW / etf_1hour / 2021-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-18.parquet
  size:    424 KB
  rows:    14,883

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
2021-06-18 04:00:00	SPY	ETF	420.6	422.1	420.43	420.55	37697.0
2021-06-18 05:00:00	SPY	ETF	420.55	420.83	420.5	420.62	21556.0
2021-06-18 06:00:00	SPY	ETF	420.57	420.57	420.05	420.3	39999.0
2021-06-18 07:00:00	SPY	ETF	420.19	420.31	419.17	419.62	226320.0
2021-06-18 08:00:00	SPY	ETF	419.29	422.276	416.94	418.51	1689492.0
2021-06-18 09:00:00	SPY	ETF	418.57	418.59	416.28	417.23	11509976.0
2021-06-18 10:00:00	SPY	ETF	417.22	417.455	415.85	416.195	11211662.0
2021-06-18 11:00:00	SPY	ETF	416.19	416.9	415.585	416.7699	8342433.0
2021-06-18 12:00:00	SPY	ETF	416.75	417.265	416.31	416.715	4514755.0
2021-06-18 13:00:00	SPY	ETF	416.71	417.24	416.065	416.635	4179473.0
2021-06-18 14:00:00	SPY	ETF	416.63	417.13	415.72	415.8699	4781243.0
2021-06-18 15:00:00	SPY	ETF	415.87	416.94	414.7	415.0	17518317.0
2021-06-18 16:00:00	SPY	ETF	415.01	415.0565	413.64	413.75	9456002.0
2021-06-18 17:00:00	SPY	ETF	413.73	414.92	413.6	413.94	3283604.0
2021-06-18 18:00:00	SPY	ETF	413.93	414.92	413.66	413.84	61375.0
2021-06-18 19:00:00	SPY	ETF	413.85	413.85	413.56	413.6	40771.0
2021-06-18 04:00:00	QQQ	ETF	345.34	346.5	345.34	346.02	46084.0
2021-06-18 05:00:00	QQQ	ETF	345.99	346.18	345.92	346.12	34521.0
2021-06-18 06:00:00	QQQ	ETF	346.11	346.11	345.76	345.98	59339.0
2021-06-18 07:00:00	QQQ	ETF	346.0	346.0	344.9	345.41	225784.0
2021-06-18 08:00:00	QQQ	ETF	346.0096	346.31	342.9	344.18	767577.0
2021-06-18 09:00:00	QQQ	ETF	344.16	344.8082	342.68	343.96	6555326.0
2021-06-18 10:00:00	QQQ	ETF	343.96	344.6399	343.15	343.448	5588926.0
2021-06-18 11:00:00	QQQ	ETF	343.44	343.84	341.86	342.88	4719951.0
2021-06-18 12:00:00	QQQ	ETF	342.88	343.8599	342.685	343.62	3208500.0
2021-06-18 13:00:00	QQQ	ETF	343.62	344.28	343.0318	343.495	2785524.0
2021-06-18 14:00:00	QQQ	ETF	343.47	344.02	342.41	342.555	2853771.0
2021-06-18 15:00:00	QQQ	ETF	342.55	343.845	342.18	342.61	6267699.0
2021-06-18 16:00:00	QQQ	ETF	342.61	342.75	341.96	341.99	1493179.0
2021-06-18 17:00:00	QQQ	ETF	341.98	345.3168	341.9	342.1	705302.0
2021-06-18 18:00:00	QQQ	ETF	342.2	342.63	341.91	341.93	13315.0
2021-06-18 19:00:00	QQQ	ETF	341.96	342.0	341.86	341.86	22646.0
2021-06-18 04:00:00	IWM	ETF	226.79	226.87	226.6	226.6	23095.0
2021-06-18 05:00:00	IWM	ETF	226.69	226.87	226.66	226.85	15772.0
2021-06-18 06:00:00	IWM	ETF	226.56	226.56	226.17	226.35	19100.0
2021-06-18 07:00:00	IWM	ETF	226.25	226.39	225.51	225.77	98811.0
2021-06-18 08:00:00	IWM	ETF	225.8999	226.3304	223.98	224.86	376139.0
2021-06-18 09:00:00	IWM	ETF	225.0	225.7375	223.5	224.5295	5601346.0
2021-06-18 10:00:00	IWM	ETF	224.52	224.89	222.93	223.74	5794954.0
2021-06-18 11:00:00	IWM	ETF	223.73	224.505	222.97	224.49	3135762.0
2021-06-18 12:00:00	IWM	ETF	224.48	224.53	223.04	223.115	3021733.0
2021-06-18 13:00:00	IWM	ETF	223.1	223.41	222.61	222.705	3309390.0
2021-06-18 14:00:00	IWM	ETF	222.6925	223.22	221.13	221.37	3858199.0
2021-06-18 15:00:00	IWM	ETF	221.38	222.45	221.14	221.92	10574836.0
2021-06-18 16:00:00	IWM	ETF	221.93	222.36	221.3	221.54	3276289.0
2021-06-18 17:00:00	IWM	ETF	221.2	222.13	221.2	222.13	1517341.0
2021-06-18 18:00:00	IWM	ETF	221.52	222.13	221.27	221.5	15410.0
2021-06-18 19:00:00	IWM	ETF	221.35	221.4499	221.19	221.23	7879.0
2021-06-18 04:00:00	DIA	ETF	337.89	338.09	337.89	338.06	3068.0
2021-06-18 05:00:00	DIA	ETF	337.97	338.35	337.97	338.17	2450.0

> showing 50 of 14,883 rows — these rows as CSV

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