PREVIEW / etf_1hour / 2020-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-09.parquet
  size:    367 KB
  rows:    12,618

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-09 04:00:00	SPY	ETF	316.18	316.54	316.0	316.16	47029.0
2020-07-09 05:00:00	SPY	ETF	316.09	316.42	315.68	316.27	36183.0
2020-07-09 06:00:00	SPY	ETF	316.18	316.44	315.84	315.99	36326.0
2020-07-09 07:00:00	SPY	ETF	316.04	316.78	315.96	316.59	131888.0
2020-07-09 08:00:00	SPY	ETF	316.0541	317.2	316.0	317.0	562888.0
2020-07-09 09:00:00	SPY	ETF	316.93	317.1	315.35	316.1	6129792.0
2020-07-09 10:00:00	SPY	ETF	316.1	316.4	311.82	311.9413	13751091.0
2020-07-09 11:00:00	SPY	ETF	311.95	312.59	310.68	312.24	16138929.0
2020-07-09 12:00:00	SPY	ETF	312.24	313.62	312.07	313.51	10833801.0
2020-07-09 13:00:00	SPY	ETF	313.4984	314.41	313.22	313.39	5961334.0
2020-07-09 14:00:00	SPY	ETF	313.38	314.91	313.18	314.88	5472714.0
2020-07-09 15:00:00	SPY	ETF	314.87	315.54	313.29	314.42	16123420.0
2020-07-09 16:00:00	SPY	ETF	314.43	314.84	314.1	314.3	6941628.0
2020-07-09 17:00:00	SPY	ETF	314.27	314.38	314.16	314.31	83017.0
2020-07-09 18:00:00	SPY	ETF	314.33	314.7	314.33	314.53	114230.0
2020-07-09 19:00:00	SPY	ETF	314.51	315.49	314.5	315.16	153983.0
2020-07-09 04:00:00	QQQ	ETF	260.62	260.69	260.35	260.69	25609.0
2020-07-09 05:00:00	QQQ	ETF	260.6	261.34	260.48	261.22	45163.0
2020-07-09 06:00:00	QQQ	ETF	261.24	261.32	260.76	260.84	21053.0
2020-07-09 07:00:00	QQQ	ETF	260.83	261.56	260.83	261.39	146125.0
2020-07-09 08:00:00	QQQ	ETF	260.9525	261.99	259.86	261.76	295061.0
2020-07-09 09:00:00	QQQ	ETF	261.65	262.205	260.77	261.82	4186493.0
2020-07-09 10:00:00	QQQ	ETF	261.84	262.124	258.36	258.44	6353903.0
2020-07-09 11:00:00	QQQ	ETF	258.42	259.41	257.63	259.22	6752482.0
2020-07-09 12:00:00	QQQ	ETF	259.2	260.79	258.98	260.65	3662080.0
2020-07-09 13:00:00	QQQ	ETF	260.6699	261.52	260.36	260.59	3345153.0
2020-07-09 14:00:00	QQQ	ETF	260.59	262.21	260.38	262.19	3213949.0
2020-07-09 15:00:00	QQQ	ETF	262.17	262.87	260.8101	262.06	6873585.0
2020-07-09 16:00:00	QQQ	ETF	262.06	262.31	258.975	261.67	879155.0
2020-07-09 17:00:00	QQQ	ETF	261.71	261.78	261.54	261.65	42483.0
2020-07-09 18:00:00	QQQ	ETF	261.73	261.97	261.72	261.86	55672.0
2020-07-09 19:00:00	QQQ	ETF	261.87	262.42	261.82	262.34	136097.0
2020-07-09 04:00:00	IWM	ETF	141.45	141.61	141.34	141.34	2300.0
2020-07-09 05:00:00	IWM	ETF	141.42	141.55	141.26	141.5	14600.0
2020-07-09 06:00:00	IWM	ETF	141.46	141.49	141.18	141.18	1975.0
2020-07-09 07:00:00	IWM	ETF	141.27	141.84	141.27	141.5	89116.0
2020-07-09 08:00:00	IWM	ETF	141.8299	142.28	141.0	141.86	305541.0
2020-07-09 09:00:00	IWM	ETF	141.888	142.35	140.43	140.69	4559721.0
2020-07-09 10:00:00	IWM	ETF	140.69	141.33	137.78	137.84	5510470.0
2020-07-09 11:00:00	IWM	ETF	137.85	138.7	137.24	138.48	6855369.0
2020-07-09 12:00:00	IWM	ETF	138.49	139.38	138.46	139.2906	1658270.0
2020-07-09 13:00:00	IWM	ETF	139.29	140.0	138.95	139.05	1988852.0
2020-07-09 14:00:00	IWM	ETF	139.05	139.95	138.95	139.57	2132819.0
2020-07-09 15:00:00	IWM	ETF	139.58	139.89	138.53	139.07	5481308.0
2020-07-09 16:00:00	IWM	ETF	139.07	139.3	138.89	138.99	591076.0
2020-07-09 17:00:00	IWM	ETF	138.77	139.06	138.77	139.03	7269.0
2020-07-09 18:00:00	IWM	ETF	139.02	139.26	139.02	139.1	11900.0
2020-07-09 19:00:00	IWM	ETF	139.13	139.67	139.13	139.56	28808.0
2020-07-09 04:00:00	DIA	ETF	260.57	260.83	260.57	260.6	2189.0
2020-07-09 05:00:00	DIA	ETF	260.56	260.62	260.15	260.53	6150.0

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

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