PREVIEW / etf_30min / 2023-09-07

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-09-07.parquet
  size:    692 KB
  rows:    27,589

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-09-07 04:00:00	SPY	ETF	445.6	445.6	444.6	444.6	28270.0
2023-09-07 04:30:00	SPY	ETF	444.85	445.21	444.7	445.19	7714.0
2023-09-07 05:00:00	SPY	ETF	445.13	445.58	445.13	445.44	3800.0
2023-09-07 05:30:00	SPY	ETF	445.57	445.74	445.29	445.47	9375.0
2023-09-07 06:00:00	SPY	ETF	445.4	445.5	445.28	445.28	5875.0
2023-09-07 06:30:00	SPY	ETF	445.23	445.23	444.66	444.92	70980.0
2023-09-07 07:00:00	SPY	ETF	444.98	445.26	444.46	444.49	112221.0
2023-09-07 07:30:00	SPY	ETF	444.48	444.85	444.41	444.45	66804.0
2023-09-07 08:00:00	SPY	ETF	444.9799	446.07	444.15	444.42	125730.0
2023-09-07 08:30:00	SPY	ETF	444.26	444.34	442.7942	443.11	431144.0
2023-09-07 09:00:00	SPY	ETF	443.02	443.34	442.85	443.15	363743.0
2023-09-07 09:30:00	SPY	ETF	443.11	444.4	442.805	443.425	6461149.0
2023-09-07 10:00:00	SPY	ETF	443.43	443.85	442.86	443.195	3948165.0
2023-09-07 10:30:00	SPY	ETF	443.19	444.66	442.75	444.0299	4652465.0
2023-09-07 11:00:00	SPY	ETF	444.05	444.72	444.0302	444.23	2854449.0
2023-09-07 11:30:00	SPY	ETF	444.24	445.01	443.86	443.995	2634740.0
2023-09-07 12:00:00	SPY	ETF	443.99	445.1801	443.905	445.045	2213820.0
2023-09-07 12:30:00	SPY	ETF	445.06	445.24	444.415	444.4817	1957883.0
2023-09-07 13:00:00	SPY	ETF	444.49	445.12	444.305	445.085	1882772.0
2023-09-07 13:30:00	SPY	ETF	445.09	445.22	444.68	445.07	2108703.0
2023-09-07 14:00:00	SPY	ETF	445.08	445.35	444.42	444.425	2719200.0
2023-09-07 14:30:00	SPY	ETF	444.425	445.12	444.1	444.975	3055540.0
2023-09-07 15:00:00	SPY	ETF	444.98	445.11	444.27	444.935	3454206.0
2023-09-07 15:30:00	SPY	ETF	444.945	445.55	444.565	444.84	11636720.0
2023-09-07 16:00:00	SPY	ETF	444.83	445.0607	444.53	445.05	4492531.0
2023-09-07 16:30:00	SPY	ETF	445.03	445.06	444.98	445.01	63263.0
2023-09-07 17:00:00	SPY	ETF	445.13	445.13	444.95	445.04	3388.0
2023-09-07 17:30:00	SPY	ETF	445.03	445.18	444.85	445.1	341093.0
2023-09-07 18:00:00	SPY	ETF	445.11	445.159	445.0	445.12	7187.0
2023-09-07 18:30:00	SPY	ETF	445.06	445.08	445.05	445.08	7989.0
2023-09-07 19:00:00	SPY	ETF	445.11	445.11	444.81	444.88	12353.0
2023-09-07 19:30:00	SPY	ETF	444.94	445.12	444.94	445.03	15785.0
2023-09-07 04:00:00	QQQ	ETF	373.57	373.59	371.99	372.0	46901.0
2023-09-07 04:30:00	QQQ	ETF	372.01	372.63	372.01	372.51	48995.0
2023-09-07 05:00:00	QQQ	ETF	372.6	372.95	372.52	372.82	22579.0
2023-09-07 05:30:00	QQQ	ETF	372.9	373.39	372.76	372.81	49184.0
2023-09-07 06:00:00	QQQ	ETF	372.9	373.05	372.66	372.7	32078.0
2023-09-07 06:30:00	QQQ	ETF	372.64	372.65	372.35	372.45	42161.0
2023-09-07 07:00:00	QQQ	ETF	372.5	372.9	372.05	372.05	80041.0
2023-09-07 07:30:00	QQQ	ETF	372.1	372.5	372.02	372.1	155291.0
2023-09-07 08:00:00	QQQ	ETF	372.56	375.021	371.5	371.73	313498.0
2023-09-07 08:30:00	QQQ	ETF	371.72	371.72	369.92	370.23	573951.0
2023-09-07 09:00:00	QQQ	ETF	370.2	370.52	369.83	370.13	389584.0
2023-09-07 09:30:00	QQQ	ETF	370.19	371.16	369.15	370.0	7273386.0
2023-09-07 10:00:00	QQQ	ETF	370.0	371.08	369.26	370.43	3632188.0
2023-09-07 10:30:00	QQQ	ETF	370.44	372.15	369.86	371.0	3345782.0
2023-09-07 11:00:00	QQQ	ETF	371.01	371.91	370.8	370.89	2254662.0
2023-09-07 11:30:00	QQQ	ETF	370.89	371.765	370.1202	370.31	2198230.0
2023-09-07 12:00:00	QQQ	ETF	370.31	371.89	370.19	371.665	1829287.0
2023-09-07 12:30:00	QQQ	ETF	371.675	371.94	371.07	371.16	1366669.0

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

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