PREVIEW / etf_1hour / 2021-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-21.parquet
  size:    417 KB
  rows:    14,763

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-21 04:00:00	SPY	ETF	416.0	416.37	413.0	416.3	176047.0
2021-06-21 05:00:00	SPY	ETF	416.32	417.19	416.22	416.7	55092.0
2021-06-21 06:00:00	SPY	ETF	416.74	416.91	416.45	416.7	101660.0
2021-06-21 07:00:00	SPY	ETF	416.67	416.88	415.99	416.62	396782.0
2021-06-21 08:00:00	SPY	ETF	416.69	416.8504	412.94	416.8	535264.0
2021-06-21 09:00:00	SPY	ETF	416.78	418.03	415.93	417.8601	8405325.0
2021-06-21 10:00:00	SPY	ETF	417.88	420.26	417.81	420.03	10713110.0
2021-06-21 11:00:00	SPY	ETF	420.03	420.39	419.67	420.18	5896745.0
2021-06-21 12:00:00	SPY	ETF	420.19	420.34	419.83	419.89	3132739.0
2021-06-21 13:00:00	SPY	ETF	419.89	420.99	419.8019	420.75	4185874.0
2021-06-21 14:00:00	SPY	ETF	420.75	420.91	420.36	420.6404	4384819.0
2021-06-21 15:00:00	SPY	ETF	420.64	421.06	420.32	420.84	13642117.0
2021-06-21 16:00:00	SPY	ETF	420.84	421.4	420.6358	421.27	3779989.0
2021-06-21 17:00:00	SPY	ETF	421.25	421.35	421.2	421.29	96750.0
2021-06-21 18:00:00	SPY	ETF	421.29	421.35	421.15	421.16	53993.0
2021-06-21 19:00:00	SPY	ETF	421.24	421.61	421.13	421.21	96024.0
2021-06-21 04:00:00	QQQ	ETF	343.0	343.69	342.92	343.68	85166.0
2021-06-21 05:00:00	QQQ	ETF	343.57	344.24	343.57	343.97	24797.0
2021-06-21 06:00:00	QQQ	ETF	343.97	343.97	343.5	343.58	41901.0
2021-06-21 07:00:00	QQQ	ETF	343.62	343.78	342.69	343.06	147425.0
2021-06-21 08:00:00	QQQ	ETF	343.6396	343.9696	341.02	342.87	281062.0
2021-06-21 09:00:00	QQQ	ETF	342.8	342.93	340.15	342.58	5921613.0
2021-06-21 10:00:00	QQQ	ETF	342.6	343.99	341.51	343.56	5016009.0
2021-06-21 11:00:00	QQQ	ETF	343.58	344.41	343.45	343.97	3125014.0
2021-06-21 12:00:00	QQQ	ETF	343.98	344.2699	343.645	343.79	1631848.0
2021-06-21 13:00:00	QQQ	ETF	343.805	344.69	343.5601	344.43	1693113.0
2021-06-21 14:00:00	QQQ	ETF	344.45	344.5599	343.92	344.3	1680514.0
2021-06-21 15:00:00	QQQ	ETF	344.28	344.51	343.55	344.3	3789496.0
2021-06-21 16:00:00	QQQ	ETF	344.3	344.62	344.27	344.54	1490709.0
2021-06-21 17:00:00	QQQ	ETF	344.5	344.59	344.36	344.53	52000.0
2021-06-21 18:00:00	QQQ	ETF	344.57	344.65	344.36	344.36	32026.0
2021-06-21 19:00:00	QQQ	ETF	344.42	344.79	344.36	344.48	82705.0
2021-06-21 04:00:00	IWM	ETF	223.07	223.24	222.65	222.93	19053.0
2021-06-21 05:00:00	IWM	ETF	223.18	223.6	223.14	223.22	20097.0
2021-06-21 06:00:00	IWM	ETF	223.45	223.45	223.01	223.3	6906.0
2021-06-21 07:00:00	IWM	ETF	223.15	223.73	222.55	223.64	131569.0
2021-06-21 08:00:00	IWM	ETF	223.64	224.09	222.6	224.03	235230.0
2021-06-21 09:00:00	IWM	ETF	224.03	224.64	223.28	224.49	3298553.0
2021-06-21 10:00:00	IWM	ETF	224.5	226.68	224.37	226.057	4761446.0
2021-06-21 11:00:00	IWM	ETF	226.07	226.66	225.74	226.49	2334301.0
2021-06-21 12:00:00	IWM	ETF	226.485	227.13	226.19	226.8	1405161.0
2021-06-21 13:00:00	IWM	ETF	226.79	227.2	226.69	226.89	1817208.0
2021-06-21 14:00:00	IWM	ETF	226.9	227.27	226.74	227.23	1958943.0
2021-06-21 15:00:00	IWM	ETF	227.22	227.5	226.31	226.86	4351294.0
2021-06-21 16:00:00	IWM	ETF	226.88	227.29	226.78	227.13	1823660.0
2021-06-21 17:00:00	IWM	ETF	227.24	227.24	226.88	227.02	34482.0
2021-06-21 18:00:00	IWM	ETF	227.08	227.08	226.88	226.95	19940.0
2021-06-21 19:00:00	IWM	ETF	227.02	227.39	227.0	227.02	37755.0
2021-06-21 04:00:00	DIA	ETF	333.7	334.35	333.47	334.35	7843.0
2021-06-21 05:00:00	DIA	ETF	334.26	335.01	334.26	334.9	4026.0

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

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