PREVIEW / etf_1hour / 2020-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-10.parquet
  size:    361 KB
  rows:    12,318

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-07-10 04:00:00	SPY	ETF	312.64	313.54	312.45	312.49	46082.0
2020-07-10 05:00:00	SPY	ETF	312.6	312.99	312.02	312.92	32429.0
2020-07-10 06:00:00	SPY	ETF	312.94	313.25	312.6	313.21	160827.0
2020-07-10 07:00:00	SPY	ETF	313.28	313.73	312.72	312.75	211478.0
2020-07-10 08:00:00	SPY	ETF	312.83	314.45	311.39	313.74	1281336.0
2020-07-10 09:00:00	SPY	ETF	313.76	315.09	313.47	314.01	7036098.0
2020-07-10 10:00:00	SPY	ETF	313.98	315.65	312.76	315.08	9575658.0
2020-07-10 11:00:00	SPY	ETF	315.07	315.93	314.495	315.85	5268738.0
2020-07-10 12:00:00	SPY	ETF	315.85	316.13	314.91	315.83	5094341.0
2020-07-10 13:00:00	SPY	ETF	315.83	316.67	315.63	316.51	4414711.0
2020-07-10 14:00:00	SPY	ETF	316.51	316.95	316.18	316.92	4910506.0
2020-07-10 15:00:00	SPY	ETF	316.92	317.88	316.51	317.61	14358765.0
2020-07-10 16:00:00	SPY	ETF	317.63	318.18	317.59	318.0	4149124.0
2020-07-10 17:00:00	SPY	ETF	318.0	318.03	317.59	317.83	148086.0
2020-07-10 18:00:00	SPY	ETF	317.83	317.97	317.76	317.92	47840.0
2020-07-10 19:00:00	SPY	ETF	317.92	318.15	317.92	318.1	48873.0
2020-07-10 04:00:00	QQQ	ETF	260.47	261.33	260.47	260.76	85518.0
2020-07-10 05:00:00	QQQ	ETF	260.84	261.27	260.6	261.23	26182.0
2020-07-10 06:00:00	QQQ	ETF	261.22	261.39	260.93	261.26	87540.0
2020-07-10 07:00:00	QQQ	ETF	261.27	261.67	260.83	260.9	144525.0
2020-07-10 08:00:00	QQQ	ETF	260.8701	262.04	259.99	261.63	436943.0
2020-07-10 09:00:00	QQQ	ETF	261.69	262.28	260.02	260.47	5429015.0
2020-07-10 10:00:00	QQQ	ETF	260.41	261.92	259.26	261.44	5928068.0
2020-07-10 11:00:00	QQQ	ETF	261.405	262.24	260.9	262.07	3193815.0
2020-07-10 12:00:00	QQQ	ETF	262.065	262.17	261.39	262.05	2630120.0
2020-07-10 13:00:00	QQQ	ETF	262.07	262.91	261.88	262.728	2323570.0
2020-07-10 14:00:00	QQQ	ETF	262.74	263.3299	262.32	263.3	2604296.0
2020-07-10 15:00:00	QQQ	ETF	263.3	264.23	262.95	264.01	4779102.0
2020-07-10 16:00:00	QQQ	ETF	264.02	264.63	263.93	264.53	726227.0
2020-07-10 17:00:00	QQQ	ETF	264.5	264.63	264.42	264.5	56073.0
2020-07-10 18:00:00	QQQ	ETF	264.5	264.6	264.42	264.4501	19514.0
2020-07-10 19:00:00	QQQ	ETF	264.46	264.74	264.46	264.5	28409.0
2020-07-10 04:00:00	IWM	ETF	138.02	138.43	137.91	137.98	13024.0
2020-07-10 05:00:00	IWM	ETF	137.72	138.22	137.72	138.2	27917.0
2020-07-10 06:00:00	IWM	ETF	138.35	138.43	138.06	138.43	22487.0
2020-07-10 07:00:00	IWM	ETF	138.5	138.87	138.24	138.24	44448.0
2020-07-10 08:00:00	IWM	ETF	138.86	139.12	137.02	138.65	239885.0
2020-07-10 09:00:00	IWM	ETF	138.78	140.415	138.455	139.82	3858047.0
2020-07-10 10:00:00	IWM	ETF	139.77	141.3	138.865	140.55	4653327.0
2020-07-10 11:00:00	IWM	ETF	140.53	141.05	140.02	140.92	2339657.0
2020-07-10 12:00:00	IWM	ETF	140.92	141.47	140.49	141.1703	2324626.0
2020-07-10 13:00:00	IWM	ETF	141.17	141.282	140.54	140.96	1192749.0
2020-07-10 14:00:00	IWM	ETF	140.97	141.09	140.48	140.72	1330422.0
2020-07-10 15:00:00	IWM	ETF	140.715	141.5	140.49	141.33	3899857.0
2020-07-10 16:00:00	IWM	ETF	141.31	141.9	141.31	141.65	840679.0
2020-07-10 17:00:00	IWM	ETF	141.71	141.71	141.46	141.62	16948.0
2020-07-10 18:00:00	IWM	ETF	141.6	141.6	141.46	141.5	3631.0
2020-07-10 19:00:00	IWM	ETF	141.46	141.6	141.43	141.5	3087.0
2020-07-10 04:00:00	DIA	ETF	255.64	256.46	255.47	255.48	8651.0
2020-07-10 05:00:00	DIA	ETF	255.18	255.79	255.15	255.79	7809.0

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

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