PREVIEW / etf_30min / 2022-04-20

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-04-20.parquet
  size:    672 KB
  rows:    26,820

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-04-20 04:00:00	SPY	ETF	443.34	443.39	442.72	443.39	22049.0
2022-04-20 04:30:00	SPY	ETF	443.26	443.9	443.18	443.8	82558.0
2022-04-20 05:00:00	SPY	ETF	443.95	444.77	443.85	444.69	8105.0
2022-04-20 05:30:00	SPY	ETF	444.57	445.16	444.57	445.12	58237.0
2022-04-20 06:00:00	SPY	ETF	445.06	445.37	444.8	445.32	27756.0
2022-04-20 06:30:00	SPY	ETF	445.4	445.62	445.18	445.48	19421.0
2022-04-20 07:00:00	SPY	ETF	445.33	445.35	445.0	445.24	94918.0
2022-04-20 07:30:00	SPY	ETF	445.25	446.93	445.14	446.87	193902.0
2022-04-20 08:00:00	SPY	ETF	446.04	447.02	443.0	446.93	267931.0
2022-04-20 08:30:00	SPY	ETF	446.92	447.17	446.58	447.16	291383.0
2022-04-20 09:00:00	SPY	ETF	447.14	447.16	446.52	446.9096	339808.0
2022-04-20 09:30:00	SPY	ETF	446.91	447.57	444.41	445.02	7956079.0
2022-04-20 10:00:00	SPY	ETF	445.0089	446.03	444.37	445.81	4415205.0
2022-04-20 10:30:00	SPY	ETF	445.83	447.25	445.35	446.93	4204974.0
2022-04-20 11:00:00	SPY	ETF	446.93	446.97	445.06	445.59	3133280.0
2022-04-20 11:30:00	SPY	ETF	445.61	446.56	445.41	446.03	2471426.0
2022-04-20 12:00:00	SPY	ETF	446.02	446.32	444.795	445.06	2682137.0
2022-04-20 12:30:00	SPY	ETF	445.03	446.68	444.95	446.2799	2516091.0
2022-04-20 13:00:00	SPY	ETF	446.26	446.92	445.88	446.155	2782417.0
2022-04-20 13:30:00	SPY	ETF	446.15	447.19	445.9	446.61	2222514.0
2022-04-20 14:00:00	SPY	ETF	446.6	446.89	445.34	445.39	2204805.0
2022-04-20 14:30:00	SPY	ETF	445.4	445.49	443.48	444.01	4044217.0
2022-04-20 15:00:00	SPY	ETF	444.01	445.89	443.89	445.47	3655660.0
2022-04-20 15:30:00	SPY	ETF	445.475	446.39	444.42	444.68	8522037.0
2022-04-20 16:00:00	SPY	ETF	444.66	446.16	444.53	445.49	2713962.0
2022-04-20 16:30:00	SPY	ETF	445.51	446.05	445.51	446.0	138132.0
2022-04-20 17:00:00	SPY	ETF	445.94	446.11	445.75	445.91	69566.0
2022-04-20 17:30:00	SPY	ETF	445.931	446.04	445.931	445.96	11676.0
2022-04-20 18:00:00	SPY	ETF	445.96	446.27	445.9	446.17	80154.0
2022-04-20 18:30:00	SPY	ETF	446.23	446.44	445.89	445.98	93444.0
2022-04-20 19:00:00	SPY	ETF	446.0	446.0401	445.9	446.0401	18779.0
2022-04-20 19:30:00	SPY	ETF	446.09	446.4	446.03	446.19	52258.0
2022-04-20 04:00:00	QQQ	ETF	343.52	343.88	343.04	343.81	59377.0
2022-04-20 04:30:00	QQQ	ETF	343.79	344.66	343.68	344.58	126689.0
2022-04-20 05:00:00	QQQ	ETF	344.66	345.71	344.5	345.52	115751.0
2022-04-20 05:30:00	QQQ	ETF	345.52	346.19	345.46	346.02	129383.0
2022-04-20 06:00:00	QQQ	ETF	345.91	346.03	345.43	346.02	78867.0
2022-04-20 06:30:00	QQQ	ETF	345.98	346.2	345.7	345.85	75073.0
2022-04-20 07:00:00	QQQ	ETF	345.85	345.89	345.49	345.8	144269.0
2022-04-20 07:30:00	QQQ	ETF	345.83	348.21	345.64	348.05	429595.0
2022-04-20 08:00:00	QQQ	ETF	345.5701	348.16	342.51	347.96	698893.0
2022-04-20 08:30:00	QQQ	ETF	347.952	348.08	347.33	348.06	398606.0
2022-04-20 09:00:00	QQQ	ETF	348.06	348.08	347.0	347.2	556556.0
2022-04-20 09:30:00	QQQ	ETF	347.09	347.56	342.56	343.0899	7971820.0
2022-04-20 10:00:00	QQQ	ETF	343.07	343.9701	341.9	343.64	6190604.0
2022-04-20 10:30:00	QQQ	ETF	343.65	344.58	342.95	344.12	4083946.0
2022-04-20 11:00:00	QQQ	ETF	344.11	344.19	341.65	342.03	3873835.0
2022-04-20 11:30:00	QQQ	ETF	342.08	343.1	341.53	342.0899	2901724.0
2022-04-20 12:00:00	QQQ	ETF	342.07	342.48	340.5007	341.01	2755679.0
2022-04-20 12:30:00	QQQ	ETF	340.99	342.75	340.89	342.305	2489945.0

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

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