PREVIEW / etf_30min / 2023-08-23

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-23.parquet
  size:    714 KB
  rows:    28,296

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-08-23 04:00:00	SPY	ETF	439.81	440.67	439.74	440.6	20916.0
2023-08-23 04:30:00	SPY	ETF	440.62	440.62	440.37	440.45	9185.0
2023-08-23 05:00:00	SPY	ETF	440.39	440.62	440.04	440.2	11049.0
2023-08-23 05:30:00	SPY	ETF	440.25	440.51	440.24	440.41	10428.0
2023-08-23 06:00:00	SPY	ETF	440.36	440.49	439.93	439.93	26327.0
2023-08-23 06:30:00	SPY	ETF	439.97	440.04	439.2	439.36	19845.0
2023-08-23 07:00:00	SPY	ETF	439.4	439.41	438.5	438.7	308923.0
2023-08-23 07:30:00	SPY	ETF	438.65	439.06	438.59	439.01	106858.0
2023-08-23 08:00:00	SPY	ETF	439.19	440.6	438.17	438.4	295381.0
2023-08-23 08:30:00	SPY	ETF	438.35	438.98	438.26	438.54	329566.0
2023-08-23 09:00:00	SPY	ETF	438.55	439.27	438.51	439.25	268446.0
2023-08-23 09:30:00	SPY	ETF	439.25	440.62	439.1	440.3701	5780232.0
2023-08-23 10:00:00	SPY	ETF	440.37	441.18	440.21	440.9	4897849.0
2023-08-23 10:30:00	SPY	ETF	440.89	442.0	440.64	441.92	3714492.0
2023-08-23 11:00:00	SPY	ETF	441.925	442.3	441.52	442.15	2852357.0
2023-08-23 11:30:00	SPY	ETF	442.16	442.395	441.69	442.3	3135324.0
2023-08-23 12:00:00	SPY	ETF	442.295	442.34	441.92	442.07	1784294.0
2023-08-23 12:30:00	SPY	ETF	442.085	442.67	441.96	442.2001	1796253.0
2023-08-23 13:00:00	SPY	ETF	442.2	443.295	442.13	443.22	2532398.0
2023-08-23 13:30:00	SPY	ETF	443.23	443.67	443.18	443.55	2929950.0
2023-08-23 14:00:00	SPY	ETF	443.555	443.58	442.68	442.9599	2711971.0
2023-08-23 14:30:00	SPY	ETF	442.96	443.03	442.46	442.7075	1920106.0
2023-08-23 15:00:00	SPY	ETF	442.7	443.22	442.39	443.2	2754374.0
2023-08-23 15:30:00	SPY	ETF	443.19	443.44	442.45	442.97	9894770.0
2023-08-23 16:00:00	SPY	ETF	442.98	445.01	442.68	444.53	3094016.0
2023-08-23 16:30:00	SPY	ETF	444.55	445.73	444.25	445.72	654200.0
2023-08-23 17:00:00	SPY	ETF	445.59	445.79	445.55	445.58	140727.0
2023-08-23 17:30:00	SPY	ETF	445.5633	445.64	445.38	445.45	38280.0
2023-08-23 18:00:00	SPY	ETF	445.38	445.38	444.66	444.98	101346.0
2023-08-23 18:30:00	SPY	ETF	444.97	445.1399	444.82	445.08	40967.0
2023-08-23 19:00:00	SPY	ETF	445.1	445.22	445.04	445.13	24838.0
2023-08-23 19:30:00	SPY	ETF	445.11	445.12	444.95	445.09	33987.0
2023-08-23 04:00:00	QQQ	ETF	365.61	366.35	365.36	366.15	34944.0
2023-08-23 04:30:00	QQQ	ETF	366.15	366.15	365.9	365.96	15714.0
2023-08-23 05:00:00	QQQ	ETF	366.05	366.21	365.51	365.63	16797.0
2023-08-23 05:30:00	QQQ	ETF	365.72	365.91	365.66	365.73	17019.0
2023-08-23 06:00:00	QQQ	ETF	365.68	365.7	365.32	365.32	12787.0
2023-08-23 06:30:00	QQQ	ETF	365.31	365.41	364.66	364.83	19686.0
2023-08-23 07:00:00	QQQ	ETF	364.83	364.92	363.4	363.6	216865.0
2023-08-23 07:30:00	QQQ	ETF	363.59	364.03	363.52	364.0	102872.0
2023-08-23 08:00:00	QQQ	ETF	364.82	366.2096	363.39	363.55	330224.0
2023-08-23 08:30:00	QQQ	ETF	363.57	364.42	363.55	363.985	229657.0
2023-08-23 09:00:00	QQQ	ETF	363.99	364.82	363.99	364.56	317013.0
2023-08-23 09:30:00	QQQ	ETF	364.58	366.92	364.36	366.602	4931191.0
2023-08-23 10:00:00	QQQ	ETF	366.6	367.855	366.35	367.45	3387967.0
2023-08-23 10:30:00	QQQ	ETF	367.44	368.81	367.37	368.66	2962240.0
2023-08-23 11:00:00	QQQ	ETF	368.67	369.15	368.38	368.945	2505904.0
2023-08-23 11:30:00	QQQ	ETF	368.99	369.34	368.46	369.198	2360393.0
2023-08-23 12:00:00	QQQ	ETF	369.2	369.24	368.43	368.57	1382763.0
2023-08-23 12:30:00	QQQ	ETF	368.6	369.23	368.45	368.65	1153655.0

> showing 50 of 28,296 rows — these rows as CSV

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