PREVIEW / etf_30min / 2022-03-17

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-03-17.parquet
  size:    681 KB
  rows:    26,752

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-17 04:00:00	SPY	ETF	436.06	436.1	435.33	435.78	16443.0
2022-03-17 04:30:00	SPY	ETF	435.72	435.87	434.62	435.1	23721.0
2022-03-17 05:00:00	SPY	ETF	435.29	435.34	434.6	434.94	8778.0
2022-03-17 05:30:00	SPY	ETF	434.95	434.95	434.18	434.66	8922.0
2022-03-17 06:00:00	SPY	ETF	434.79	434.79	432.65	433.79	101035.0
2022-03-17 06:30:00	SPY	ETF	433.79	434.5	433.74	434.5	108382.0
2022-03-17 07:00:00	SPY	ETF	434.53	434.99	434.03	434.25	148392.0
2022-03-17 07:30:00	SPY	ETF	434.25	434.48	433.62	434.18	143592.0
2022-03-17 08:00:00	SPY	ETF	433.7201	436.69	433.3596	433.95	272257.0
2022-03-17 08:30:00	SPY	ETF	433.91	434.3	433.16	433.74	310316.0
2022-03-17 09:00:00	SPY	ETF	433.67	433.9	433.4	433.57	371604.0
2022-03-17 09:30:00	SPY	ETF	433.59	436.24	433.19	436.1799	7301936.0
2022-03-17 10:00:00	SPY	ETF	436.17	436.97	435.89	436.38	5018313.0
2022-03-17 10:30:00	SPY	ETF	436.38	436.53	433.98	434.78	5359806.0
2022-03-17 11:00:00	SPY	ETF	434.76	435.83	434.28	435.52	3035561.0
2022-03-17 11:30:00	SPY	ETF	435.53	436.45	435.13	436.12	2889297.0
2022-03-17 12:00:00	SPY	ETF	436.14	437.66	435.74	437.54	3018130.0
2022-03-17 12:30:00	SPY	ETF	437.53	437.93	437.1899	437.748	2351029.0
2022-03-17 13:00:00	SPY	ETF	437.755	438.74	436.98	438.69	3092970.0
2022-03-17 13:30:00	SPY	ETF	438.69	439.86	438.5404	439.4359	3649818.0
2022-03-17 14:00:00	SPY	ETF	439.44	439.7	438.26	438.3	4377982.0
2022-03-17 14:30:00	SPY	ETF	438.31	439.55	438.31	439.3822	2939164.0
2022-03-17 15:00:00	SPY	ETF	439.385	439.78	438.08	439.115	4372359.0
2022-03-17 15:30:00	SPY	ETF	439.11	441.06	438.8801	441.0	14228201.0
2022-03-17 16:00:00	SPY	ETF	441.0	441.15	438.63	439.54	5198677.0
2022-03-17 16:30:00	SPY	ETF	439.53	440.8236	438.57	438.92	1362391.0
2022-03-17 17:00:00	SPY	ETF	439.08	439.25	438.95	439.04	60693.0
2022-03-17 17:30:00	SPY	ETF	439.11	439.26	439.03	439.15	71740.0
2022-03-17 18:00:00	SPY	ETF	439.15	439.54	438.44	438.67	247185.0
2022-03-17 18:30:00	SPY	ETF	438.67	438.75	438.25	438.44	108367.0
2022-03-17 19:00:00	SPY	ETF	438.5	438.68	438.29	438.5901	41278.0
2022-03-17 19:30:00	SPY	ETF	438.59	438.75	438.5	438.51	59170.0
2022-03-17 04:00:00	QQQ	ETF	340.73	341.0	339.98	340.56	57657.0
2022-03-17 04:30:00	QQQ	ETF	340.46	340.74	339.47	339.76	48554.0
2022-03-17 05:00:00	QQQ	ETF	339.78	340.03	339.0	339.59	69989.0
2022-03-17 05:30:00	QQQ	ETF	339.6	339.7	338.98	339.55	35027.0
2022-03-17 06:00:00	QQQ	ETF	338.91	338.91	337.5	338.49	161207.0
2022-03-17 06:30:00	QQQ	ETF	338.46	339.43	338.44	339.36	78444.0
2022-03-17 07:00:00	QQQ	ETF	339.38	339.72	338.6	338.81	181355.0
2022-03-17 07:30:00	QQQ	ETF	338.79	339.21	338.3	338.88	148587.0
2022-03-17 08:00:00	QQQ	ETF	339.06	341.54	337.6196	338.5	565460.0
2022-03-17 08:30:00	QQQ	ETF	338.5	338.82	337.41	337.95	489274.0
2022-03-17 09:00:00	QQQ	ETF	337.91	338.42	337.71	338.4	291172.0
2022-03-17 09:30:00	QQQ	ETF	338.37	341.045	337.0406	341.0	7594687.0
2022-03-17 10:00:00	QQQ	ETF	341.0	341.8	339.65	340.2401	5765229.0
2022-03-17 10:30:00	QQQ	ETF	340.265	340.4	337.775	338.47	4059928.0
2022-03-17 11:00:00	QQQ	ETF	338.47	339.8499	337.63	339.43	3063687.0
2022-03-17 11:30:00	QQQ	ETF	339.41	340.34	338.48	339.58	2440205.0
2022-03-17 12:00:00	QQQ	ETF	339.59	340.85	339.13	340.69	2237245.0
2022-03-17 12:30:00	QQQ	ETF	340.67	341.29	340.26	341.05	1730186.0

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

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