PREVIEW / etf_30min / 2022-12-14

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-14.parquet
  size:    695 KB
  rows:    27,568

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-12-14 04:00:00	SPY	ETF	402.37	402.43	401.54	402.0	32933.0
2022-12-14 04:30:00	SPY	ETF	401.95	402.04	401.51	402.03	68517.0
2022-12-14 05:00:00	SPY	ETF	402.08	402.26	401.86	402.25	7842.0
2022-12-14 05:30:00	SPY	ETF	402.29	402.29	401.8	401.92	3463.0
2022-12-14 06:00:00	SPY	ETF	401.83	401.93	401.09	401.46	22290.0
2022-12-14 06:30:00	SPY	ETF	401.44	402.03	401.09	402.02	23448.0
2022-12-14 07:00:00	SPY	ETF	401.94	402.68	401.9	402.36	136034.0
2022-12-14 07:30:00	SPY	ETF	402.31	402.33	401.24	401.44	80025.0
2022-12-14 08:00:00	SPY	ETF	402.17	403.27	400.92	401.47	234254.0
2022-12-14 08:30:00	SPY	ETF	401.36	401.83	401.31	401.68	175423.0
2022-12-14 09:00:00	SPY	ETF	401.75	402.07	401.31	401.58	184186.0
2022-12-14 09:30:00	SPY	ETF	401.61	403.98	401.58	403.85	5051550.0
2022-12-14 10:00:00	SPY	ETF	403.845	404.3799	403.47	404.13	3405426.0
2022-12-14 10:30:00	SPY	ETF	404.11	404.52	403.54	404.26	2262816.0
2022-12-14 11:00:00	SPY	ETF	404.27	404.95	404.05	404.8799	2239443.0
2022-12-14 11:30:00	SPY	ETF	404.88	405.04	404.08	404.14	2184700.0
2022-12-14 12:00:00	SPY	ETF	404.15	404.28	403.575	403.76	2095439.0
2022-12-14 12:30:00	SPY	ETF	403.78	404.12	403.52	403.56	1711787.0
2022-12-14 13:00:00	SPY	ETF	403.57	404.35	403.501	404.1	1619974.0
2022-12-14 13:30:00	SPY	ETF	404.09	405.5	404.06	404.76	3678372.0
2022-12-14 14:00:00	SPY	ETF	404.77	404.86	398.7	400.2	12152439.0
2022-12-14 14:30:00	SPY	ETF	400.2	400.5	396.31	398.86	13096777.0
2022-12-14 15:00:00	SPY	ETF	398.88	403.59	398.3747	398.71	10548533.0
2022-12-14 15:30:00	SPY	ETF	398.7	400.94	397.7	399.41	10993967.0
2022-12-14 16:00:00	SPY	ETF	399.41	400.57	399.21	400.3	4749856.0
2022-12-14 16:30:00	SPY	ETF	400.29	400.66	399.4	400.37	207148.0
2022-12-14 17:00:00	SPY	ETF	400.42	400.56	400.07	400.46	96417.0
2022-12-14 17:30:00	SPY	ETF	400.45	400.48	400.32	400.32	20806.0
2022-12-14 18:00:00	SPY	ETF	400.35	400.49	399.91	400.47	121749.0
2022-12-14 18:30:00	SPY	ETF	400.47	400.74	400.25	400.29	69705.0
2022-12-14 19:00:00	SPY	ETF	400.21	400.33	400.02	400.21	78524.0
2022-12-14 19:30:00	SPY	ETF	400.26	400.75	400.25	400.75	64553.0
2022-12-14 04:00:00	QQQ	ETF	289.29	289.29	288.36	288.45	45959.0
2022-12-14 04:30:00	QQQ	ETF	288.6	288.65	288.19	288.64	15292.0
2022-12-14 05:00:00	QQQ	ETF	288.65	288.96	288.45	288.96	11871.0
2022-12-14 05:30:00	QQQ	ETF	288.95	288.97	288.38	288.54	8731.0
2022-12-14 06:00:00	QQQ	ETF	288.44	288.54	287.81	288.15	24298.0
2022-12-14 06:30:00	QQQ	ETF	288.19	288.58	287.92	288.58	12833.0
2022-12-14 07:00:00	QQQ	ETF	288.6	289.16	288.48	288.93	45695.0
2022-12-14 07:30:00	QQQ	ETF	288.92	288.97	288.18	288.36	29227.0
2022-12-14 08:00:00	QQQ	ETF	288.6	289.82	287.92	288.33	156999.0
2022-12-14 08:30:00	QQQ	ETF	288.2	288.51	288.15	288.39	108063.0
2022-12-14 09:00:00	QQQ	ETF	288.4	288.515	287.88	288.0	201279.0
2022-12-14 09:30:00	QQQ	ETF	288.08	290.09	288.04	289.9774	3772284.0
2022-12-14 10:00:00	QQQ	ETF	289.97	290.77	289.68	290.5	2504730.0
2022-12-14 10:30:00	QQQ	ETF	290.5	290.74	289.85	290.38	1582997.0
2022-12-14 11:00:00	QQQ	ETF	290.42	291.05	290.07	290.85	1667580.0
2022-12-14 11:30:00	QQQ	ETF	290.85	291.21	290.415	290.52	1226799.0
2022-12-14 12:00:00	QQQ	ETF	290.51	290.54	289.6	289.84	1313834.0
2022-12-14 12:30:00	QQQ	ETF	289.82	290.03	289.5	289.54	1063003.0

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

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