PREVIEW / etf_30min / 2023-05-19

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-19.parquet
  size:    667 KB
  rows:    26,960

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
2023-05-19 04:00:00	SPY	ETF	419.74	419.9	419.57	419.79	27773.0
2023-05-19 04:30:00	SPY	ETF	420.0	420.34	419.97	420.2	25806.0
2023-05-19 05:00:00	SPY	ETF	420.19	420.19	419.88	419.97	4716.0
2023-05-19 05:30:00	SPY	ETF	419.88	420.1	419.86	420.01	7738.0
2023-05-19 06:00:00	SPY	ETF	420.0	420.0	419.58	419.85	48739.0
2023-05-19 06:30:00	SPY	ETF	419.84	419.87	419.7	419.76	15448.0
2023-05-19 07:00:00	SPY	ETF	419.75	420.68	419.75	420.34	75815.0
2023-05-19 07:30:00	SPY	ETF	420.41	420.61	420.07	420.37	87904.0
2023-05-19 08:00:00	SPY	ETF	419.7882	420.62	419.75	420.57	184981.0
2023-05-19 08:30:00	SPY	ETF	420.6	420.87	420.42	420.81	106773.0
2023-05-19 09:00:00	SPY	ETF	420.75	420.79	420.01	420.11	179211.0
2023-05-19 09:30:00	SPY	ETF	420.17	420.72	419.8	420.55	5745733.0
2023-05-19 10:00:00	SPY	ETF	420.56	420.67	419.88	420.57	3706085.0
2023-05-19 10:30:00	SPY	ETF	420.55	420.72	419.88	420.33	3325164.0
2023-05-19 11:00:00	SPY	ETF	420.335	420.555	418.51	418.52	8174093.0
2023-05-19 11:30:00	SPY	ETF	418.5	419.18	417.35	418.515	9254002.0
2023-05-19 12:00:00	SPY	ETF	418.52	418.8699	417.91	418.22	3730771.0
2023-05-19 12:30:00	SPY	ETF	418.21	418.94	417.5	418.6788	3554718.0
2023-05-19 13:00:00	SPY	ETF	418.68	419.06	418.55	418.76	2212079.0
2023-05-19 13:30:00	SPY	ETF	418.77	418.88	417.9642	418.005	2513164.0
2023-05-19 14:00:00	SPY	ETF	418.01	418.46	417.47	417.8782	3882120.0
2023-05-19 14:30:00	SPY	ETF	417.855	418.71	417.685	418.67	3126356.0
2023-05-19 15:00:00	SPY	ETF	418.67	418.72	418.145	418.1829	3077052.0
2023-05-19 15:30:00	SPY	ETF	418.185	418.99	417.99	418.61	8674576.0
2023-05-19 16:00:00	SPY	ETF	418.61	418.73	417.9	417.9	2973685.0
2023-05-19 16:30:00	SPY	ETF	417.87	418.05	417.78	417.99	243366.0
2023-05-19 17:00:00	SPY	ETF	418.06	418.62	417.95	418.01	180518.0
2023-05-19 17:30:00	SPY	ETF	418.07	418.62	418.03	418.12	115622.0
2023-05-19 18:00:00	SPY	ETF	418.12	418.5	418.08	418.34	86157.0
2023-05-19 18:30:00	SPY	ETF	418.38	418.5	418.35	418.5	28979.0
2023-05-19 19:00:00	SPY	ETF	418.49	418.5	418.39	418.3901	8575.0
2023-05-19 19:30:00	SPY	ETF	418.41	418.6	418.41	418.6	25520.0
2023-05-19 04:00:00	QQQ	ETF	337.3	337.87	337.3	337.8	15936.0
2023-05-19 04:30:00	QQQ	ETF	337.88	338.26	337.88	338.14	14420.0
2023-05-19 05:00:00	QQQ	ETF	338.18	338.18	337.83	337.9	20464.0
2023-05-19 05:30:00	QQQ	ETF	337.84	337.97	337.76	337.89	7307.0
2023-05-19 06:00:00	QQQ	ETF	337.89	338.01	337.61	337.72	34207.0
2023-05-19 06:30:00	QQQ	ETF	337.72	337.75	337.22	337.22	56075.0
2023-05-19 07:00:00	QQQ	ETF	337.25	337.93	337.25	337.81	117053.0
2023-05-19 07:30:00	QQQ	ETF	337.81	337.87	337.25	337.53	148458.0
2023-05-19 08:00:00	QQQ	ETF	337.57	338.07	336.98	337.48	332122.0
2023-05-19 08:30:00	QQQ	ETF	337.5	337.94	337.37	337.86	219304.0
2023-05-19 09:00:00	QQQ	ETF	337.87	338.06	337.29	337.43	342322.0
2023-05-19 09:30:00	QQQ	ETF	337.49	338.205	336.9703	337.42	5029182.0
2023-05-19 10:00:00	QQQ	ETF	337.43	337.8068	336.56	337.465	3812437.0
2023-05-19 10:30:00	QQQ	ETF	337.46	337.7	336.58	337.0493	2954713.0
2023-05-19 11:00:00	QQQ	ETF	337.04	337.46	336.38	336.39	4731332.0
2023-05-19 11:30:00	QQQ	ETF	336.37	337.16	335.59	336.575	4462118.0
2023-05-19 12:00:00	QQQ	ETF	336.58	336.91	335.89	336.23	2523272.0
2023-05-19 12:30:00	QQQ	ETF	336.2	336.5401	335.6	336.32	2329281.0

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

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