PREVIEW / etf_1hour / 2021-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-22.parquet
  size:    416 KB
  rows:    14,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
2021-10-22 04:00:00	SPY	ETF	453.19	453.58	452.89	453.44	36914.0
2021-10-22 05:00:00	SPY	ETF	453.48	453.48	453.26	453.4	7386.0
2021-10-22 06:00:00	SPY	ETF	453.31	454.14	453.28	453.99	29074.0
2021-10-22 07:00:00	SPY	ETF	454.0	454.31	453.93	454.21	57717.0
2021-10-22 08:00:00	SPY	ETF	453.6296	454.29	453.4	453.5	249275.0
2021-10-22 09:00:00	SPY	ETF	453.5	454.21	452.91	453.86	5095365.0
2021-10-22 10:00:00	SPY	ETF	453.84	454.67	453.35	453.495	4623469.0
2021-10-22 11:00:00	SPY	ETF	453.49	453.93	451.05	451.811	9356975.0
2021-10-22 12:00:00	SPY	ETF	451.81	453.35	451.35	452.69	5669533.0
2021-10-22 13:00:00	SPY	ETF	452.7	453.28	452.49	452.535	2843988.0
2021-10-22 14:00:00	SPY	ETF	452.53	454.08	452.53	453.13	4543541.0
2021-10-22 15:00:00	SPY	ETF	453.15	453.67	452.7	453.13	11133360.0
2021-10-22 16:00:00	SPY	ETF	453.13	453.6278	452.34	452.48	2821630.0
2021-10-22 17:00:00	SPY	ETF	452.48	453.12	452.47	452.71	126240.0
2021-10-22 18:00:00	SPY	ETF	452.71	453.12	452.4	452.4	54608.0
2021-10-22 19:00:00	SPY	ETF	452.48	452.55	452.3	452.3	25153.0
2021-10-22 04:00:00	QQQ	ETF	375.87	376.22	375.55	376.07	36303.0
2021-10-22 05:00:00	QQQ	ETF	376.05	376.15	375.9	376.14	17399.0
2021-10-22 06:00:00	QQQ	ETF	376.17	376.72	376.14	376.59	48691.0
2021-10-22 07:00:00	QQQ	ETF	376.57	376.87	376.45	376.69	157917.0
2021-10-22 08:00:00	QQQ	ETF	376.58	377.552	375.16	376.28	343913.0
2021-10-22 09:00:00	QQQ	ETF	376.28	376.85	375.09	376.04	3929297.0
2021-10-22 10:00:00	QQQ	ETF	376.03	376.97	375.33	375.56	3362251.0
2021-10-22 11:00:00	QQQ	ETF	375.565	375.79	372.385	373.4	7058218.0
2021-10-22 12:00:00	QQQ	ETF	373.385	374.91	372.95	374.0	3901222.0
2021-10-22 13:00:00	QQQ	ETF	374.0	374.34	373.28	373.3	2019101.0
2021-10-22 14:00:00	QQQ	ETF	373.34	375.04	373.3	374.13	2652590.0
2021-10-22 15:00:00	QQQ	ETF	374.15	374.4839	373.73	374.03	3974557.0
2021-10-22 16:00:00	QQQ	ETF	374.03	374.12	373.46	373.58	925862.0
2021-10-22 17:00:00	QQQ	ETF	373.6	373.78	373.6	373.76	30104.0
2021-10-22 18:00:00	QQQ	ETF	373.76	373.81	373.71	373.74	9724.0
2021-10-22 19:00:00	QQQ	ETF	373.74	373.78	373.35	373.52	31156.0
2021-10-22 04:00:00	IWM	ETF	228.16	228.59	228.16	228.59	17010.0
2021-10-22 05:00:00	IWM	ETF	228.62	228.62	228.28	228.31	9815.0
2021-10-22 06:00:00	IWM	ETF	228.23	228.67	228.21	228.63	39735.0
2021-10-22 07:00:00	IWM	ETF	228.61	229.07	228.6	228.85	77589.0
2021-10-22 08:00:00	IWM	ETF	228.85	228.98	227.88	227.9	59686.0
2021-10-22 09:00:00	IWM	ETF	228.02	228.12	227.11	227.8249	2036622.0
2021-10-22 10:00:00	IWM	ETF	227.8	228.39	227.5	227.59	1993183.0
2021-10-22 11:00:00	IWM	ETF	227.57	228.225	225.69	226.42	3046409.0
2021-10-22 12:00:00	IWM	ETF	226.43	227.37	226.13	227.07	1646879.0
2021-10-22 13:00:00	IWM	ETF	227.08	227.435	226.91	226.91	942176.0
2021-10-22 14:00:00	IWM	ETF	226.94	227.7461	226.83	227.33	999164.0
2021-10-22 15:00:00	IWM	ETF	227.34	227.555	226.835	227.44	2662436.0
2021-10-22 16:00:00	IWM	ETF	227.41	227.41	226.91	227.03	592780.0
2021-10-22 17:00:00	IWM	ETF	226.97	227.25	226.9	227.24	16053.0
2021-10-22 18:00:00	IWM	ETF	227.24	227.33	227.12	227.16	4234.0
2021-10-22 19:00:00	IWM	ETF	227.21	227.21	227.06	227.12	10167.0
2021-10-22 04:00:00	DIA	ETF	355.87	356.22	355.87	356.22	2340.0
2021-10-22 05:00:00	DIA	ETF	356.08	356.08	356.08	356.08	125.0

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

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