PREVIEW / etf_30min / 2023-10-20

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-10-20.parquet
  size:    716 KB
  rows:    28,834

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-10-20 04:00:00	SPY	ETF	425.78	426.46	425.34	426.34	49519.0
2023-10-20 04:30:00	SPY	ETF	426.27	426.73	426.17	426.35	16924.0
2023-10-20 05:00:00	SPY	ETF	426.24	426.33	425.6	425.6	8245.0
2023-10-20 05:30:00	SPY	ETF	425.34	425.87	425.27	425.61	15819.0
2023-10-20 06:00:00	SPY	ETF	425.69	425.71	425.18	425.22	12856.0
2023-10-20 06:30:00	SPY	ETF	425.22	425.63	425.22	425.39	28818.0
2023-10-20 07:00:00	SPY	ETF	425.38	426.03	425.31	425.83	134066.0
2023-10-20 07:30:00	SPY	ETF	425.77	426.28	425.44	426.08	144998.0
2023-10-20 08:00:00	SPY	ETF	426.05	426.6304	424.58	424.76	413268.0
2023-10-20 08:30:00	SPY	ETF	424.72	425.41	424.72	425.15	386364.0
2023-10-20 09:00:00	SPY	ETF	425.25	426.03	425.19	425.92	524398.0
2023-10-20 09:30:00	SPY	ETF	425.98	426.54	425.09	425.09	7586303.0
2023-10-20 10:00:00	SPY	ETF	425.07	425.43	423.25	423.37	7371728.0
2023-10-20 10:30:00	SPY	ETF	423.35	423.89	422.33	422.4091	7395707.0
2023-10-20 11:00:00	SPY	ETF	422.405	423.22	422.08	422.29	5576686.0
2023-10-20 11:30:00	SPY	ETF	422.3	423.752	421.91	423.385	6894741.0
2023-10-20 12:00:00	SPY	ETF	423.39	423.71	422.295	422.98	4601014.0
2023-10-20 12:30:00	SPY	ETF	422.99	424.46	422.99	424.269	3631473.0
2023-10-20 13:00:00	SPY	ETF	424.27	424.77	423.08	424.1801	4504153.0
2023-10-20 13:30:00	SPY	ETF	424.19	424.64	423.36	424.22	3303403.0
2023-10-20 14:00:00	SPY	ETF	424.2	424.2884	422.47	422.61	4887096.0
2023-10-20 14:30:00	SPY	ETF	422.6	423.33	422.2367	422.62	4943408.0
2023-10-20 15:00:00	SPY	ETF	422.63	423.11	421.745	422.33	5860127.0
2023-10-20 15:30:00	SPY	ETF	422.3299	422.57	421.08	421.21	16163962.0
2023-10-20 16:00:00	SPY	ETF	421.21	425.5286	420.72	421.09	4654728.0
2023-10-20 16:30:00	SPY	ETF	421.12	421.15	420.87	420.9	284275.0
2023-10-20 17:00:00	SPY	ETF	420.9	421.05	420.8692	421.02	114989.0
2023-10-20 17:30:00	SPY	ETF	421.0	421.0	420.85	420.85	103285.0
2023-10-20 18:00:00	SPY	ETF	420.85	420.85	420.65	420.78	35207.0
2023-10-20 18:30:00	SPY	ETF	420.7912	420.85	420.75	420.85	5653.0
2023-10-20 19:00:00	SPY	ETF	420.84	420.84	420.75	420.75	3338.0
2023-10-20 19:30:00	SPY	ETF	420.76	420.8	420.6	420.6	7756.0
2023-10-20 04:00:00	QQQ	ETF	358.64	359.66	358.53	359.57	37116.0
2023-10-20 04:30:00	QQQ	ETF	359.5	360.05	359.43	359.61	29267.0
2023-10-20 05:00:00	QQQ	ETF	359.58	359.6	358.85	358.9	35330.0
2023-10-20 05:30:00	QQQ	ETF	358.84	359.29	358.67	359.19	31472.0
2023-10-20 06:00:00	QQQ	ETF	359.1	359.23	358.68	358.7	17929.0
2023-10-20 06:30:00	QQQ	ETF	358.74	359.01	358.56	358.74	19532.0
2023-10-20 07:00:00	QQQ	ETF	358.78	359.32	358.61	359.13	70923.0
2023-10-20 07:30:00	QQQ	ETF	359.14	359.65	358.87	359.44	52192.0
2023-10-20 08:00:00	QQQ	ETF	359.46	360.239	358.0	358.2183	522598.0
2023-10-20 08:30:00	QQQ	ETF	358.3	358.72	358.25	358.6	127307.0
2023-10-20 09:00:00	QQQ	ETF	358.55	359.75	358.55	359.52	536142.0
2023-10-20 09:30:00	QQQ	ETF	359.48	360.04	358.21	358.89	5985727.0
2023-10-20 10:00:00	QQQ	ETF	358.85	359.4392	356.99	357.115	4105999.0
2023-10-20 10:30:00	QQQ	ETF	357.1	357.35	355.12	355.125	4599698.0
2023-10-20 11:00:00	QQQ	ETF	355.13	356.11	354.74	354.97	3772362.0
2023-10-20 11:30:00	QQQ	ETF	355.0	356.5006	354.6	356.18	4106805.0
2023-10-20 12:00:00	QQQ	ETF	356.19	356.35	355.25	355.71	2616129.0
2023-10-20 12:30:00	QQQ	ETF	355.71	357.45	355.7001	357.3334	2485231.0

> showing 50 of 28,834 rows — these rows as CSV

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