PREVIEW / etf_30min / 2022-02-18

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-02-18.parquet
  size:    660 KB
  rows:    26,183

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-02-18 04:00:00	SPY	ETF	439.44	439.68	437.8	439.1	21985.0
2022-02-18 04:30:00	SPY	ETF	439.22	439.51	439.02	439.51	3660.0
2022-02-18 05:00:00	SPY	ETF	439.51	439.55	439.15	439.45	15053.0
2022-02-18 05:30:00	SPY	ETF	439.32	439.5	439.19	439.19	5400.0
2022-02-18 06:00:00	SPY	ETF	439.09	439.51	439.04	439.4	9579.0
2022-02-18 06:30:00	SPY	ETF	439.38	439.39	438.39	438.82	60828.0
2022-02-18 07:00:00	SPY	ETF	438.86	439.34	438.4	439.26	199534.0
2022-02-18 07:30:00	SPY	ETF	439.16	439.46	439.12	439.36	82368.0
2022-02-18 08:00:00	SPY	ETF	439.33	440.0	436.55	436.76	676108.0
2022-02-18 08:30:00	SPY	ETF	436.73	437.39	435.67	437.14	685579.0
2022-02-18 09:00:00	SPY	ETF	437.16	437.7	436.32	437.33	623902.0
2022-02-18 09:30:00	SPY	ETF	437.33	438.66	435.91	438.36	8469815.0
2022-02-18 10:00:00	SPY	ETF	438.39	438.66	436.71	436.87	4735185.0
2022-02-18 10:30:00	SPY	ETF	436.87	436.87	435.21	435.47	5496647.0
2022-02-18 11:00:00	SPY	ETF	435.48	435.6	433.5915	435.04	7054110.0
2022-02-18 11:30:00	SPY	ETF	435.03	435.5899	432.88	433.21	3613562.0
2022-02-18 12:00:00	SPY	ETF	433.19	435.04	432.84	434.08	3615045.0
2022-02-18 12:30:00	SPY	ETF	434.06	434.58	432.41	432.48	5090901.0
2022-02-18 13:00:00	SPY	ETF	432.49	433.27	431.82	432.56	4497439.0
2022-02-18 13:30:00	SPY	ETF	432.56	434.36	432.4	433.95	3872882.0
2022-02-18 14:00:00	SPY	ETF	433.94	436.38	433.705	436.2	5409840.0
2022-02-18 14:30:00	SPY	ETF	436.2	437.08	434.74	436.6648	6785324.0
2022-02-18 15:00:00	SPY	ETF	436.64	437.4095	434.2	434.3157	6800929.0
2022-02-18 15:30:00	SPY	ETF	434.31	435.56	432.8	434.27	16052762.0
2022-02-18 16:00:00	SPY	ETF	434.26	435.28	434.0571	435.01	5089743.0
2022-02-18 16:30:00	SPY	ETF	435.01	435.14	434.01	434.1	649161.0
2022-02-18 17:00:00	SPY	ETF	434.12	434.23	433.82	433.85	285114.0
2022-02-18 17:30:00	SPY	ETF	433.82	433.89	432.7	432.95	79057.0
2022-02-18 18:00:00	SPY	ETF	433.0	433.27	432.23	432.6	72512.0
2022-02-18 18:30:00	SPY	ETF	432.5	432.59	432.1	432.43	25024.0
2022-02-18 19:00:00	SPY	ETF	432.46	432.5	432.16	432.16	18232.0
2022-02-18 19:30:00	SPY	ETF	432.25	432.35	432.12	432.22	80988.0
2022-02-18 04:00:00	QQQ	ETF	347.57	347.88	346.97	347.4	47990.0
2022-02-18 04:30:00	QQQ	ETF	347.48	348.0	347.25	347.95	229894.0
2022-02-18 05:00:00	QQQ	ETF	347.99	348.0	347.49	347.96	29760.0
2022-02-18 05:30:00	QQQ	ETF	347.93	348.17	347.76	347.76	26975.0
2022-02-18 06:00:00	QQQ	ETF	347.8	348.1	347.65	347.87	27002.0
2022-02-18 06:30:00	QQQ	ETF	347.82	347.93	346.98	347.36	44727.0
2022-02-18 07:00:00	QQQ	ETF	347.43	347.74	347.2	347.56	153089.0
2022-02-18 07:30:00	QQQ	ETF	347.52	347.91	347.47	347.82	198317.0
2022-02-18 08:00:00	QQQ	ETF	347.5	348.04	345.18	345.42	479915.0
2022-02-18 08:30:00	QQQ	ETF	345.39	345.9399	344.6	345.83	412342.0
2022-02-18 09:00:00	QQQ	ETF	345.81	346.5	345.3	346.39	1204804.0
2022-02-18 09:30:00	QQQ	ETF	346.41	346.81	343.57	345.92	6616635.0
2022-02-18 10:00:00	QQQ	ETF	345.92	346.1799	343.53	343.79	4007991.0
2022-02-18 10:30:00	QQQ	ETF	343.78	343.78	342.24	342.65	4158637.0
2022-02-18 11:00:00	QQQ	ETF	342.63	342.77	340.861	342.2228	4869572.0
2022-02-18 11:30:00	QQQ	ETF	342.22	342.98	340.51	340.83	3191800.0
2022-02-18 12:00:00	QQQ	ETF	340.81	342.81	340.65	341.69	2656769.0
2022-02-18 12:30:00	QQQ	ETF	341.68	342.24	339.97	340.06	3306853.0

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

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