PREVIEW / etf_30min / 2022-11-17

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-17.parquet
  size:    687 KB
  rows:    27,587

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
2022-11-17 04:00:00	SPY	ETF	396.27	396.41	395.79	396.01	34159.0
2022-11-17 04:30:00	SPY	ETF	395.91	395.91	394.49	394.77	67086.0
2022-11-17 05:00:00	SPY	ETF	394.9	395.45	394.71	395.38	12975.0
2022-11-17 05:30:00	SPY	ETF	395.39	395.39	393.35	393.35	41141.0
2022-11-17 06:00:00	SPY	ETF	393.26	393.76	392.88	392.95	57528.0
2022-11-17 06:30:00	SPY	ETF	393.02	393.36	392.33	393.33	77248.0
2022-11-17 07:00:00	SPY	ETF	393.38	393.53	392.68	392.87	195246.0
2022-11-17 07:30:00	SPY	ETF	392.97	393.0	391.98	392.17	170852.0
2022-11-17 08:00:00	SPY	ETF	393.47	397.12	390.8325	391.35	625635.0
2022-11-17 08:30:00	SPY	ETF	391.39	392.0	390.27	390.36	729913.0
2022-11-17 09:00:00	SPY	ETF	390.36	390.91	390.04	390.42	633232.0
2022-11-17 09:30:00	SPY	ETF	390.46	391.7	390.27	390.3744	6210132.0
2022-11-17 10:00:00	SPY	ETF	390.33	392.2	390.14	391.97	5029142.0
2022-11-17 10:30:00	SPY	ETF	391.96	391.9899	390.5	390.56	2919374.0
2022-11-17 11:00:00	SPY	ETF	390.541	391.32	390.29	391.2289	3204514.0
2022-11-17 11:30:00	SPY	ETF	391.2168	393.18	391.0156	393.14	3404867.0
2022-11-17 12:00:00	SPY	ETF	393.1401	393.66	392.93	392.9904	3090601.0
2022-11-17 12:30:00	SPY	ETF	393.01	394.548	392.73	394.26	3320025.0
2022-11-17 13:00:00	SPY	ETF	394.26	394.95	394.06	394.4	2894111.0
2022-11-17 13:30:00	SPY	ETF	394.415	394.88	393.69	394.2111	2391910.0
2022-11-17 14:00:00	SPY	ETF	394.22	394.65	392.88	393.26	3032677.0
2022-11-17 14:30:00	SPY	ETF	393.26	393.44	392.5	393.15	2454860.0
2022-11-17 15:00:00	SPY	ETF	393.1339	393.38	391.64	392.07	3891446.0
2022-11-17 15:30:00	SPY	ETF	392.06	394.365	391.981	394.28	7641841.0
2022-11-17 16:00:00	SPY	ETF	394.27	394.58	393.99	394.28	5933410.0
2022-11-17 16:30:00	SPY	ETF	394.28	394.86	394.24	394.81	233033.0
2022-11-17 17:00:00	SPY	ETF	394.7508	395.0	394.65	394.99	60471.0
2022-11-17 17:30:00	SPY	ETF	394.95	394.99	394.89	394.9	37572.0
2022-11-17 18:00:00	SPY	ETF	394.88	395.16	394.37	394.58	68631.0
2022-11-17 18:30:00	SPY	ETF	394.58	394.58	394.07	394.07	61469.0
2022-11-17 19:00:00	SPY	ETF	394.18	394.3	394.0	394.1	48290.0
2022-11-17 19:30:00	SPY	ETF	394.1	394.66	394.1	394.66	86722.0
2022-11-17 04:00:00	QQQ	ETF	287.0	287.0	285.96	286.26	26545.0
2022-11-17 04:30:00	QQQ	ETF	286.15	286.15	284.89	285.04	42760.0
2022-11-17 05:00:00	QQQ	ETF	285.24	285.64	285.09	285.63	36299.0
2022-11-17 05:30:00	QQQ	ETF	285.6	285.6	283.68	283.81	68742.0
2022-11-17 06:00:00	QQQ	ETF	283.67	284.22	283.5	283.55	42789.0
2022-11-17 06:30:00	QQQ	ETF	283.62	284.17	283.18	284.11	101481.0
2022-11-17 07:00:00	QQQ	ETF	284.15	284.23	283.55	283.78	126258.0
2022-11-17 07:30:00	QQQ	ETF	283.77	283.83	282.71	282.87	283363.0
2022-11-17 08:00:00	QQQ	ETF	284.07	287.5	281.684	282.09	493374.0
2022-11-17 08:30:00	QQQ	ETF	282.21	282.59	281.08	281.16	858077.0
2022-11-17 09:00:00	QQQ	ETF	281.13	281.45	280.36	280.89	781710.0
2022-11-17 09:30:00	QQQ	ETF	280.93	282.97	280.72	281.83	5287714.0
2022-11-17 10:00:00	QQQ	ETF	281.82	283.8557	281.42	283.58	3596436.0
2022-11-17 10:30:00	QQQ	ETF	283.566	283.61	282.23	282.23	2355170.0
2022-11-17 11:00:00	QQQ	ETF	282.22	283.17	282.06	283.0601	2555755.0
2022-11-17 11:30:00	QQQ	ETF	283.05	284.78	282.89	284.74	2407508.0
2022-11-17 12:00:00	QQQ	ETF	284.75	285.1101	284.23	284.33	2098467.0
2022-11-17 12:30:00	QQQ	ETF	284.34	286.05	284.06	285.69	2180209.0

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

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