PREVIEW / etf_1hour / 2021-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-02.parquet
  size:    449 KB
  rows:    16,124

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-12-02 04:00:00	SPY	ETF	453.1	454.61	453.1	454.0	153948.0
2021-12-02 05:00:00	SPY	ETF	453.96	454.04	452.38	453.58	67905.0
2021-12-02 06:00:00	SPY	ETF	453.51	453.65	452.91	453.37	79476.0
2021-12-02 07:00:00	SPY	ETF	453.4	453.69	450.66	452.05	566222.0
2021-12-02 08:00:00	SPY	ETF	451.98	454.0	450.69	451.4	923053.0
2021-12-02 09:00:00	SPY	ETF	451.38	455.9	450.24	455.88	12301299.0
2021-12-02 10:00:00	SPY	ETF	455.87	456.35	451.95	454.92	17108876.0
2021-12-02 11:00:00	SPY	ETF	454.9	457.04	454.1898	456.6901	11424540.0
2021-12-02 12:00:00	SPY	ETF	456.69	458.37	456.27	457.63	8225596.0
2021-12-02 13:00:00	SPY	ETF	457.63	458.36	456.14	458.2772	8973952.0
2021-12-02 14:00:00	SPY	ETF	458.28	458.72	457.09	457.75	7048281.0
2021-12-02 15:00:00	SPY	ETF	457.78	459.07	456.23	457.36	24095219.0
2021-12-02 16:00:00	SPY	ETF	457.37	458.23	456.92	458.15	9001625.0
2021-12-02 17:00:00	SPY	ETF	458.14	458.38	457.4	458.22	425407.0
2021-12-02 18:00:00	SPY	ETF	458.27	458.5	455.7599	455.88	274682.0
2021-12-02 19:00:00	SPY	ETF	455.87	456.64	455.36	456.23	165538.0
2021-12-02 04:00:00	QQQ	ETF	388.85	389.93	388.37	388.86	141871.0
2021-12-02 05:00:00	QQQ	ETF	388.86	388.87	387.45	388.52	182375.0
2021-12-02 06:00:00	QQQ	ETF	388.63	388.75	387.67	388.02	76929.0
2021-12-02 07:00:00	QQQ	ETF	388.0	388.22	385.33	386.71	470210.0
2021-12-02 08:00:00	QQQ	ETF	388.12	389.65	385.07	386.05	821449.0
2021-12-02 09:00:00	QQQ	ETF	386.17	390.2	385.0	389.88	10445447.0
2021-12-02 10:00:00	QQQ	ETF	389.93	390.76	384.34	387.5	15654005.0
2021-12-02 11:00:00	QQQ	ETF	387.49	389.77	386.58	389.12	10215651.0
2021-12-02 12:00:00	QQQ	ETF	389.1	391.62	388.72	390.05	5910866.0
2021-12-02 13:00:00	QQQ	ETF	390.07	390.54	388.22	390.32	6762783.0
2021-12-02 14:00:00	QQQ	ETF	390.26	390.82	389.02	390.02	5400725.0
2021-12-02 15:00:00	QQQ	ETF	390.06	391.74	388.8601	389.91	10336875.0
2021-12-02 16:00:00	QQQ	ETF	389.89	390.49	389.263	390.45	2052888.0
2021-12-02 17:00:00	QQQ	ETF	390.56	390.6	390.02	390.5	31069.0
2021-12-02 18:00:00	QQQ	ETF	390.54	390.77	388.47	388.56	176075.0
2021-12-02 19:00:00	QQQ	ETF	388.57	389.16	387.98	388.72	124811.0
2021-12-02 04:00:00	IWM	ETF	215.86	216.66	215.66	216.24	70505.0
2021-12-02 05:00:00	IWM	ETF	216.27	216.27	214.64	215.93	53351.0
2021-12-02 06:00:00	IWM	ETF	215.59	216.02	215.26	215.98	78549.0
2021-12-02 07:00:00	IWM	ETF	215.8	215.95	213.64	214.88	266107.0
2021-12-02 08:00:00	IWM	ETF	215.28	216.1804	213.75	214.77	492906.0
2021-12-02 09:00:00	IWM	ETF	214.52	217.82	213.47	217.82	9041947.0
2021-12-02 10:00:00	IWM	ETF	217.81	217.83	214.08	216.73	10154818.0
2021-12-02 11:00:00	IWM	ETF	216.71	218.16	216.05	217.88	6624133.0
2021-12-02 12:00:00	IWM	ETF	217.86	218.73	217.39	217.91	4712771.0
2021-12-02 13:00:00	IWM	ETF	217.92	219.09	216.91	218.96	4472922.0
2021-12-02 14:00:00	IWM	ETF	218.97	219.7	218.64	218.93	4991890.0
2021-12-02 15:00:00	IWM	ETF	218.94	219.94	218.67	219.26	7604945.0
2021-12-02 16:00:00	IWM	ETF	219.23	220.22	218.79	219.8	1927374.0
2021-12-02 17:00:00	IWM	ETF	219.57	219.95	219.57	219.76	34540.0
2021-12-02 18:00:00	IWM	ETF	219.77	220.0	217.54	217.78	212164.0
2021-12-02 19:00:00	IWM	ETF	217.72	218.44	217.35	218.09	136860.0
2021-12-02 04:00:00	DIA	ETF	342.61	344.04	342.61	343.54	7827.0
2021-12-02 05:00:00	DIA	ETF	342.62	343.76	342.62	343.71	7200.0

> showing 50 of 16,124 rows — these rows as CSV

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