PREVIEW / etf_30min / 2022-03-18

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-18.parquet
  size:    671 KB
  rows:    26,472

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-03-18 04:00:00	SPY	ETF	438.0	438.05	437.4	437.49	13932.0
2022-03-18 04:30:00	SPY	ETF	437.28	437.39	436.57	437.08	19803.0
2022-03-18 05:00:00	SPY	ETF	437.2	437.23	436.25	436.61	24671.0
2022-03-18 05:30:00	SPY	ETF	436.69	437.2	436.48	437.06	22080.0
2022-03-18 06:00:00	SPY	ETF	436.92	437.29	436.41	436.82	28444.0
2022-03-18 06:30:00	SPY	ETF	436.7	436.8	436.05	436.51	24375.0
2022-03-18 07:00:00	SPY	ETF	436.57	436.57	435.71	436.13	176419.0
2022-03-18 07:30:00	SPY	ETF	436.17	436.83	436.1	436.139	196323.0
2022-03-18 08:00:00	SPY	ETF	436.201	438.3	435.76	436.93	332698.0
2022-03-18 08:30:00	SPY	ETF	436.87	437.25	436.11	436.66	347539.0
2022-03-18 09:00:00	SPY	ETF	436.66	440.8241	436.23	438.05	607047.0
2022-03-18 09:30:00	SPY	ETF	438.0	439.18	437.22	439.0401	7117860.0
2022-03-18 10:00:00	SPY	ETF	439.07	440.89	438.75	439.74	5625919.0
2022-03-18 10:30:00	SPY	ETF	439.74	440.2	438.43	439.5	3708701.0
2022-03-18 11:00:00	SPY	ETF	439.51	440.59	439.32	439.69	3851161.0
2022-03-18 11:30:00	SPY	ETF	439.69	440.97	439.15	439.9417	3727020.0
2022-03-18 12:00:00	SPY	ETF	439.96	441.01	439.5328	440.99	2685882.0
2022-03-18 12:30:00	SPY	ETF	440.98	441.72	440.83	441.4214	3245667.0
2022-03-18 13:00:00	SPY	ETF	441.44	442.3	441.21	442.28	2600483.0
2022-03-18 13:30:00	SPY	ETF	442.28	442.52	441.8	442.035	2722586.0
2022-03-18 14:00:00	SPY	ETF	442.04	442.46	441.48	442.185	3048215.0
2022-03-18 14:30:00	SPY	ETF	442.175	442.69	441.75	442.5524	3241039.0
2022-03-18 15:00:00	SPY	ETF	442.55	444.2301	442.34	444.03	4667446.0
2022-03-18 15:30:00	SPY	ETF	444.04	444.86	443.67	444.47	14617343.0
2022-03-18 16:00:00	SPY	ETF	444.47	445.62	444.0	445.35	5409383.0
2022-03-18 16:30:00	SPY	ETF	445.35	445.66	444.52	445.6	583604.0
2022-03-18 17:00:00	SPY	ETF	445.6	445.67	445.0	445.08	207708.0
2022-03-18 17:30:00	SPY	ETF	445.03	445.39	444.52	445.22	761315.0
2022-03-18 18:00:00	SPY	ETF	445.22	445.39	445.2	445.23	29664.0
2022-03-18 18:30:00	SPY	ETF	445.24	445.5	445.23	445.3	29524.0
2022-03-18 19:00:00	SPY	ETF	445.38	445.4099	444.6	445.3	11931.0
2022-03-18 19:30:00	SPY	ETF	445.15	445.49	445.06	445.49	21274.0
2022-03-18 04:00:00	QQQ	ETF	342.58	342.72	342.05	342.39	59094.0
2022-03-18 04:30:00	QQQ	ETF	342.51	342.51	341.56	342.2	60168.0
2022-03-18 05:00:00	QQQ	ETF	342.18	342.18	341.47	341.8	30628.0
2022-03-18 05:30:00	QQQ	ETF	341.99	342.4	341.76	342.2	27628.0
2022-03-18 06:00:00	QQQ	ETF	342.12	342.39	341.72	342.04	15549.0
2022-03-18 06:30:00	QQQ	ETF	341.92	341.92	341.4	341.72	58902.0
2022-03-18 07:00:00	QQQ	ETF	341.75	341.75	341.0	341.37	124372.0
2022-03-18 07:30:00	QQQ	ETF	341.38	341.76	341.33	341.33	110221.0
2022-03-18 08:00:00	QQQ	ETF	341.52	344.18	341.0	341.82	260272.0
2022-03-18 08:30:00	QQQ	ETF	341.78	342.18	341.01	341.65	272044.0
2022-03-18 09:00:00	QQQ	ETF	341.57	342.99	341.34	342.8	1420335.0
2022-03-18 09:30:00	QQQ	ETF	342.74	345.24	341.55	345.21	5570788.0
2022-03-18 10:00:00	QQQ	ETF	345.28	347.49	345.0	346.58	5753666.0
2022-03-18 10:30:00	QQQ	ETF	346.63	347.019	344.895	346.56	4335465.0
2022-03-18 11:00:00	QQQ	ETF	346.58	347.9099	346.38	347.07	3412832.0
2022-03-18 11:30:00	QQQ	ETF	347.06	348.24	346.65	347.36	3226056.0
2022-03-18 12:00:00	QQQ	ETF	347.39	348.215	346.98	348.18	2030161.0
2022-03-18 12:30:00	QQQ	ETF	348.17	349.07	348.01	348.72	2460710.0

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

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