PREVIEW / etf_30min / 2022-09-13

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-09-13.parquet
  size:    673 KB
  rows:    27,186

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-09-13 04:00:00	SPY	ETF	412.42	412.87	412.42	412.79	18748.0
2022-09-13 04:30:00	SPY	ETF	412.82	412.85	412.46	412.67	13127.0
2022-09-13 05:00:00	SPY	ETF	412.55	412.82	412.33	412.33	6575.0
2022-09-13 05:30:00	SPY	ETF	412.43	412.56	412.3	412.52	18416.0
2022-09-13 06:00:00	SPY	ETF	412.55	412.83	412.44	412.83	5268.0
2022-09-13 06:30:00	SPY	ETF	412.84	413.64	412.83	413.64	33143.0
2022-09-13 07:00:00	SPY	ETF	413.5	413.88	413.5	413.6	149374.0
2022-09-13 07:30:00	SPY	ETF	413.7	413.99	413.63	413.78	160580.0
2022-09-13 08:00:00	SPY	ETF	413.6982	414.39	411.4	413.85	455959.0
2022-09-13 08:30:00	SPY	ETF	414.23	415.02	401.99	401.99	5433950.0
2022-09-13 09:00:00	SPY	ETF	401.98	402.24	401.08	401.77	1806599.0
2022-09-13 09:30:00	SPY	ETF	401.82	403.1	400.81	400.9	9513560.0
2022-09-13 10:00:00	SPY	ETF	400.91	401.06	399.7	400.1099	7151038.0
2022-09-13 10:30:00	SPY	ETF	400.1	400.43	398.02	398.4101	5629616.0
2022-09-13 11:00:00	SPY	ETF	398.43	398.82	397.75	398.06	3612047.0
2022-09-13 11:30:00	SPY	ETF	398.02	398.48	397.63	397.885	3069720.0
2022-09-13 12:00:00	SPY	ETF	397.88	399.12	397.6	398.065	3344288.0
2022-09-13 12:30:00	SPY	ETF	398.06	398.79	397.73	398.4	2301887.0
2022-09-13 13:00:00	SPY	ETF	398.39	399.49	397.96	399.4507	2911229.0
2022-09-13 13:30:00	SPY	ETF	399.45	399.66	398.36	398.41	2271678.0
2022-09-13 14:00:00	SPY	ETF	398.42	398.56	397.1499	397.25	3130094.0
2022-09-13 14:30:00	SPY	ETF	397.2499	397.3872	395.59	395.87	3774585.0
2022-09-13 15:00:00	SPY	ETF	395.87	396.09	394.17	394.18	6300459.0
2022-09-13 15:30:00	SPY	ETF	394.19	394.29	391.92	393.13	20012796.0
2022-09-13 16:00:00	SPY	ETF	393.15	393.85	393.01	393.31	7957892.0
2022-09-13 16:30:00	SPY	ETF	393.29	393.75	393.24	393.56	204565.0
2022-09-13 17:00:00	SPY	ETF	393.6	393.83	393.5	393.8	63880.0
2022-09-13 17:30:00	SPY	ETF	393.73	393.89	393.53	393.81	40027.0
2022-09-13 18:00:00	SPY	ETF	393.75	393.9	393.24	393.74	84291.0
2022-09-13 18:30:00	SPY	ETF	393.75	394.37	393.69	394.02	70601.0
2022-09-13 19:00:00	SPY	ETF	394.02	394.02	393.22	393.66	51168.0
2022-09-13 19:30:00	SPY	ETF	393.66	394.06	393.5	393.91	34625.0
2022-09-13 04:00:00	QQQ	ETF	312.0	312.25	311.85	312.11	44848.0
2022-09-13 04:30:00	QQQ	ETF	312.05	312.12	311.84	311.86	6725.0
2022-09-13 05:00:00	QQQ	ETF	311.9	312.02	311.64	311.64	4760.0
2022-09-13 05:30:00	QQQ	ETF	311.71	311.95	311.6	311.87	15702.0
2022-09-13 06:00:00	QQQ	ETF	311.77	312.11	311.77	312.0	12590.0
2022-09-13 06:30:00	QQQ	ETF	312.04	312.64	312.04	312.63	12903.0
2022-09-13 07:00:00	QQQ	ETF	312.56	312.95	312.55	312.84	82538.0
2022-09-13 07:30:00	QQQ	ETF	312.87	313.13	312.73	312.9	109692.0
2022-09-13 08:00:00	QQQ	ETF	312.6	313.53	310.973	313.01	467124.0
2022-09-13 08:30:00	QQQ	ETF	313.11	313.94	301.83	301.85	5307950.0
2022-09-13 09:00:00	QQQ	ETF	301.82	302.24	301.13	301.76	1356540.0
2022-09-13 09:30:00	QQQ	ETF	301.8	303.02	300.15	300.19	8043365.0
2022-09-13 10:00:00	QQQ	ETF	300.2	300.71	299.45	299.851	4630888.0
2022-09-13 10:30:00	QQQ	ETF	299.83	300.28	297.82	298.26	3964918.0
2022-09-13 11:00:00	QQQ	ETF	298.265	298.48	297.14	297.43	2739001.0
2022-09-13 11:30:00	QQQ	ETF	297.4	297.91	297.21	297.5	2122804.0
2022-09-13 12:00:00	QQQ	ETF	297.47	298.54	297.17	297.675	2328654.0
2022-09-13 12:30:00	QQQ	ETF	297.67	298.32	297.48	297.9	1842369.0

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

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