PREVIEW / etf_30min / 2022-07-19

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-19.parquet
  size:    652 KB
  rows:    25,704

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-07-19 04:00:00	SPY	ETF	382.62	383.0	382.49	382.68	14521.0
2022-07-19 04:30:00	SPY	ETF	382.66	383.75	382.66	383.61	20044.0
2022-07-19 05:00:00	SPY	ETF	383.56	384.36	383.56	384.34	42183.0
2022-07-19 05:30:00	SPY	ETF	384.39	384.9	384.39	384.6	19446.0
2022-07-19 06:00:00	SPY	ETF	384.64	385.45	384.48	385.17	49810.0
2022-07-19 06:30:00	SPY	ETF	385.22	385.75	385.09	385.25	36462.0
2022-07-19 07:00:00	SPY	ETF	385.19	385.27	384.79	385.05	88057.0
2022-07-19 07:30:00	SPY	ETF	385.09	385.3	384.55	385.12	141752.0
2022-07-19 08:00:00	SPY	ETF	385.14	385.55	382.47	384.26	163604.0
2022-07-19 08:30:00	SPY	ETF	384.25	385.8	384.13	385.59	364665.0
2022-07-19 09:00:00	SPY	ETF	385.57	386.32	385.42	386.08	535107.0
2022-07-19 09:30:00	SPY	ETF	386.08	386.92	385.39	386.8721	5873960.0
2022-07-19 10:00:00	SPY	ETF	386.885	388.19	386.23	388.06	5212458.0
2022-07-19 10:30:00	SPY	ETF	388.06	388.9701	387.72	388.81	3353827.0
2022-07-19 11:00:00	SPY	ETF	388.82	389.55	388.71	389.32	3085442.0
2022-07-19 11:30:00	SPY	ETF	389.32	389.9	388.9304	389.68	2514892.0
2022-07-19 12:00:00	SPY	ETF	389.675	389.81	388.79	389.77	2247016.0
2022-07-19 12:30:00	SPY	ETF	389.78	390.5	389.73	390.4901	2752241.0
2022-07-19 13:00:00	SPY	ETF	390.49	390.52	389.78	390.11	1745628.0
2022-07-19 13:30:00	SPY	ETF	390.13	391.63	390.1	391.5991	3196252.0
2022-07-19 14:00:00	SPY	ETF	391.6	392.34	391.35	391.42	3944054.0
2022-07-19 14:30:00	SPY	ETF	391.42	391.83	391.05	391.7416	3004025.0
2022-07-19 15:00:00	SPY	ETF	391.765	392.16	391.34	391.97	3385654.0
2022-07-19 15:30:00	SPY	ETF	391.96	392.87	391.47	392.25	12875459.0
2022-07-19 16:00:00	SPY	ETF	392.24	393.36	392.09	393.27	4998934.0
2022-07-19 16:30:00	SPY	ETF	393.29	393.35	393.03	393.04	102062.0
2022-07-19 17:00:00	SPY	ETF	393.0	393.35	393.0	393.35	30963.0
2022-07-19 17:30:00	SPY	ETF	393.36	393.38	393.2	393.32	20852.0
2022-07-19 18:00:00	SPY	ETF	393.32	393.33	392.92	392.95	38010.0
2022-07-19 18:30:00	SPY	ETF	392.91	393.03	392.72	393.01	23301.0
2022-07-19 19:00:00	SPY	ETF	393.05	393.17	392.81	392.9	10092.0
2022-07-19 19:30:00	SPY	ETF	392.94	393.07	392.75	393.0	31163.0
2022-07-19 04:00:00	QQQ	ETF	289.56	290.04	289.55	289.98	37303.0
2022-07-19 04:30:00	QQQ	ETF	289.8	290.7	289.8	290.64	23404.0
2022-07-19 05:00:00	QQQ	ETF	290.6	291.27	290.58	291.15	63241.0
2022-07-19 05:30:00	QQQ	ETF	291.15	291.54	291.12	291.29	125121.0
2022-07-19 06:00:00	QQQ	ETF	291.18	291.96	291.12	291.8	62250.0
2022-07-19 06:30:00	QQQ	ETF	291.73	292.28	291.71	291.9	150848.0
2022-07-19 07:00:00	QQQ	ETF	291.9	292.05	291.55	291.87	150716.0
2022-07-19 07:30:00	QQQ	ETF	291.94	292.1	291.47	291.96	93240.0
2022-07-19 08:00:00	QQQ	ETF	291.8296	292.13	289.32	291.32	252385.0
2022-07-19 08:30:00	QQQ	ETF	291.33	292.47	291.305	292.26	273314.0
2022-07-19 09:00:00	QQQ	ETF	292.24	293.17	292.1	293.1	407414.0
2022-07-19 09:30:00	QQQ	ETF	293.14	293.7	291.47	293.25	5468242.0
2022-07-19 10:00:00	QQQ	ETF	293.26	293.92	291.93	293.705	3653817.0
2022-07-19 10:30:00	QQQ	ETF	293.74	295.14	293.5	295.08	2737433.0
2022-07-19 11:00:00	QQQ	ETF	295.08	295.88	295.01	295.71	3099158.0
2022-07-19 11:30:00	QQQ	ETF	295.7	296.3	295.36	296.025	2101627.0
2022-07-19 12:00:00	QQQ	ETF	296.0389	296.185	295.251	296.13	1559708.0
2022-07-19 12:30:00	QQQ	ETF	296.14	296.68	296.06	296.65	2221384.0

> showing 50 of 25,704 rows — these rows as CSV

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