PREVIEW / etf_30min / 2021-09-28

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-28.parquet
  size:    663 KB
  rows:    25,566

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
2021-09-28 04:00:00	SPY	ETF	442.0	442.0	439.03	439.57	52260.0
2021-09-28 04:30:00	SPY	ETF	439.63	439.99	439.61	439.84	24808.0
2021-09-28 05:00:00	SPY	ETF	439.84	440.2	439.5	440.06	7952.0
2021-09-28 05:30:00	SPY	ETF	439.97	440.05	438.55	438.58	26956.0
2021-09-28 06:00:00	SPY	ETF	438.66	439.0	438.35	438.95	58282.0
2021-09-28 06:30:00	SPY	ETF	438.9	439.3	438.77	438.77	67916.0
2021-09-28 07:00:00	SPY	ETF	438.73	439.31	438.36	438.76	119118.0
2021-09-28 07:30:00	SPY	ETF	438.78	439.9	438.73	439.61	216077.0
2021-09-28 08:00:00	SPY	ETF	439.64	442.03	438.3096	439.17	409575.0
2021-09-28 08:30:00	SPY	ETF	439.19	439.41	438.56	439.05	268175.0
2021-09-28 09:00:00	SPY	ETF	438.92	440.37	438.9	439.7	605129.0
2021-09-28 09:30:00	SPY	ETF	439.69	440.04	437.2	438.02	10191796.0
2021-09-28 10:00:00	SPY	ETF	438.01	438.01	434.95	435.85	10532968.0
2021-09-28 10:30:00	SPY	ETF	435.84	436.6	434.87	435.65	8012880.0
2021-09-28 11:00:00	SPY	ETF	435.64	436.07	433.8	434.63	6712754.0
2021-09-28 11:30:00	SPY	ETF	434.64	435.05	433.76	434.57	5306471.0
2021-09-28 12:00:00	SPY	ETF	434.57	435.13	433.65	434.64	3637361.0
2021-09-28 12:30:00	SPY	ETF	434.62	434.63	433.07	433.32	4244366.0
2021-09-28 13:00:00	SPY	ETF	433.31	435.0284	432.94	434.69	5206531.0
2021-09-28 13:30:00	SPY	ETF	434.69	434.95	433.68	433.705	3099211.0
2021-09-28 14:00:00	SPY	ETF	433.7	435.24	433.02	435.19	6878283.0
2021-09-28 14:30:00	SPY	ETF	435.18	436.19	434.25	435.855	5859747.0
2021-09-28 15:00:00	SPY	ETF	435.84	436.67	434.79	434.79	7264868.0
2021-09-28 15:30:00	SPY	ETF	434.785	435.58	433.17	433.75	19565917.0
2021-09-28 16:00:00	SPY	ETF	433.75	434.33	433.61	434.07	5231583.0
2021-09-28 16:30:00	SPY	ETF	433.99	443.72	433.8	434.03	235832.0
2021-09-28 17:00:00	SPY	ETF	434.03	434.22	433.96	434.16	31761.0
2021-09-28 17:30:00	SPY	ETF	434.16	434.16	433.96	434.05	73671.0
2021-09-28 18:00:00	SPY	ETF	434.05	443.72	433.72	434.31	1930179.0
2021-09-28 18:30:00	SPY	ETF	433.72	434.63	433.72	434.51	51094.0
2021-09-28 19:00:00	SPY	ETF	434.49	434.69	434.35	434.35	36157.0
2021-09-28 19:30:00	SPY	ETF	434.41	434.9	433.95	434.89	53793.0
2021-09-28 04:00:00	QQQ	ETF	370.0	370.0	364.75	365.46	167206.0
2021-09-28 04:30:00	QQQ	ETF	365.56	366.25	365.56	365.95	59341.0
2021-09-28 05:00:00	QQQ	ETF	365.95	366.34	365.35	366.0	67251.0
2021-09-28 05:30:00	QQQ	ETF	365.88	365.88	364.36	364.48	72398.0
2021-09-28 06:00:00	QQQ	ETF	364.51	365.0	363.85	364.8	127515.0
2021-09-28 06:30:00	QQQ	ETF	364.75	364.98	364.16	364.21	133928.0
2021-09-28 07:00:00	QQQ	ETF	364.26	365.11	363.89	364.32	376276.0
2021-09-28 07:30:00	QQQ	ETF	364.27	365.51	364.13	365.29	204116.0
2021-09-28 08:00:00	QQQ	ETF	364.5899	370.1	363.89	364.72	269611.0
2021-09-28 08:30:00	QQQ	ETF	364.71	364.99	364.31	364.83	259285.0
2021-09-28 09:00:00	QQQ	ETF	364.78	366.16	364.78	365.7	380668.0
2021-09-28 09:30:00	QQQ	ETF	365.67	366.36	363.405	364.49	8121899.0
2021-09-28 10:00:00	QQQ	ETF	364.46	364.46	361.46	362.58	7948734.0
2021-09-28 10:30:00	QQQ	ETF	362.58	362.77	361.25	361.49	7446793.0
2021-09-28 11:00:00	QQQ	ETF	361.47	361.82	360.1	360.53	5888785.0
2021-09-28 11:30:00	QQQ	ETF	360.55	361.265	359.86	360.91	6133951.0
2021-09-28 12:00:00	QQQ	ETF	360.91	361.82	360.15	361.19	4208653.0
2021-09-28 12:30:00	QQQ	ETF	361.18	361.19	359.52	359.78	3379752.0

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

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