PREVIEW / etf_1hour / 2021-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-02-22.parquet
  size:    437 KB
  rows:    15,180

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-22 04:00:00	SPY	ETF	386.38	387.15	386.3	387.14	70923.0
2021-02-22 05:00:00	SPY	ETF	387.23	387.61	387.1	387.1	39000.0
2021-02-22 06:00:00	SPY	ETF	387.17	387.4	386.7	387.08	75362.0
2021-02-22 07:00:00	SPY	ETF	387.06	387.4	386.38	386.89	453347.0
2021-02-22 08:00:00	SPY	ETF	386.93	389.43	386.08	387.42	637857.0
2021-02-22 09:00:00	SPY	ETF	387.45	388.27	386.59	388.03	6538491.0
2021-02-22 10:00:00	SPY	ETF	388.02	388.59	386.95	387.277	7743240.0
2021-02-22 11:00:00	SPY	ETF	387.24	388.25	386.9	388.0399	4746053.0
2021-02-22 12:00:00	SPY	ETF	388.04	388.88	387.57	388.78	3352293.0
2021-02-22 13:00:00	SPY	ETF	388.77	389.62	388.52	389.39	2808521.0
2021-02-22 14:00:00	SPY	ETF	389.38	389.48	388.74	388.91	3284107.0
2021-02-22 15:00:00	SPY	ETF	388.9	388.92	386.84	387.11	16243350.0
2021-02-22 16:00:00	SPY	ETF	387.1	387.55	386.9682	387.38	5732280.0
2021-02-22 17:00:00	SPY	ETF	387.39	387.39	387.03	387.35	183164.0
2021-02-22 18:00:00	SPY	ETF	387.36	388.0	387.03	387.48	184316.0
2021-02-22 19:00:00	SPY	ETF	387.62	387.62	386.55	386.71	171946.0
2021-02-22 04:00:00	QQQ	ETF	328.73	328.73	326.0	327.14	327546.0
2021-02-22 05:00:00	QQQ	ETF	327.29	327.51	326.9	326.92	106787.0
2021-02-22 06:00:00	QQQ	ETF	326.95	327.14	326.0	326.61	223017.0
2021-02-22 07:00:00	QQQ	ETF	326.61	327.0	325.89	326.53	315644.0
2021-02-22 08:00:00	QQQ	ETF	326.56	330.01	326.0	327.04	397317.0
2021-02-22 09:00:00	QQQ	ETF	326.99	327.63	325.7	327.36	4840047.0
2021-02-22 10:00:00	QQQ	ETF	327.35	327.8	323.98	324.28	5849853.0
2021-02-22 11:00:00	QQQ	ETF	324.24	325.56	323.82	324.81	3696518.0
2021-02-22 12:00:00	QQQ	ETF	324.81	325.28	323.8	325.19	2439413.0
2021-02-22 13:00:00	QQQ	ETF	325.2	326.325	324.77	325.915	2265467.0
2021-02-22 14:00:00	QQQ	ETF	325.91	326.045	324.795	325.0	1701494.0
2021-02-22 15:00:00	QQQ	ETF	325.0	325.02	322.23	322.44	7875355.0
2021-02-22 16:00:00	QQQ	ETF	322.47	322.83	322.14	322.3	2914576.0
2021-02-22 17:00:00	QQQ	ETF	322.32	322.44	322.15	322.4	89439.0
2021-02-22 18:00:00	QQQ	ETF	322.4	323.14	322.35	322.43	178351.0
2021-02-22 19:00:00	QQQ	ETF	322.56	322.56	321.7	321.91	134932.0
2021-02-22 04:00:00	IWM	ETF	222.72	223.05	222.38	222.65	39003.0
2021-02-22 05:00:00	IWM	ETF	222.83	223.28	222.8	223.07	17930.0
2021-02-22 06:00:00	IWM	ETF	223.49	223.56	223.0	223.0	25290.0
2021-02-22 07:00:00	IWM	ETF	223.27	223.71	222.82	223.26	138630.0
2021-02-22 08:00:00	IWM	ETF	223.33	225.69	222.83	223.9	181006.0
2021-02-22 09:00:00	IWM	ETF	223.93	225.25	222.98	225.25	2952920.0
2021-02-22 10:00:00	IWM	ETF	225.25	225.82	224.02	224.21	3521921.0
2021-02-22 11:00:00	IWM	ETF	224.18	225.96	223.64	225.92	1824953.0
2021-02-22 12:00:00	IWM	ETF	225.91	226.385	225.3	226.223	1757339.0
2021-02-22 13:00:00	IWM	ETF	226.195	226.27	225.5786	226.1001	1367071.0
2021-02-22 14:00:00	IWM	ETF	226.13	226.1856	225.255	225.47	1854249.0
2021-02-22 15:00:00	IWM	ETF	225.49	225.54	223.41	223.72	4465039.0
2021-02-22 16:00:00	IWM	ETF	223.72	224.2	223.66	224.15	1286381.0
2021-02-22 17:00:00	IWM	ETF	224.18	224.18	223.73	223.94	200030.0
2021-02-22 18:00:00	IWM	ETF	224.08	224.52	224.08	224.39	30827.0
2021-02-22 19:00:00	IWM	ETF	224.01	224.13	223.55	223.7	50697.0
2021-02-22 04:00:00	DIA	ETF	313.0	313.2	312.75	313.11	1078.0
2021-02-22 05:00:00	DIA	ETF	313.01	313.24	313.01	313.09	724.0

> showing 50 of 15,180 rows — these rows as CSV

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