PREVIEW / etf_30min / 2023-07-19

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-07-19.parquet
  size:    723 KB
  rows:    29,004

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-07-19 04:00:00	SPY	ETF	454.09	454.5	454.09	454.5	43271.0
2023-07-19 04:30:00	SPY	ETF	454.43	454.61	454.4	454.55	4400.0
2023-07-19 05:00:00	SPY	ETF	454.42	454.6	454.42	454.47	7442.0
2023-07-19 05:30:00	SPY	ETF	454.45	454.64	454.45	454.5	23978.0
2023-07-19 06:00:00	SPY	ETF	454.47	454.54	454.37	454.37	7083.0
2023-07-19 06:30:00	SPY	ETF	454.42	454.51	454.37	454.51	16559.0
2023-07-19 07:00:00	SPY	ETF	454.52	454.59	454.0	454.35	49589.0
2023-07-19 07:30:00	SPY	ETF	454.32	454.34	454.0	454.21	29985.0
2023-07-19 08:00:00	SPY	ETF	454.26	454.71	454.02	454.24	87094.0
2023-07-19 08:30:00	SPY	ETF	454.23	454.54	454.16	454.43	142283.0
2023-07-19 09:00:00	SPY	ETF	454.44	455.04	454.4312	455.03	208866.0
2023-07-19 09:30:00	SPY	ETF	455.03	456.12	455.01	456.02	6530101.0
2023-07-19 10:00:00	SPY	ETF	456.01	456.34	455.78	455.82	3982179.0
2023-07-19 10:30:00	SPY	ETF	455.8	456.17	454.6	455.28	4996560.0
2023-07-19 11:00:00	SPY	ETF	455.29	455.96	455.09	455.75	2951770.0
2023-07-19 11:30:00	SPY	ETF	455.755	456.15	455.7288	455.98	2166703.0
2023-07-19 12:00:00	SPY	ETF	455.98	456.43	455.09	455.379	4374436.0
2023-07-19 12:30:00	SPY	ETF	455.365	455.37	454.76	455.359	2814106.0
2023-07-19 13:00:00	SPY	ETF	455.37	455.41	454.65	455.15	2047261.0
2023-07-19 13:30:00	SPY	ETF	455.14	455.36	454.78	455.0785	1553691.0
2023-07-19 14:00:00	SPY	ETF	455.075	455.2	454.37	454.7001	3300533.0
2023-07-19 14:30:00	SPY	ETF	454.71	455.47	454.685	455.375	2327340.0
2023-07-19 15:00:00	SPY	ETF	455.38	456.07	455.37	455.81	2719428.0
2023-07-19 15:30:00	SPY	ETF	455.81	455.815	455.03	455.13	6567707.0
2023-07-19 16:00:00	SPY	ETF	455.11	455.3	454.66	454.95	2158609.0
2023-07-19 16:30:00	SPY	ETF	454.99	455.18	454.94	455.05	250871.0
2023-07-19 17:00:00	SPY	ETF	455.03	455.19	455.01	455.1	23522.0
2023-07-19 17:30:00	SPY	ETF	455.06	455.09	454.8	454.82	121434.0
2023-07-19 18:00:00	SPY	ETF	454.83	454.92	453.9	453.95	241225.0
2023-07-19 18:30:00	SPY	ETF	454.02	454.0999	453.69	453.82	74559.0
2023-07-19 19:00:00	SPY	ETF	453.86	454.05	453.74	454.05	37359.0
2023-07-19 19:30:00	SPY	ETF	454.03	454.0312	453.84	454.01	41148.0
2023-07-19 04:00:00	QQQ	ETF	385.84	386.08	385.62	386.08	21837.0
2023-07-19 04:30:00	QQQ	ETF	386.01	386.29	386.01	386.19	15521.0
2023-07-19 05:00:00	QQQ	ETF	386.18	386.28	386.01	386.12	20199.0
2023-07-19 05:30:00	QQQ	ETF	386.18	386.7	386.18	386.54	24233.0
2023-07-19 06:00:00	QQQ	ETF	386.54	386.55	386.23	386.25	15750.0
2023-07-19 06:30:00	QQQ	ETF	386.34	386.6	386.14	386.6	19452.0
2023-07-19 07:00:00	QQQ	ETF	386.6	386.7	386.12	386.45	80316.0
2023-07-19 07:30:00	QQQ	ETF	386.47	386.48	386.06	386.29	33170.0
2023-07-19 08:00:00	QQQ	ETF	386.32	386.67	385.42	386.46	89535.0
2023-07-19 08:30:00	QQQ	ETF	386.48	386.85	386.43	386.72	208172.0
2023-07-19 09:00:00	QQQ	ETF	386.67	386.89	386.59	386.77	196390.0
2023-07-19 09:30:00	QQQ	ETF	386.82	387.38	385.955	386.53	5164962.0
2023-07-19 10:00:00	QQQ	ETF	386.535	386.82	385.79	386.14	2794551.0
2023-07-19 10:30:00	QQQ	ETF	386.12	387.54	385.84	386.5199	3365032.0
2023-07-19 11:00:00	QQQ	ETF	386.52	387.65	386.26	387.23	2742974.0
2023-07-19 11:30:00	QQQ	ETF	387.24	387.655	386.8495	387.0897	1748857.0
2023-07-19 12:00:00	QQQ	ETF	387.07	387.98	385.54	385.93	5994204.0
2023-07-19 12:30:00	QQQ	ETF	385.93	386.23	385.215	385.8388	2469488.0

> showing 50 of 29,004 rows — these rows as CSV

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