PREVIEW / etf_30min / 2022-04-19

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-19.parquet
  size:    675 KB
  rows:    26,470

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-04-19 04:00:00	SPY	ETF	438.99	439.5	438.99	439.45	15346.0
2022-04-19 04:30:00	SPY	ETF	439.32	439.51	437.39	437.39	66837.0
2022-04-19 05:00:00	SPY	ETF	437.46	437.46	436.52	436.67	103276.0
2022-04-19 05:30:00	SPY	ETF	436.56	436.94	436.38	436.42	39481.0
2022-04-19 06:00:00	SPY	ETF	436.79	437.3	436.44	437.22	34036.0
2022-04-19 06:30:00	SPY	ETF	437.19	437.54	437.01	437.54	16577.0
2022-04-19 07:00:00	SPY	ETF	437.59	438.04	437.51	437.7	65169.0
2022-04-19 07:30:00	SPY	ETF	437.73	438.2	437.32	438.11	81343.0
2022-04-19 08:00:00	SPY	ETF	437.5	439.95	436.5796	438.12	150759.0
2022-04-19 08:30:00	SPY	ETF	438.1199	438.42	437.57	437.71	337551.0
2022-04-19 09:00:00	SPY	ETF	437.7	437.93	436.9	437.83	492620.0
2022-04-19 09:30:00	SPY	ETF	437.86	441.4599	437.68	441.42	6789264.0
2022-04-19 10:00:00	SPY	ETF	441.4	442.88	441.15	442.72	5505620.0
2022-04-19 10:30:00	SPY	ETF	442.712	443.85	442.49	443.16	4462740.0
2022-04-19 11:00:00	SPY	ETF	443.16	443.89	442.76	443.72	3551972.0
2022-04-19 11:30:00	SPY	ETF	443.72	444.28	443.27	443.71	3000682.0
2022-04-19 12:00:00	SPY	ETF	443.72	444.03	443.39	443.5655	2163138.0
2022-04-19 12:30:00	SPY	ETF	443.57	443.7498	443.09	443.3801	2214297.0
2022-04-19 13:00:00	SPY	ETF	443.375	443.67	442.65	442.695	1738892.0
2022-04-19 13:30:00	SPY	ETF	442.7	443.87	442.6799	443.57	2231239.0
2022-04-19 14:00:00	SPY	ETF	443.57	443.66	442.44	442.9896	2688936.0
2022-04-19 14:30:00	SPY	ETF	442.9855	443.86	442.77	443.785	2482110.0
2022-04-19 15:00:00	SPY	ETF	443.78	445.35	443.53	445.11	4415434.0
2022-04-19 15:30:00	SPY	ETF	445.13	445.8	444.23	445.01	14449968.0
2022-04-19 16:00:00	SPY	ETF	444.99	445.11	442.52	443.23	5041417.0
2022-04-19 16:30:00	SPY	ETF	443.21	443.4	443.17	443.2	252336.0
2022-04-19 17:00:00	SPY	ETF	443.25	443.25	443.02	443.05	71699.0
2022-04-19 17:30:00	SPY	ETF	443.0499	443.15	442.94	443.06	81364.0
2022-04-19 18:00:00	SPY	ETF	443.11	443.6	443.01	443.49	81555.0
2022-04-19 18:30:00	SPY	ETF	443.6	443.92	443.55	443.61	85165.0
2022-04-19 19:00:00	SPY	ETF	443.61	443.61	443.14	443.28	53900.0
2022-04-19 19:30:00	SPY	ETF	443.19	443.55	443.1	443.42	24253.0
2022-04-19 04:00:00	QQQ	ETF	340.46	340.46	339.65	340.13	74358.0
2022-04-19 04:30:00	QQQ	ETF	340.02	340.02	337.66	337.75	124308.0
2022-04-19 05:00:00	QQQ	ETF	337.74	337.89	337.04	337.26	136090.0
2022-04-19 05:30:00	QQQ	ETF	337.07	337.7	336.9	337.6	63627.0
2022-04-19 06:00:00	QQQ	ETF	337.67	338.27	337.21	338.11	47551.0
2022-04-19 06:30:00	QQQ	ETF	338.06	338.45	337.93	338.38	78114.0
2022-04-19 07:00:00	QQQ	ETF	338.4	338.91	338.32	338.51	171746.0
2022-04-19 07:30:00	QQQ	ETF	338.52	339.28	338.16	339.11	141114.0
2022-04-19 08:00:00	QQQ	ETF	337.3196	341.33	337.1696	339.25	336556.0
2022-04-19 08:30:00	QQQ	ETF	339.24	339.56	338.25	338.53	363248.0
2022-04-19 09:00:00	QQQ	ETF	338.51	338.69	337.32	338.07	489992.0
2022-04-19 09:30:00	QQQ	ETF	338.03	341.46	336.98	341.41	6570437.0
2022-04-19 10:00:00	QQQ	ETF	341.39	343.38	341.03	342.995	4675660.0
2022-04-19 10:30:00	QQQ	ETF	342.985	344.74	342.94	344.29	2905222.0
2022-04-19 11:00:00	QQQ	ETF	344.3	345.14	343.81	345.06	2531312.0
2022-04-19 11:30:00	QQQ	ETF	345.05	345.78	344.69	345.24	2308969.0
2022-04-19 12:00:00	QQQ	ETF	345.27	345.3	344.575	344.65	1930421.0
2022-04-19 12:30:00	QQQ	ETF	344.66	345.13	344.24	344.81	1788745.0

> showing 50 of 26,470 rows — these rows as CSV

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