PREVIEW / etf_1hour / 2021-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-27.parquet
  size:    409 KB
  rows:    14,116

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-04-27 04:00:00	SPY	ETF	418.06	418.27	417.81	418.01	7095.0
2021-04-27 05:00:00	SPY	ETF	418.07	418.09	417.32	417.52	33961.0
2021-04-27 06:00:00	SPY	ETF	417.47	418.05	417.43	417.99	50422.0
2021-04-27 07:00:00	SPY	ETF	418.0	418.11	417.8	417.94	71167.0
2021-04-27 08:00:00	SPY	ETF	418.0599	418.49	417.42	417.78	164992.0
2021-04-27 09:00:00	SPY	ETF	417.79	418.0	416.78	416.845	5873821.0
2021-04-27 10:00:00	SPY	ETF	416.85	417.36	416.3	417.16	5756224.0
2021-04-27 11:00:00	SPY	ETF	417.17	417.66	416.9519	417.535	2991963.0
2021-04-27 12:00:00	SPY	ETF	417.535	417.735	416.98	417.09	3081979.0
2021-04-27 13:00:00	SPY	ETF	417.09	417.58	417.05	417.3933	2275066.0
2021-04-27 14:00:00	SPY	ETF	417.4	417.82	417.07	417.61	4132886.0
2021-04-27 15:00:00	SPY	ETF	417.61	418.14	417.26	417.4875	8040763.0
2021-04-27 16:00:00	SPY	ETF	417.49	417.96	417.28	417.65	2920020.0
2021-04-27 17:00:00	SPY	ETF	417.58	417.6	417.46	417.57	52243.0
2021-04-27 18:00:00	SPY	ETF	417.57	417.84	417.52	417.7	68476.0
2021-04-27 19:00:00	SPY	ETF	417.79	417.93	417.63	417.64	20930.0
2021-04-27 04:00:00	QQQ	ETF	341.9	342.12	341.69	342.12	31547.0
2021-04-27 05:00:00	QQQ	ETF	342.06	342.21	341.55	341.68	32269.0
2021-04-27 06:00:00	QQQ	ETF	341.6	342.08	341.6	342.01	16737.0
2021-04-27 07:00:00	QQQ	ETF	342.06	342.16	341.88	342.11	164944.0
2021-04-27 08:00:00	QQQ	ETF	342.11	342.4	341.71	342.05	207007.0
2021-04-27 09:00:00	QQQ	ETF	342.07	342.15	340.02	340.16	5536518.0
2021-04-27 10:00:00	QQQ	ETF	340.18	340.41	339.17	339.97	5491543.0
2021-04-27 11:00:00	QQQ	ETF	339.98	340.615	339.64	340.44	2183134.0
2021-04-27 12:00:00	QQQ	ETF	340.4399	340.9	340.22	340.34	1858407.0
2021-04-27 13:00:00	QQQ	ETF	340.35	340.59	340.17	340.28	1562549.0
2021-04-27 14:00:00	QQQ	ETF	340.27	340.55	339.82	340.29	2103984.0
2021-04-27 15:00:00	QQQ	ETF	340.28	340.7	339.83	340.07	5036713.0
2021-04-27 16:00:00	QQQ	ETF	340.07	340.93	339.63	340.11	1501841.0
2021-04-27 17:00:00	QQQ	ETF	340.15	340.2	340.0	340.0	53853.0
2021-04-27 18:00:00	QQQ	ETF	340.02	340.51	340.02	340.43	76652.0
2021-04-27 19:00:00	QQQ	ETF	340.46	340.59	340.34	340.38	46321.0
2021-04-27 04:00:00	IWM	ETF	228.61	228.72	228.37	228.61	1716.0
2021-04-27 05:00:00	IWM	ETF	228.62	228.62	227.89	228.12	13312.0
2021-04-27 06:00:00	IWM	ETF	228.05	228.6	228.05	228.6	18726.0
2021-04-27 07:00:00	IWM	ETF	228.61	228.67	228.44	228.45	33277.0
2021-04-27 08:00:00	IWM	ETF	228.57	228.77	228.41	228.68	145192.0
2021-04-27 09:00:00	IWM	ETF	228.7	228.99	227.51	228.51	2698383.0
2021-04-27 10:00:00	IWM	ETF	228.503	229.13	227.77	228.98	2281231.0
2021-04-27 11:00:00	IWM	ETF	228.98	229.39	228.59	229.16	1872502.0
2021-04-27 12:00:00	IWM	ETF	229.18	229.38	227.53	227.8	1442878.0
2021-04-27 13:00:00	IWM	ETF	227.81	228.39	227.6	228.36	1230359.0
2021-04-27 14:00:00	IWM	ETF	228.36	228.38	227.695	227.8099	1537261.0
2021-04-27 15:00:00	IWM	ETF	227.78	228.54	227.61	228.47	3282435.0
2021-04-27 16:00:00	IWM	ETF	228.45	228.75	228.09	228.27	767433.0
2021-04-27 17:00:00	IWM	ETF	228.35	228.37	228.23	228.3	5794.0
2021-04-27 18:00:00	IWM	ETF	228.38	228.42	228.11	228.25	17810.0
2021-04-27 19:00:00	IWM	ETF	228.28	228.41	228.13	228.15	20568.0
2021-04-27 04:00:00	DIA	ETF	340.17	340.17	340.1	340.1	400.0
2021-04-27 05:00:00	DIA	ETF	340.19	340.19	339.88	339.88	379.0

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

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