PREVIEW / etf_30min / 2022-01-28

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-28.parquet
  size:    686 KB
  rows:    27,404

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-01-28 04:00:00	SPY	ETF	432.21	432.69	431.19	432.34	12663.0
2022-01-28 04:30:00	SPY	ETF	431.84	432.44	431.35	431.35	4919.0
2022-01-28 05:00:00	SPY	ETF	431.42	431.42	430.21	430.75	23319.0
2022-01-28 05:30:00	SPY	ETF	430.71	430.73	429.91	430.48	30708.0
2022-01-28 06:00:00	SPY	ETF	430.62	430.63	428.68	429.98	98124.0
2022-01-28 06:30:00	SPY	ETF	429.96	430.28	428.96	429.58	32957.0
2022-01-28 07:00:00	SPY	ETF	429.88	430.16	427.39	428.1	208865.0
2022-01-28 07:30:00	SPY	ETF	427.92	428.43	426.2	427.33	269833.0
2022-01-28 08:00:00	SPY	ETF	429.6799	434.1	426.27	427.55	566685.0
2022-01-28 08:30:00	SPY	ETF	427.7	431.67	427.42	430.72	1194224.0
2022-01-28 09:00:00	SPY	ETF	430.84	432.7	429.88	432.69	631206.0
2022-01-28 09:30:00	SPY	ETF	432.7	433.15	427.88	428.49	13840397.0
2022-01-28 10:00:00	SPY	ETF	428.5	432.36	427.82	430.71	8825045.0
2022-01-28 10:30:00	SPY	ETF	430.76	433.48	429.08	433.42	7970535.0
2022-01-28 11:00:00	SPY	ETF	433.45	435.74	432.08	435.0	8035060.0
2022-01-28 11:30:00	SPY	ETF	435.0	437.08	434.24	436.92	8206389.0
2022-01-28 12:00:00	SPY	ETF	436.94	437.55	435.26	435.51	6112263.0
2022-01-28 12:30:00	SPY	ETF	435.53	436.15	434.2	434.58	4885264.0
2022-01-28 13:00:00	SPY	ETF	434.57	436.54	434.44	435.62	4814490.0
2022-01-28 13:30:00	SPY	ETF	435.62	436.94	435.62	436.2	5151963.0
2022-01-28 14:00:00	SPY	ETF	436.2	437.19	432.39	432.59	6595658.0
2022-01-28 14:30:00	SPY	ETF	432.62	436.31	431.83	436.06	7315900.0
2022-01-28 15:00:00	SPY	ETF	436.08	437.83	435.59	437.2368	7791078.0
2022-01-28 15:30:00	SPY	ETF	437.24	442.0	436.0	441.9	24674293.0
2022-01-28 16:00:00	SPY	ETF	441.89	442.09	440.75	441.55	6576785.0
2022-01-28 16:30:00	SPY	ETF	441.5	441.95	441.29	441.41	1224176.0
2022-01-28 17:00:00	SPY	ETF	441.58	441.73	441.29	441.7	115681.0
2022-01-28 17:30:00	SPY	ETF	441.7	441.95	441.65	441.69	427262.0
2022-01-28 18:00:00	SPY	ETF	441.69	441.75	441.6	441.66	17072.0
2022-01-28 18:30:00	SPY	ETF	441.95	442.74	441.67	442.1	55036.0
2022-01-28 19:00:00	SPY	ETF	442.05	442.18	441.94	442.0	15493.0
2022-01-28 19:30:00	SPY	ETF	442.01	442.49	442.0	442.3	27268.0
2022-01-28 04:00:00	QQQ	ETF	343.22	344.07	342.32	343.22	106095.0
2022-01-28 04:30:00	QQQ	ETF	343.27	343.75	342.44	342.79	101895.0
2022-01-28 05:00:00	QQQ	ETF	342.76	342.77	341.76	342.25	79323.0
2022-01-28 05:30:00	QQQ	ETF	342.3	342.38	341.33	341.87	51751.0
2022-01-28 06:00:00	QQQ	ETF	342.29	342.34	340.18	341.23	113219.0
2022-01-28 06:30:00	QQQ	ETF	341.26	341.4	340.32	340.91	106293.0
2022-01-28 07:00:00	QQQ	ETF	341.05	341.71	339.05	339.8	348221.0
2022-01-28 07:30:00	QQQ	ETF	339.72	340.0	337.3	338.36	537626.0
2022-01-28 08:00:00	QQQ	ETF	338.41	345.14	337.32	338.31	749734.0
2022-01-28 08:30:00	QQQ	ETF	338.48	342.52	338.48	341.46	1445142.0
2022-01-28 09:00:00	QQQ	ETF	341.6	343.0	340.68	343.0	377003.0
2022-01-28 09:30:00	QQQ	ETF	343.03	343.84	338.08	338.92	8664213.0
2022-01-28 10:00:00	QQQ	ETF	338.95	342.495	337.95	340.675	6236085.0
2022-01-28 10:30:00	QQQ	ETF	340.7	344.9	339.51	344.8588	5399201.0
2022-01-28 11:00:00	QQQ	ETF	344.86	347.61	343.45	346.66	7364599.0
2022-01-28 11:30:00	QQQ	ETF	346.71	348.57	345.81	348.37	5558518.0
2022-01-28 12:00:00	QQQ	ETF	348.39	348.91	346.55	346.76	4799031.0
2022-01-28 12:30:00	QQQ	ETF	346.83	347.87	345.85	346.08	4250940.0

> showing 50 of 27,404 rows — these rows as CSV

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