PREVIEW / etf_30min / 2021-12-02

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-02.parquet
  size:    662 KB
  rows:    25,974

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.13	85854.0
2021-12-02 04:30:00	SPY	ETF	454.08	454.08	453.41	454.0	68094.0
2021-12-02 05:00:00	SPY	ETF	453.96	454.04	452.38	453.07	36416.0
2021-12-02 05:30:00	SPY	ETF	453.01	453.92	452.97	453.58	31489.0
2021-12-02 06:00:00	SPY	ETF	453.51	453.65	453.05	453.22	32244.0
2021-12-02 06:30:00	SPY	ETF	453.25	453.56	452.91	453.37	47232.0
2021-12-02 07:00:00	SPY	ETF	453.4	453.69	451.24	451.61	209673.0
2021-12-02 07:30:00	SPY	ETF	451.56	452.16	450.66	452.05	356549.0
2021-12-02 08:00:00	SPY	ETF	451.98	454.0	450.69	452.08	392045.0
2021-12-02 08:30:00	SPY	ETF	452.0	452.5	450.96	451.4	531008.0
2021-12-02 09:00:00	SPY	ETF	451.38	451.83	450.24	450.68	798405.0
2021-12-02 09:30:00	SPY	ETF	450.72	455.9	450.31	455.88	11502894.0
2021-12-02 10:00:00	SPY	ETF	455.87	456.35	453.59	454.98	8975410.0
2021-12-02 10:30:00	SPY	ETF	454.98	455.52	451.95	454.92	8133466.0
2021-12-02 11:00:00	SPY	ETF	454.9	456.85	454.1898	456.3	5859783.0
2021-12-02 11:30:00	SPY	ETF	456.32	457.04	454.36	456.6901	5564757.0
2021-12-02 12:00:00	SPY	ETF	456.69	458.31	456.27	458.19	4093866.0
2021-12-02 12:30:00	SPY	ETF	458.195	458.37	457.07	457.63	4131730.0
2021-12-02 13:00:00	SPY	ETF	457.63	458.05	456.38	456.64	4572660.0
2021-12-02 13:30:00	SPY	ETF	456.65	458.36	456.14	458.2772	4401292.0
2021-12-02 14:00:00	SPY	ETF	458.28	458.72	457.51	458.61	3625051.0
2021-12-02 14:30:00	SPY	ETF	458.6	458.72	457.09	457.75	3423230.0
2021-12-02 15:00:00	SPY	ETF	457.78	458.57	456.98	457.51	4569202.0
2021-12-02 15:30:00	SPY	ETF	457.49	459.07	456.23	457.36	19526017.0
2021-12-02 16:00:00	SPY	ETF	457.37	457.98	456.92	457.52	8660219.0
2021-12-02 16:30:00	SPY	ETF	457.51	458.23	457.4	458.15	341406.0
2021-12-02 17:00:00	SPY	ETF	458.14	458.18	457.4	458.15	387281.0
2021-12-02 17:30:00	SPY	ETF	458.15	458.38	458.15	458.22	38126.0
2021-12-02 18:00:00	SPY	ETF	458.27	458.5	456.73	456.73	152899.0
2021-12-02 18:30:00	SPY	ETF	457.4	457.4	455.7599	455.88	121783.0
2021-12-02 19:00:00	SPY	ETF	455.87	456.45	455.36	456.44	106417.0
2021-12-02 19:30:00	SPY	ETF	456.45	456.64	456.01	456.23	59121.0
2021-12-02 04:00:00	QQQ	ETF	388.85	389.93	388.74	389.44	71209.0
2021-12-02 04:30:00	QQQ	ETF	389.45	389.45	388.37	388.86	70662.0
2021-12-02 05:00:00	QQQ	ETF	388.86	388.87	387.45	388.13	156635.0
2021-12-02 05:30:00	QQQ	ETF	387.93	388.76	387.85	388.52	25740.0
2021-12-02 06:00:00	QQQ	ETF	388.63	388.75	387.92	388.06	39833.0
2021-12-02 06:30:00	QQQ	ETF	388.11	388.36	387.67	388.02	37096.0
2021-12-02 07:00:00	QQQ	ETF	388.0	388.22	385.75	386.18	227092.0
2021-12-02 07:30:00	QQQ	ETF	386.15	386.79	385.33	386.71	243118.0
2021-12-02 08:00:00	QQQ	ETF	388.12	389.65	385.42	386.27	370199.0
2021-12-02 08:30:00	QQQ	ETF	386.16	386.56	385.07	386.05	451250.0
2021-12-02 09:00:00	QQQ	ETF	386.17	386.78	385.4	385.73	553475.0
2021-12-02 09:30:00	QQQ	ETF	385.8	390.2	385.0	389.88	9891972.0
2021-12-02 10:00:00	QQQ	ETF	389.93	390.76	386.15	387.93	7984175.0
2021-12-02 10:30:00	QQQ	ETF	387.89	388.28	384.34	387.5	7669830.0
2021-12-02 11:00:00	QQQ	ETF	387.49	389.77	386.58	389.115	5789499.0
2021-12-02 11:30:00	QQQ	ETF	389.15	389.42	387.01	389.12	4426152.0
2021-12-02 12:00:00	QQQ	ETF	389.1	391.62	388.72	391.35	3266234.0
2021-12-02 12:30:00	QQQ	ETF	391.34	391.48	389.79	390.05	2644632.0

> showing 50 of 25,974 rows — these rows as CSV

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