PREVIEW / etf_30min / 2023-05-03

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-03.parquet
  size:    683 KB
  rows:    27,795

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-05-03 04:00:00	SPY	ETF	411.34	411.5	411.29	411.29	4227.0
2023-05-03 04:30:00	SPY	ETF	411.28	411.62	411.26	411.46	14772.0
2023-05-03 05:00:00	SPY	ETF	411.44	411.62	411.42	411.47	4659.0
2023-05-03 05:30:00	SPY	ETF	411.38	411.38	411.21	411.34	6381.0
2023-05-03 06:00:00	SPY	ETF	411.49	411.92	411.49	411.71	122309.0
2023-05-03 06:30:00	SPY	ETF	411.69	411.91	411.39	411.4	9413.0
2023-05-03 07:00:00	SPY	ETF	411.41	411.88	411.4	411.85	88678.0
2023-05-03 07:30:00	SPY	ETF	411.85	412.02	411.65	411.72	113945.0
2023-05-03 08:00:00	SPY	ETF	411.76	412.19	411.2604	411.89	204942.0
2023-05-03 08:30:00	SPY	ETF	411.92	412.03	411.25	411.26	153211.0
2023-05-03 09:00:00	SPY	ETF	411.26	411.7	411.07	411.34	199822.0
2023-05-03 09:30:00	SPY	ETF	411.36	412.65	411.25	412.19	4667017.0
2023-05-03 10:00:00	SPY	ETF	412.21	412.48	411.38	411.45	3116548.0
2023-05-03 10:30:00	SPY	ETF	411.43	411.65	410.51	410.895	3692044.0
2023-05-03 11:00:00	SPY	ETF	410.87	410.98	410.3	410.64	2570148.0
2023-05-03 11:30:00	SPY	ETF	410.64	411.55	410.455	411.49	2444470.0
2023-05-03 12:00:00	SPY	ETF	411.5	411.8	411.06	411.745	1999456.0
2023-05-03 12:30:00	SPY	ETF	411.76	412.15	411.46	412.15	1587715.0
2023-05-03 13:00:00	SPY	ETF	412.16	412.515	411.95	412.43	2007232.0
2023-05-03 13:30:00	SPY	ETF	412.44	412.58	411.91	412.12	2710541.0
2023-05-03 14:00:00	SPY	ETF	412.1137	413.52	411.12	412.57	7967143.0
2023-05-03 14:30:00	SPY	ETF	412.57	413.87	410.3	412.1825	11913926.0
2023-05-03 15:00:00	SPY	ETF	412.2024	413.07	408.745	408.825	11310723.0
2023-05-03 15:30:00	SPY	ETF	408.82	409.04	407.77	407.99	13263560.0
2023-05-03 16:00:00	SPY	ETF	407.98	408.9399	407.75	408.61	3568719.0
2023-05-03 16:30:00	SPY	ETF	408.69	408.79	406.75	406.93	858864.0
2023-05-03 17:00:00	SPY	ETF	406.96	408.02	406.5	406.95	640718.0
2023-05-03 17:30:00	SPY	ETF	406.95	406.96	406.1	406.13	180405.0
2023-05-03 18:00:00	SPY	ETF	406.1	406.34	405.03	405.75	246241.0
2023-05-03 18:30:00	SPY	ETF	405.75	410.16	405.52	406.17	210020.0
2023-05-03 19:00:00	SPY	ETF	406.15	406.4	405.88	406.4	101088.0
2023-05-03 19:30:00	SPY	ETF	406.34	406.6	406.29	406.59	82674.0
2023-05-03 04:00:00	QQQ	ETF	319.58	319.76	319.46	319.66	14399.0
2023-05-03 04:30:00	QQQ	ETF	319.59	320.05	319.59	319.94	20177.0
2023-05-03 05:00:00	QQQ	ETF	319.92	320.05	319.88	319.96	20177.0
2023-05-03 05:30:00	QQQ	ETF	319.88	320.07	319.8	319.99	18633.0
2023-05-03 06:00:00	QQQ	ETF	320.0	320.25	319.87	319.9	31492.0
2023-05-03 06:30:00	QQQ	ETF	319.96	320.15	319.77	319.82	25203.0
2023-05-03 07:00:00	QQQ	ETF	319.79	320.34	319.76	320.27	67054.0
2023-05-03 07:30:00	QQQ	ETF	320.27	320.36	320.0	320.2	55315.0
2023-05-03 08:00:00	QQQ	ETF	319.7899	320.42	319.32	320.18	198342.0
2023-05-03 08:30:00	QQQ	ETF	320.19	320.5	319.701	319.82	188515.0
2023-05-03 09:00:00	QQQ	ETF	319.79	320.13	319.66	319.7	266237.0
2023-05-03 09:30:00	QQQ	ETF	319.75	320.79	319.475	320.55	3804322.0
2023-05-03 10:00:00	QQQ	ETF	320.56	320.78	319.6299	319.67	2651651.0
2023-05-03 10:30:00	QQQ	ETF	319.65	320.36	319.62	319.755	2012955.0
2023-05-03 11:00:00	QQQ	ETF	319.74	319.86	319.26	319.45	1589499.0
2023-05-03 11:30:00	QQQ	ETF	319.445	320.16	319.2	320.11	1347303.0
2023-05-03 12:00:00	QQQ	ETF	320.11	320.13	319.48	320.07	1000893.0
2023-05-03 12:30:00	QQQ	ETF	320.08	320.41	319.74	320.4055	774413.0

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

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