PREVIEW / etf_1hour / 2021-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-11.parquet
  size:    419 KB
  rows:    14,445

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-02-11 04:00:00	SPY	ETF	391.04	391.27	390.9	391.22	48187.0
2021-02-11 05:00:00	SPY	ETF	391.2	391.32	391.0	391.2	18804.0
2021-02-11 06:00:00	SPY	ETF	391.12	391.44	391.0	391.09	71832.0
2021-02-11 07:00:00	SPY	ETF	391.07	391.2	390.9	390.99	81226.0
2021-02-11 08:00:00	SPY	ETF	391.1	391.47	390.28	391.13	175921.0
2021-02-11 09:00:00	SPY	ETF	391.17	391.69	390.36	390.42	3955087.0
2021-02-11 10:00:00	SPY	ETF	390.44	391.37	390.3201	390.62	3847702.0
2021-02-11 11:00:00	SPY	ETF	390.62	390.94	390.15	390.51	2901401.0
2021-02-11 12:00:00	SPY	ETF	390.515	390.7099	388.1	389.335	6401876.0
2021-02-11 13:00:00	SPY	ETF	389.3313	389.99	388.7	389.51	2895577.0
2021-02-11 14:00:00	SPY	ETF	389.51	389.84	388.79	389.7887	3203158.0
2021-02-11 15:00:00	SPY	ETF	389.78	390.98	389.66	390.73	8190315.0
2021-02-11 16:00:00	SPY	ETF	390.72	390.76	390.2	390.27	2170295.0
2021-02-11 17:00:00	SPY	ETF	390.38	390.45	390.03	390.11	191444.0
2021-02-11 18:00:00	SPY	ETF	390.15	390.71	389.98	390.7	176243.0
2021-02-11 19:00:00	SPY	ETF	390.71	390.98	390.31	390.45	87884.0
2021-02-11 04:00:00	QQQ	ETF	333.74	334.16	333.68	334.1	28973.0
2021-02-11 05:00:00	QQQ	ETF	334.1	334.33	334.0	334.08	14833.0
2021-02-11 06:00:00	QQQ	ETF	334.05	334.42	334.03	334.05	18956.0
2021-02-11 07:00:00	QQQ	ETF	334.0	334.16	333.83	334.16	74997.0
2021-02-11 08:00:00	QQQ	ETF	334.2	334.49	333.12	334.22	154337.0
2021-02-11 09:00:00	QQQ	ETF	334.22	334.87	333.52	333.61	2433802.0
2021-02-11 10:00:00	QQQ	ETF	333.62	335.0	333.54	334.152	3049151.0
2021-02-11 11:00:00	QQQ	ETF	334.15	334.941	333.8	334.4728	1780396.0
2021-02-11 12:00:00	QQQ	ETF	334.4857	334.8	332.12	333.57	3618919.0
2021-02-11 13:00:00	QQQ	ETF	333.6	334.35	333.03	333.86	1435861.0
2021-02-11 14:00:00	QQQ	ETF	333.86	333.87	332.5	333.72	1797411.0
2021-02-11 15:00:00	QQQ	ETF	333.68	334.79	333.55	334.56	3250670.0
2021-02-11 16:00:00	QQQ	ETF	334.57	334.66	334.0833	334.1399	614872.0
2021-02-11 17:00:00	QQQ	ETF	334.13	334.45	334.11	334.16	29332.0
2021-02-11 18:00:00	QQQ	ETF	334.16	334.7	333.92	334.7	91444.0
2021-02-11 19:00:00	QQQ	ETF	334.66	334.9	334.3899	334.5	58781.0
2021-02-11 04:00:00	IWM	ETF	226.9	227.07	226.86	226.86	9029.0
2021-02-11 05:00:00	IWM	ETF	226.82	226.98	226.82	226.95	2209.0
2021-02-11 06:00:00	IWM	ETF	226.95	227.21	226.95	227.02	17486.0
2021-02-11 07:00:00	IWM	ETF	227.07	227.51	226.71	226.84	39461.0
2021-02-11 08:00:00	IWM	ETF	227.15	227.71	226.83	227.63	83411.0
2021-02-11 09:00:00	IWM	ETF	227.7	229.0	227.46	227.4978	3130419.0
2021-02-11 10:00:00	IWM	ETF	227.4	228.6925	227.35	228.13	1799074.0
2021-02-11 11:00:00	IWM	ETF	228.14	228.41	227.145	227.301	1622791.0
2021-02-11 12:00:00	IWM	ETF	227.31	227.34	223.42	225.17	6285151.0
2021-02-11 13:00:00	IWM	ETF	225.2	226.17	224.66	225.84	2492239.0
2021-02-11 14:00:00	IWM	ETF	225.84	226.36	224.91	226.27	2197577.0
2021-02-11 15:00:00	IWM	ETF	226.26	227.0	226.13	226.62	3615028.0
2021-02-11 16:00:00	IWM	ETF	226.62	226.74	225.99	226.07	1051555.0
2021-02-11 17:00:00	IWM	ETF	226.02	226.62	225.81	226.08	49752.0
2021-02-11 18:00:00	IWM	ETF	225.98	226.62	225.92	226.47	28515.0
2021-02-11 19:00:00	IWM	ETF	226.47	226.6	226.09	226.13	40271.0
2021-02-11 04:00:00	DIA	ETF	315.22	315.22	315.22	315.22	1000.0
2021-02-11 05:00:00	DIA	ETF	315.23	315.23	315.23	315.23	100.0

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

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