PREVIEW / etf_30min / 2023-03-29

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-29.parquet
  size:    677 KB
  rows:    27,383

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-29 04:00:00	SPY	ETF	398.81	399.0	397.86	399.0	36889.0
2023-03-29 04:30:00	SPY	ETF	399.0	399.29	398.88	398.95	19074.0
2023-03-29 05:00:00	SPY	ETF	399.06	399.39	399.06	399.31	9165.0
2023-03-29 05:30:00	SPY	ETF	399.25	399.5	399.21	399.5	22586.0
2023-03-29 06:00:00	SPY	ETF	399.48	399.48	398.87	399.23	51504.0
2023-03-29 06:30:00	SPY	ETF	399.22	399.25	399.07	399.12	14906.0
2023-03-29 07:00:00	SPY	ETF	399.07	399.21	398.8	398.93	177308.0
2023-03-29 07:30:00	SPY	ETF	398.92	399.21	398.8	398.8	131621.0
2023-03-29 08:00:00	SPY	ETF	398.83	399.3804	397.54	398.76	196444.0
2023-03-29 08:30:00	SPY	ETF	398.79	399.15	398.65	399.09	160533.0
2023-03-29 09:00:00	SPY	ETF	399.07	400.02	399.07	399.92	475878.0
2023-03-29 09:30:00	SPY	ETF	399.92	400.125	399.425	399.8401	7604567.0
2023-03-29 10:00:00	SPY	ETF	399.85	400.27	399.27	399.49	4210675.0
2023-03-29 10:30:00	SPY	ETF	399.49	399.65	398.68	398.82	4342185.0
2023-03-29 11:00:00	SPY	ETF	398.81	399.45	398.75	399.34	2511147.0
2023-03-29 11:30:00	SPY	ETF	399.35	399.93	399.265	399.89	2583831.0
2023-03-29 12:00:00	SPY	ETF	399.9	400.0999	399.5	399.88	2936165.0
2023-03-29 12:30:00	SPY	ETF	399.89	400.12	399.48	399.66	1860358.0
2023-03-29 13:00:00	SPY	ETF	399.66	400.45	399.47	400.3701	2176291.0
2023-03-29 13:30:00	SPY	ETF	400.37	400.38	399.38	399.5589	2693270.0
2023-03-29 14:00:00	SPY	ETF	399.56	399.95	399.23	399.865	2695215.0
2023-03-29 14:30:00	SPY	ETF	399.87	400.71	399.77	400.61	2890429.0
2023-03-29 15:00:00	SPY	ETF	400.63	401.32	400.1	401.2101	5455413.0
2023-03-29 15:30:00	SPY	ETF	401.215	401.6	400.77	401.34	12235425.0
2023-03-29 16:00:00	SPY	ETF	401.34	401.41	401.13	401.37	4984986.0
2023-03-29 16:30:00	SPY	ETF	401.37	401.5	401.28	401.31	216776.0
2023-03-29 17:00:00	SPY	ETF	401.31	401.4	401.28	401.37	5823.0
2023-03-29 17:30:00	SPY	ETF	401.38	401.4	401.33	401.37	23658.0
2023-03-29 18:00:00	SPY	ETF	401.33	401.44	401.15	401.3	46352.0
2023-03-29 18:30:00	SPY	ETF	401.3	401.3	401.06	401.14	21702.0
2023-03-29 19:00:00	SPY	ETF	401.21	401.22	401.11	401.14	13359.0
2023-03-29 19:30:00	SPY	ETF	401.14	401.14	400.86	400.9	39671.0
2023-03-29 04:00:00	QQQ	ETF	309.8	309.85	309.45	309.82	55929.0
2023-03-29 04:30:00	QQQ	ETF	309.83	309.96	309.6	309.74	23791.0
2023-03-29 05:00:00	QQQ	ETF	309.73	310.1	309.73	310.04	10162.0
2023-03-29 05:30:00	QQQ	ETF	310.1	310.1	309.95	310.01	15642.0
2023-03-29 06:00:00	QQQ	ETF	310.06	310.06	309.69	309.84	19543.0
2023-03-29 06:30:00	QQQ	ETF	309.87	309.87	309.56	309.66	89283.0
2023-03-29 07:00:00	QQQ	ETF	309.65	309.8	309.5	309.73	128342.0
2023-03-29 07:30:00	QQQ	ETF	309.66	310.01	309.63	309.67	169972.0
2023-03-29 08:00:00	QQQ	ETF	309.54	310.01	307.35	309.7	198867.0
2023-03-29 08:30:00	QQQ	ETF	309.7	310.22	309.6	310.07	352059.0
2023-03-29 09:00:00	QQQ	ETF	310.06	310.93	310.05	310.89	530765.0
2023-03-29 09:30:00	QQQ	ETF	310.88	311.83	310.75	311.52	6011267.0
2023-03-29 10:00:00	QQQ	ETF	311.52	311.94	310.72	310.946	3289755.0
2023-03-29 10:30:00	QQQ	ETF	310.95	311.03	310.05	310.2	3164215.0
2023-03-29 11:00:00	QQQ	ETF	310.19	311.12	310.17	311.1	2231940.0
2023-03-29 11:30:00	QQQ	ETF	311.1	311.59	311.06	311.57	2197778.0
2023-03-29 12:00:00	QQQ	ETF	311.57	311.89	311.15	311.68	1483375.0
2023-03-29 12:30:00	QQQ	ETF	311.68	311.8701	310.94	311.1257	1547569.0

> showing 50 of 27,383 rows — these rows as CSV

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