PREVIEW / etf_1hour / 2021-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-01.parquet
  size:    417 KB
  rows:    14,542

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-07-01 04:00:00	SPY	ETF	429.65	429.95	429.28	429.28	4301.0
2021-07-01 05:00:00	SPY	ETF	429.32	429.33	428.61	428.71	76202.0
2021-07-01 06:00:00	SPY	ETF	428.84	428.84	428.15	428.24	248873.0
2021-07-01 07:00:00	SPY	ETF	428.32	429.0	428.18	429.0	121060.0
2021-07-01 08:00:00	SPY	ETF	428.21	429.24	428.19	428.7601	319108.0
2021-07-01 09:00:00	SPY	ETF	428.81	429.485	428.7	429.3325	4644808.0
2021-07-01 10:00:00	SPY	ETF	429.34	429.74	429.1	429.48	5378030.0
2021-07-01 11:00:00	SPY	ETF	429.48	429.71	428.86	429.54	4520213.0
2021-07-01 12:00:00	SPY	ETF	429.54	429.66	429.41	429.5	3194145.0
2021-07-01 13:00:00	SPY	ETF	429.49	430.2099	429.43	429.91	3391770.0
2021-07-01 14:00:00	SPY	ETF	429.92	430.41	429.8298	430.39	3601883.0
2021-07-01 15:00:00	SPY	ETF	430.38	430.6	430.04	430.47	13045248.0
2021-07-01 16:00:00	SPY	ETF	430.47	430.58	430.21	430.4	3766864.0
2021-07-01 17:00:00	SPY	ETF	430.4	430.5	430.35	430.36	71258.0
2021-07-01 18:00:00	SPY	ETF	430.4	430.5	430.26	430.48	43004.0
2021-07-01 19:00:00	SPY	ETF	430.5	430.59	430.38	430.38	35814.0
2021-07-01 04:00:00	QQQ	ETF	354.82	355.57	354.82	355.04	36024.0
2021-07-01 05:00:00	QQQ	ETF	355.03	355.03	354.16	354.46	53301.0
2021-07-01 06:00:00	QQQ	ETF	354.42	354.42	353.36	353.62	216007.0
2021-07-01 07:00:00	QQQ	ETF	353.63	354.57	353.58	354.47	188325.0
2021-07-01 08:00:00	QQQ	ETF	354.48	355.49	353.35	354.14	187360.0
2021-07-01 09:00:00	QQQ	ETF	354.15	355.09	353.45	354.47	4446409.0
2021-07-01 10:00:00	QQQ	ETF	354.47	354.74	353.6	354.22	4240016.0
2021-07-01 11:00:00	QQQ	ETF	354.225	354.37	352.68	353.8099	4672711.0
2021-07-01 12:00:00	QQQ	ETF	353.8	353.969	353.11	353.29	2352637.0
2021-07-01 13:00:00	QQQ	ETF	353.28	354.18	353.13	353.745	1896132.0
2021-07-01 14:00:00	QQQ	ETF	353.75	354.58	353.67	354.445	2078043.0
2021-07-01 15:00:00	QQQ	ETF	354.44	354.7	354.1	354.59	3522595.0
2021-07-01 16:00:00	QQQ	ETF	354.58	354.62	354.26	354.29	516965.0
2021-07-01 17:00:00	QQQ	ETF	354.35	354.47	354.31	354.44	10125.0
2021-07-01 18:00:00	QQQ	ETF	354.37	354.39	354.21	354.3	13253.0
2021-07-01 19:00:00	QQQ	ETF	354.34	354.37	354.2	354.21	17726.0
2021-07-01 04:00:00	IWM	ETF	230.77	231.1	230.68	230.68	27178.0
2021-07-01 05:00:00	IWM	ETF	230.69	230.69	230.23	230.5	25700.0
2021-07-01 06:00:00	IWM	ETF	230.4	230.48	230.02	230.02	48208.0
2021-07-01 07:00:00	IWM	ETF	230.12	230.79	230.05	230.79	156451.0
2021-07-01 08:00:00	IWM	ETF	230.07	231.04	230.07	230.62	94505.0
2021-07-01 09:00:00	IWM	ETF	230.7	231.17	229.74	230.0757	2510338.0
2021-07-01 10:00:00	IWM	ETF	230.075	231.4899	229.71	230.46	3283074.0
2021-07-01 11:00:00	IWM	ETF	230.45	231.2	229.98	230.84	2127877.0
2021-07-01 12:00:00	IWM	ETF	230.8417	231.3	230.6	231.0	988740.0
2021-07-01 13:00:00	IWM	ETF	230.99	231.46	230.84	231.0	1106104.0
2021-07-01 14:00:00	IWM	ETF	231.0	231.85	230.71	231.53	1650966.0
2021-07-01 15:00:00	IWM	ETF	231.54	231.74	230.965	231.41	2631943.0
2021-07-01 16:00:00	IWM	ETF	231.41	231.46	231.1	231.18	551561.0
2021-07-01 17:00:00	IWM	ETF	231.02	231.37	231.02	231.22	23987.0
2021-07-01 18:00:00	IWM	ETF	231.19	231.39	231.18	231.39	34165.0
2021-07-01 19:00:00	IWM	ETF	231.37	231.43	231.35	231.39	31787.0
2021-07-01 04:00:00	DIA	ETF	346.2	346.2	346.05	346.05	455.0
2021-07-01 05:00:00	DIA	ETF	346.1	346.1	345.62	345.62	4500.0

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

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