PREVIEW / etf_1hour / 2021-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-17.parquet
  size:    413 KB
  rows:    14,363

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-09-17 04:00:00	SPY	ETF	447.02	447.02	445.7	445.78	14342.0
2021-09-17 05:00:00	SPY	ETF	445.78	445.78	444.55	444.77	32963.0
2021-09-17 06:00:00	SPY	ETF	444.64	444.95	444.2	444.62	29774.0
2021-09-17 07:00:00	SPY	ETF	444.64	444.86	444.41	444.7	179550.0
2021-09-17 08:00:00	SPY	ETF	444.8499	446.41	444.1896	445.45	362857.0
2021-09-17 09:00:00	SPY	ETF	445.41	445.77	443.09	443.505	8362341.0
2021-09-17 10:00:00	SPY	ETF	443.49	443.73	441.94	442.43	12258076.0
2021-09-17 11:00:00	SPY	ETF	442.425	443.09	441.63	442.25	11156078.0
2021-09-17 12:00:00	SPY	ETF	442.24	443.24	442.13	442.69	6783544.0
2021-09-17 13:00:00	SPY	ETF	442.7	442.74	441.02	441.54	7787428.0
2021-09-17 14:00:00	SPY	ETF	441.53	442.06	441.03	441.645	7698760.0
2021-09-17 15:00:00	SPY	ETF	441.635	442.22	441.11	441.42	19015931.0
2021-09-17 16:00:00	SPY	ETF	441.42	441.555	440.07	440.22	5355187.0
2021-09-17 17:00:00	SPY	ETF	440.2	441.4	440.19	440.37	1606488.0
2021-09-17 18:00:00	SPY	ETF	440.37	441.4	440.22	440.35	159584.0
2021-09-17 19:00:00	SPY	ETF	440.35	441.25	440.15	440.91	152647.0
2021-09-17 04:00:00	QQQ	ETF	378.02	378.33	378.02	378.23	38949.0
2021-09-17 05:00:00	QQQ	ETF	378.27	378.27	377.41	377.58	53648.0
2021-09-17 06:00:00	QQQ	ETF	377.47	377.82	377.21	377.5	65850.0
2021-09-17 07:00:00	QQQ	ETF	377.5	377.62	377.18	377.59	80595.0
2021-09-17 08:00:00	QQQ	ETF	377.4701	378.73	377.23	378.23	174383.0
2021-09-17 09:00:00	QQQ	ETF	378.23	378.35	375.38	375.85	6387681.0
2021-09-17 10:00:00	QQQ	ETF	375.81	375.919	374.18	374.52	6365421.0
2021-09-17 11:00:00	QQQ	ETF	374.52	374.86	373.1	373.6	5839427.0
2021-09-17 12:00:00	QQQ	ETF	373.59	374.88	373.59	374.47	3544940.0
2021-09-17 13:00:00	QQQ	ETF	374.44	374.49	372.76	373.23	3575590.0
2021-09-17 14:00:00	QQQ	ETF	373.22	373.7318	372.76	373.49	3220574.0
2021-09-17 15:00:00	QQQ	ETF	373.495	374.29	373.04	373.82	8854137.0
2021-09-17 16:00:00	QQQ	ETF	373.82	373.91	372.85	372.91	2162214.0
2021-09-17 17:00:00	QQQ	ETF	372.85	373.83	372.85	373.0	952059.0
2021-09-17 18:00:00	QQQ	ETF	373.0	373.83	372.95	373.2	439177.0
2021-09-17 19:00:00	QQQ	ETF	373.2	373.4	372.85	373.4	25509.0
2021-09-17 04:00:00	IWM	ETF	222.26	222.51	222.12	222.28	54009.0
2021-09-17 05:00:00	IWM	ETF	222.29	222.29	221.47	221.59	13503.0
2021-09-17 06:00:00	IWM	ETF	221.52	221.68	221.14	221.52	14044.0
2021-09-17 07:00:00	IWM	ETF	221.6	221.84	221.22	221.45	34812.0
2021-09-17 08:00:00	IWM	ETF	221.76	222.59	221.34	222.03	93986.0
2021-09-17 09:00:00	IWM	ETF	222.03	223.03	221.56	222.01	3653947.0
2021-09-17 10:00:00	IWM	ETF	221.94	222.25	221.14	221.72	3185741.0
2021-09-17 11:00:00	IWM	ETF	221.72	222.46	221.14	221.6525	2629817.0
2021-09-17 12:00:00	IWM	ETF	221.63	222.775	221.5	222.43	1812732.0
2021-09-17 13:00:00	IWM	ETF	222.44	222.56	220.64	220.93	1743816.0
2021-09-17 14:00:00	IWM	ETF	220.92	221.61	220.75	221.275	2288788.0
2021-09-17 15:00:00	IWM	ETF	221.275	222.63	221.05	222.21	8391363.0
2021-09-17 16:00:00	IWM	ETF	222.21	222.5601	221.7	221.75	6915517.0
2021-09-17 17:00:00	IWM	ETF	222.0	222.48	221.66	221.75	251944.0
2021-09-17 18:00:00	IWM	ETF	221.83	222.48	221.42	221.45	266298.0
2021-09-17 19:00:00	IWM	ETF	221.62	221.83	221.4	221.83	42470.0
2021-09-17 04:00:00	DIA	ETF	347.72	347.74	347.59	347.71	1103.0
2021-09-17 05:00:00	DIA	ETF	347.15	347.3	346.79	346.83	6300.0

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

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