PREVIEW / etf_30min / 2023-11-20

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-11-20.parquet
  size:    771 KB
  rows:    30,415

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
2023-11-20 04:00:00	SPY	ETF	450.62	451.14	450.61	451.1	45094.0
2023-11-20 04:30:00	SPY	ETF	451.05	451.39	450.99	451.39	16024.0
2023-11-20 05:00:00	SPY	ETF	451.41	451.42	451.2	451.2	2093.0
2023-11-20 05:30:00	SPY	ETF	451.11	451.16	450.87	451.01	5614.0
2023-11-20 06:00:00	SPY	ETF	450.96	451.08	450.9	451.03	10125.0
2023-11-20 06:30:00	SPY	ETF	450.88	451.31	450.88	451.27	3958.0
2023-11-20 07:00:00	SPY	ETF	451.09	451.19	450.9	450.9	32961.0
2023-11-20 07:30:00	SPY	ETF	450.84	450.96	450.47	450.54	25117.0
2023-11-20 08:00:00	SPY	ETF	451.14	451.2196	450.12	450.55	115169.0
2023-11-20 08:30:00	SPY	ETF	450.49	451.15	450.44	451.09	96380.0
2023-11-20 09:00:00	SPY	ETF	451.06	451.27	450.52	450.57	135828.0
2023-11-20 09:30:00	SPY	ETF	450.52	452.17	450.52	452.17	4789256.0
2023-11-20 10:00:00	SPY	ETF	452.165	452.33	451.45	451.95	3644933.0
2023-11-20 10:30:00	SPY	ETF	451.95	452.6152	451.752	452.615	2909982.0
2023-11-20 11:00:00	SPY	ETF	452.62	452.8	452.52	452.67	2998898.0
2023-11-20 11:30:00	SPY	ETF	452.67	452.895	452.58	452.755	1882420.0
2023-11-20 12:00:00	SPY	ETF	452.76	453.08	452.6	452.87	1663016.0
2023-11-20 12:30:00	SPY	ETF	452.88	452.91	452.48	452.65	1797063.0
2023-11-20 13:00:00	SPY	ETF	452.65	453.81	452.62	453.71	3837669.0
2023-11-20 13:30:00	SPY	ETF	453.72	454.1	453.685	453.9972	2601678.0
2023-11-20 14:00:00	SPY	ETF	454.0	454.11	453.78	454.0	2467890.0
2023-11-20 14:30:00	SPY	ETF	454.01	454.71	454.005	454.56	3387015.0
2023-11-20 15:00:00	SPY	ETF	454.555	455.125	454.485	455.03	3525135.0
2023-11-20 15:30:00	SPY	ETF	455.03	455.04	453.92	454.24	13935446.0
2023-11-20 16:00:00	SPY	ETF	454.23	454.7701	451.76	453.99	2820642.0
2023-11-20 16:30:00	SPY	ETF	453.96	454.15	453.93	454.13	313344.0
2023-11-20 17:00:00	SPY	ETF	454.15	454.26	454.15	454.22	263480.0
2023-11-20 17:30:00	SPY	ETF	454.2	454.26	454.18	454.25	225977.0
2023-11-20 18:00:00	SPY	ETF	454.26	454.43	454.16	454.31	52179.0
2023-11-20 18:30:00	SPY	ETF	454.26	454.42	454.23	454.42	49346.0
2023-11-20 19:00:00	SPY	ETF	454.41	454.54	454.27	454.51	16839.0
2023-11-20 19:30:00	SPY	ETF	454.52	454.62	454.41	454.43	44255.0
2023-11-20 04:00:00	QQQ	ETF	385.78	386.56	385.77	386.49	52805.0
2023-11-20 04:30:00	QQQ	ETF	386.47	386.87	386.39	386.87	24468.0
2023-11-20 05:00:00	QQQ	ETF	386.89	386.93	386.57	386.6	30292.0
2023-11-20 05:30:00	QQQ	ETF	386.61	386.67	386.42	386.56	13215.0
2023-11-20 06:00:00	QQQ	ETF	386.52	386.64	386.38	386.55	35137.0
2023-11-20 06:30:00	QQQ	ETF	386.47	386.85	386.29	386.7	12923.0
2023-11-20 07:00:00	QQQ	ETF	386.62	386.73	386.54	386.54	53296.0
2023-11-20 07:30:00	QQQ	ETF	386.5	386.6	385.94	386.08	51300.0
2023-11-20 08:00:00	QQQ	ETF	386.66	386.7	384.69	385.979	72817.0
2023-11-20 08:30:00	QQQ	ETF	385.92	386.65	385.92	386.5	66453.0
2023-11-20 09:00:00	QQQ	ETF	386.49	386.75	385.94	386.06	158858.0
2023-11-20 09:30:00	QQQ	ETF	386.05	388.52	386.04	388.48	4533767.0
2023-11-20 10:00:00	QQQ	ETF	388.5	388.65	387.1	387.64	2816307.0
2023-11-20 10:30:00	QQQ	ETF	387.64	388.59	387.22	388.59	2034028.0
2023-11-20 11:00:00	QQQ	ETF	388.59	389.03	388.59	388.85	2568864.0
2023-11-20 11:30:00	QQQ	ETF	388.86	389.09	388.62	388.9099	1865253.0
2023-11-20 12:00:00	QQQ	ETF	388.91	389.36	388.68	389.04	1743699.0
2023-11-20 12:30:00	QQQ	ETF	389.06	389.16	388.83	388.87	1336108.0

> showing 50 of 30,415 rows — these rows as CSV

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