PREVIEW / etf_30min / 2022-01-25

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-01-25.parquet
  size:    706 KB
  rows:    27,973

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-25 04:00:00	SPY	ETF	434.95	436.1	433.22	436.1	87121.0
2022-01-25 04:30:00	SPY	ETF	435.94	437.4	435.6	436.89	65295.0
2022-01-25 05:00:00	SPY	ETF	436.91	437.7	436.29	437.14	28382.0
2022-01-25 05:30:00	SPY	ETF	437.1	437.12	434.71	435.19	84453.0
2022-01-25 06:00:00	SPY	ETF	435.1	436.35	435.07	435.48	101846.0
2022-01-25 06:30:00	SPY	ETF	435.35	435.59	433.76	434.2	247655.0
2022-01-25 07:00:00	SPY	ETF	434.17	434.68	433.436	434.2	180725.0
2022-01-25 07:30:00	SPY	ETF	434.07	434.08	432.91	433.39	286500.0
2022-01-25 08:00:00	SPY	ETF	434.14	440.169	431.4	432.0	912508.0
2022-01-25 08:30:00	SPY	ETF	431.93	433.56	431.78	433.16	453099.0
2022-01-25 09:00:00	SPY	ETF	433.18	433.73	432.78	433.12	892210.0
2022-01-25 09:30:00	SPY	ETF	433.06	434.67	428.38	429.14	16373176.0
2022-01-25 10:00:00	SPY	ETF	429.13	432.52	427.15	432.52	11771651.0
2022-01-25 10:30:00	SPY	ETF	432.48	433.98	430.395	431.14	8556208.0
2022-01-25 11:00:00	SPY	ETF	431.08	432.97	429.86	432.17	7350236.0
2022-01-25 11:30:00	SPY	ETF	432.16	432.39	429.24	429.81	6003068.0
2022-01-25 12:00:00	SPY	ETF	429.8	432.84	429.5	432.39	5609482.0
2022-01-25 12:30:00	SPY	ETF	432.37	432.37	430.03	431.55	4197650.0
2022-01-25 13:00:00	SPY	ETF	431.55	433.73	430.12	433.54	4426784.0
2022-01-25 13:30:00	SPY	ETF	433.54	436.39	433.18	436.3093	5656227.0
2022-01-25 14:00:00	SPY	ETF	436.29	437.77	434.91	437.31	6044751.0
2022-01-25 14:30:00	SPY	ETF	437.33	439.72	436.12	439.5	5981280.0
2022-01-25 15:00:00	SPY	ETF	439.49	439.62	435.11	435.47	8294584.0
2022-01-25 15:30:00	SPY	ETF	435.47	436.92	433.44	434.48	19757418.0
2022-01-25 16:00:00	SPY	ETF	434.48	435.17	431.6	431.93	5239209.0
2022-01-25 16:30:00	SPY	ETF	431.9	432.06	429.2	429.95	510967.0
2022-01-25 17:00:00	SPY	ETF	430.1	430.1	429.67	429.94	79497.0
2022-01-25 17:30:00	SPY	ETF	429.9	430.5	429.9	430.4	112074.0
2022-01-25 18:00:00	SPY	ETF	430.4	434.56	430.4	434.53	451046.0
2022-01-25 18:30:00	SPY	ETF	434.47	436.4	434.23	435.16	261232.0
2022-01-25 19:00:00	SPY	ETF	435.17	435.28	433.5	433.5	162362.0
2022-01-25 19:30:00	SPY	ETF	433.19	434.76	432.99	433.59	105299.0
2022-01-25 04:00:00	QQQ	ETF	348.88	349.27	346.11	349.27	255147.0
2022-01-25 04:30:00	QQQ	ETF	349.2	350.49	348.66	349.76	111650.0
2022-01-25 05:00:00	QQQ	ETF	349.83	350.3	349.18	349.55	87567.0
2022-01-25 05:30:00	QQQ	ETF	349.72	349.73	347.53	347.94	62050.0
2022-01-25 06:00:00	QQQ	ETF	347.72	349.02	347.72	348.5	51410.0
2022-01-25 06:30:00	QQQ	ETF	348.41	348.41	346.42	347.1	111431.0
2022-01-25 07:00:00	QQQ	ETF	347.08	347.34	346.16	346.99	151539.0
2022-01-25 07:30:00	QQQ	ETF	346.87	346.9	345.72	346.45	281968.0
2022-01-25 08:00:00	QQQ	ETF	346.92	353.564	344.51	345.05	625522.0
2022-01-25 08:30:00	QQQ	ETF	345.02	346.68	344.84	346.4	411962.0
2022-01-25 09:00:00	QQQ	ETF	346.36	346.86	345.9	346.63	405833.0
2022-01-25 09:30:00	QQQ	ETF	346.62	348.73	342.85	343.76	13928326.0
2022-01-25 10:00:00	QQQ	ETF	343.73	346.45	342.2	346.43	11913504.0
2022-01-25 10:30:00	QQQ	ETF	346.42	347.22	343.93	344.405	9956779.0
2022-01-25 11:00:00	QQQ	ETF	344.38	345.63	342.886	344.39	4926535.0
2022-01-25 11:30:00	QQQ	ETF	344.38	344.6	341.68	342.09	5413159.0
2022-01-25 12:00:00	QQQ	ETF	342.06	344.7483	341.84	344.27	5710056.0
2022-01-25 12:30:00	QQQ	ETF	344.22	344.23	342.1	343.565	3674168.0

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

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