PREVIEW / etf_30min / 2023-06-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-06.parquet
  size:    700 KB
  rows:    27,828

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-06-06 04:00:00	SPY	ETF	427.02	427.52	426.97	426.97	11539.0
2023-06-06 04:30:00	SPY	ETF	426.79	427.06	426.64	426.76	15305.0
2023-06-06 05:00:00	SPY	ETF	426.76	426.9	426.51	426.75	8372.0
2023-06-06 05:30:00	SPY	ETF	426.8	426.96	426.78	426.79	2100.0
2023-06-06 06:00:00	SPY	ETF	426.83	426.83	426.67	426.78	4683.0
2023-06-06 06:30:00	SPY	ETF	426.74	426.94	426.7	426.87	11785.0
2023-06-06 07:00:00	SPY	ETF	426.84	426.99	426.77	426.99	18735.0
2023-06-06 07:30:00	SPY	ETF	427.0	427.14	426.87	426.98	25904.0
2023-06-06 08:00:00	SPY	ETF	426.8416	427.42	426.65	426.66	71820.0
2023-06-06 08:30:00	SPY	ETF	426.72	426.96	426.67	426.87	50925.0
2023-06-06 09:00:00	SPY	ETF	426.88	427.16	426.66	426.66	168360.0
2023-06-06 09:30:00	SPY	ETF	426.67	426.8	425.99	426.6	4501269.0
2023-06-06 10:00:00	SPY	ETF	426.6	427.63	426.51	427.4214	4312277.0
2023-06-06 10:30:00	SPY	ETF	427.43	428.445	427.28	428.09	4495016.0
2023-06-06 11:00:00	SPY	ETF	428.1	428.25	426.86	427.46	3101662.0
2023-06-06 11:30:00	SPY	ETF	427.478	428.28	427.42	428.15	2354786.0
2023-06-06 12:00:00	SPY	ETF	428.15	428.45	427.55	427.63	2311113.0
2023-06-06 12:30:00	SPY	ETF	427.64	427.78	426.73	426.91	2589144.0
2023-06-06 13:00:00	SPY	ETF	426.92	427.86	426.77	427.23	2939904.0
2023-06-06 13:30:00	SPY	ETF	427.23	427.35	426.565	426.86	2375553.0
2023-06-06 14:00:00	SPY	ETF	426.87	427.43	426.565	427.395	2934916.0
2023-06-06 14:30:00	SPY	ETF	427.4	427.755	427.27	427.7	1815558.0
2023-06-06 15:00:00	SPY	ETF	427.7	428.19	427.7	428.11	2997442.0
2023-06-06 15:30:00	SPY	ETF	428.12	428.5772	427.48	428.04	9616327.0
2023-06-06 16:00:00	SPY	ETF	428.04	428.38	427.6406	428.25	1973663.0
2023-06-06 16:30:00	SPY	ETF	428.24	428.31	428.2	428.27	196932.0
2023-06-06 17:00:00	SPY	ETF	428.23	428.36	428.15	428.35	54065.0
2023-06-06 17:30:00	SPY	ETF	428.34	428.52	428.3	428.4	115291.0
2023-06-06 18:00:00	SPY	ETF	428.36	428.38	428.0	428.0	87115.0
2023-06-06 18:30:00	SPY	ETF	428.01	428.2	428.01	428.17	9194.0
2023-06-06 19:00:00	SPY	ETF	428.14	428.45	428.14	428.4	22814.0
2023-06-06 19:30:00	SPY	ETF	428.36	428.53	428.35	428.48	76802.0
2023-06-06 04:00:00	QQQ	ETF	354.62	355.5	354.62	354.92	16905.0
2023-06-06 04:30:00	QQQ	ETF	354.78	354.98	354.71	354.8	4687.0
2023-06-06 05:00:00	QQQ	ETF	354.91	354.95	354.69	354.95	5114.0
2023-06-06 05:30:00	QQQ	ETF	354.9	354.95	354.77	354.84	5497.0
2023-06-06 06:00:00	QQQ	ETF	354.76	354.77	354.41	354.47	2885.0
2023-06-06 06:30:00	QQQ	ETF	354.45	354.8	354.45	354.8	10150.0
2023-06-06 07:00:00	QQQ	ETF	354.77	354.85	354.65	354.85	41921.0
2023-06-06 07:30:00	QQQ	ETF	354.86	355.14	354.721	354.9	23533.0
2023-06-06 08:00:00	QQQ	ETF	354.7616	355.1	354.05	354.5	332934.0
2023-06-06 08:30:00	QQQ	ETF	354.53	354.66	354.38	354.58	77975.0
2023-06-06 09:00:00	QQQ	ETF	354.57	354.87	354.29	354.29	177659.0
2023-06-06 09:30:00	QQQ	ETF	354.28	354.32	352.93	353.9296	4947907.0
2023-06-06 10:00:00	QQQ	ETF	353.93	354.8	353.4401	354.4989	3320902.0
2023-06-06 10:30:00	QQQ	ETF	354.49	355.41	354.3	355.05	2347070.0
2023-06-06 11:00:00	QQQ	ETF	355.07	355.295	353.8	354.34	3263699.0
2023-06-06 11:30:00	QQQ	ETF	354.34	355.62	354.2886	355.51	1890475.0
2023-06-06 12:00:00	QQQ	ETF	355.52	355.82	354.86	355.06	1577736.0
2023-06-06 12:30:00	QQQ	ETF	355.06	355.23	353.49	353.61	2414330.0

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

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