PREVIEW / etf_1hour / 2021-06-30

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-30.parquet
  size:    414 KB
  rows:    14,595

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-30 04:00:00	SPY	ETF	428.06	428.06	426.87	426.87	15631.0
2021-06-30 05:00:00	SPY	ETF	426.8	426.99	426.37	426.94	27366.0
2021-06-30 06:00:00	SPY	ETF	426.97	427.33	426.97	427.12	25374.0
2021-06-30 07:00:00	SPY	ETF	427.12	427.8	427.11	427.56	176997.0
2021-06-30 08:00:00	SPY	ETF	427.28	428.35	426.89	427.26	132602.0
2021-06-30 09:00:00	SPY	ETF	427.25	427.959	426.98	427.555	4499616.0
2021-06-30 10:00:00	SPY	ETF	427.55	428.3175	427.52	428.21	4814007.0
2021-06-30 11:00:00	SPY	ETF	428.215	428.38	427.8	427.97	3801267.0
2021-06-30 12:00:00	SPY	ETF	427.97	428.18	427.72	428.02	4042750.0
2021-06-30 13:00:00	SPY	ETF	428.01	428.1	427.7819	427.89	2235975.0
2021-06-30 14:00:00	SPY	ETF	427.9	428.05	427.58	427.92	3906036.0
2021-06-30 15:00:00	SPY	ETF	427.93	428.78	427.875	428.07	13251315.0
2021-06-30 16:00:00	SPY	ETF	428.07	428.79	427.97	428.7	8337965.0
2021-06-30 17:00:00	SPY	ETF	428.72	428.77	428.06	428.74	93890.0
2021-06-30 18:00:00	SPY	ETF	428.74	428.91	428.06	428.91	68517.0
2021-06-30 19:00:00	SPY	ETF	428.89	428.89	428.7	428.85	36714.0
2021-06-30 04:00:00	QQQ	ETF	355.56	355.56	354.68	354.68	35265.0
2021-06-30 05:00:00	QQQ	ETF	354.65	354.65	354.14	354.39	35809.0
2021-06-30 06:00:00	QQQ	ETF	354.47	354.7	354.38	354.44	82315.0
2021-06-30 07:00:00	QQQ	ETF	354.52	355.21	354.49	354.91	96599.0
2021-06-30 08:00:00	QQQ	ETF	354.91	355.6	354.4204	354.79	187395.0
2021-06-30 09:00:00	QQQ	ETF	354.75	355.1594	353.87	354.232	3980550.0
2021-06-30 10:00:00	QQQ	ETF	354.25	355.13	354.08	355.06	3465796.0
2021-06-30 11:00:00	QQQ	ETF	355.07	355.23	354.31	354.73	2239878.0
2021-06-30 12:00:00	QQQ	ETF	354.75	354.84	353.83	354.345	3073771.0
2021-06-30 13:00:00	QQQ	ETF	354.32	354.735	354.3	354.56	2011110.0
2021-06-30 14:00:00	QQQ	ETF	354.56	354.63	354.08	354.43	1812172.0
2021-06-30 15:00:00	QQQ	ETF	354.45	355.08	354.26	354.43	5895343.0
2021-06-30 16:00:00	QQQ	ETF	354.41	354.83	354.4	354.75	1086919.0
2021-06-30 17:00:00	QQQ	ETF	354.76	354.76	354.43	354.62	164161.0
2021-06-30 18:00:00	QQQ	ETF	354.7	354.85	354.68	354.79	35005.0
2021-06-30 19:00:00	QQQ	ETF	354.78	354.83	354.66	354.82	39873.0
2021-06-30 04:00:00	IWM	ETF	229.19	229.2	227.8	227.99	37904.0
2021-06-30 05:00:00	IWM	ETF	227.68	228.15	227.42	228.15	28311.0
2021-06-30 06:00:00	IWM	ETF	228.28	228.55	228.26	228.48	12380.0
2021-06-30 07:00:00	IWM	ETF	228.41	228.79	228.24	228.64	50350.0
2021-06-30 08:00:00	IWM	ETF	228.58	229.71	228.39	228.55	77353.0
2021-06-30 09:00:00	IWM	ETF	228.54	229.15	227.76	228.735	2757755.0
2021-06-30 10:00:00	IWM	ETF	228.75	229.57	228.605	229.03	2206529.0
2021-06-30 11:00:00	IWM	ETF	229.02	229.9	228.67	229.68	1470978.0
2021-06-30 12:00:00	IWM	ETF	229.68	230.32	229.6585	229.8	1858506.0
2021-06-30 13:00:00	IWM	ETF	229.79	229.99	229.46	229.64	1353320.0
2021-06-30 14:00:00	IWM	ETF	229.64	230.2	229.4	230.07	1766149.0
2021-06-30 15:00:00	IWM	ETF	230.085	230.1	229.38	229.38	4167548.0
2021-06-30 16:00:00	IWM	ETF	229.37	229.92	229.35	229.81	3738780.0
2021-06-30 17:00:00	IWM	ETF	229.93	230.03	229.37	229.7	1602377.0
2021-06-30 18:00:00	IWM	ETF	229.83	230.27	229.83	230.24	372365.0
2021-06-30 19:00:00	IWM	ETF	230.179	230.27	230.1	230.27	43168.0
2021-06-30 04:00:00	DIA	ETF	342.25	342.25	342.08	342.08	1100.0
2021-06-30 05:00:00	DIA	ETF	341.48	342.04	341.48	342.04	1800.0

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

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