PREVIEW / etf_30min / 2023-03-28

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-28.parquet
  size:    664 KB
  rows:    26,501

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-03-28 04:00:00	SPY	ETF	396.65	396.7	396.32	396.46	26757.0
2023-03-28 04:30:00	SPY	ETF	396.45	396.48	396.11	396.22	21413.0
2023-03-28 05:00:00	SPY	ETF	396.3	396.4	396.11	396.28	8544.0
2023-03-28 05:30:00	SPY	ETF	396.33	396.33	395.78	395.93	13024.0
2023-03-28 06:00:00	SPY	ETF	395.9	396.05	395.75	395.89	15229.0
2023-03-28 06:30:00	SPY	ETF	395.86	395.86	395.56	395.78	45617.0
2023-03-28 07:00:00	SPY	ETF	395.79	396.39	395.75	396.34	91189.0
2023-03-28 07:30:00	SPY	ETF	396.38	396.53	396.18	396.22	60525.0
2023-03-28 08:00:00	SPY	ETF	396.42	397.9	395.77	395.89	176093.0
2023-03-28 08:30:00	SPY	ETF	395.89	395.89	395.32	395.52	268836.0
2023-03-28 09:00:00	SPY	ETF	395.5	395.78	395.36	395.77	156858.0
2023-03-28 09:30:00	SPY	ETF	395.77	396.03	394.97	395.4906	5027838.0
2023-03-28 10:00:00	SPY	ETF	395.4906	396.49	395.06	395.87	4182724.0
2023-03-28 10:30:00	SPY	ETF	395.89	395.95	394.55	394.8099	4119318.0
2023-03-28 11:00:00	SPY	ETF	394.8	395.925	394.74	395.75	3123332.0
2023-03-28 11:30:00	SPY	ETF	395.75	396.21	395.6	396.04	2451545.0
2023-03-28 12:00:00	SPY	ETF	396.06	396.1494	395.22	395.4	1990110.0
2023-03-28 12:30:00	SPY	ETF	395.41	395.68	395.105	395.37	1790090.0
2023-03-28 13:00:00	SPY	ETF	395.37	395.5	394.78	394.91	2564512.0
2023-03-28 13:30:00	SPY	ETF	394.922	395.08	393.69	393.845	3771181.0
2023-03-28 14:00:00	SPY	ETF	393.84	394.49	393.73	394.31	2772782.0
2023-03-28 14:30:00	SPY	ETF	394.32	394.98	394.0	394.82	3128288.0
2023-03-28 15:00:00	SPY	ETF	394.83	395.29	394.52	394.6579	3824615.0
2023-03-28 15:30:00	SPY	ETF	394.65	395.72	394.34	395.65	6931109.0
2023-03-28 16:00:00	SPY	ETF	395.65	396.2499	395.6	396.16	2289863.0
2023-03-28 16:30:00	SPY	ETF	396.17	396.22	395.6	396.18	633275.0
2023-03-28 17:00:00	SPY	ETF	396.19	396.31	396.17	396.3	49547.0
2023-03-28 17:30:00	SPY	ETF	396.29	396.29	396.2	396.27	25399.0
2023-03-28 18:00:00	SPY	ETF	396.26	396.41	396.15	396.4	136281.0
2023-03-28 18:30:00	SPY	ETF	396.38	396.38	396.24	396.27	17153.0
2023-03-28 19:00:00	SPY	ETF	396.28	396.46	396.28	396.38	10716.0
2023-03-28 19:30:00	SPY	ETF	396.36	396.7	396.36	396.61	45292.0
2023-03-28 04:00:00	QQQ	ETF	307.88	308.79	307.67	307.88	33018.0
2023-03-28 04:30:00	QQQ	ETF	307.91	308.02	307.62	307.9	16481.0
2023-03-28 05:00:00	QQQ	ETF	308.02	308.16	307.97	308.09	12976.0
2023-03-28 05:30:00	QQQ	ETF	308.13	308.2	307.76	307.96	23422.0
2023-03-28 06:00:00	QQQ	ETF	307.92	308.08	307.9	307.95	4311.0
2023-03-28 06:30:00	QQQ	ETF	307.96	307.96	307.62	307.92	24456.0
2023-03-28 07:00:00	QQQ	ETF	307.94	308.42	307.8	308.42	84921.0
2023-03-28 07:30:00	QQQ	ETF	308.42	308.68	308.38	308.52	42774.0
2023-03-28 08:00:00	QQQ	ETF	308.0399	309.25	307.6396	308.41	165556.0
2023-03-28 08:30:00	QQQ	ETF	308.37	308.43	307.78	308.09	154938.0
2023-03-28 09:00:00	QQQ	ETF	308.04	308.24	307.81	308.17	166086.0
2023-03-28 09:30:00	QQQ	ETF	308.17	308.2	305.94	306.19	6372106.0
2023-03-28 10:00:00	QQQ	ETF	306.17	307.11	305.29	306.47	3408989.0
2023-03-28 10:30:00	QQQ	ETF	306.475	306.5686	305.15	305.3101	3100197.0
2023-03-28 11:00:00	QQQ	ETF	305.31	306.7	305.25	306.47	2626311.0
2023-03-28 11:30:00	QQQ	ETF	306.47	306.9	306.31	306.6559	2010205.0
2023-03-28 12:00:00	QQQ	ETF	306.66	306.77	305.675	305.82	1726168.0
2023-03-28 12:30:00	QQQ	ETF	305.82	306.16	305.4747	305.94	1433819.0

> showing 50 of 26,501 rows — these rows as CSV

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