PREVIEW / etf_30min / 2023-06-02

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-06-02.parquet
  size:    716 KB
  rows:    28,409

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-02 04:00:00	SPY	ETF	422.75	423.49	422.75	423.4	15708.0
2023-06-02 04:30:00	SPY	ETF	423.3	423.54	423.23	423.54	10403.0
2023-06-02 05:00:00	SPY	ETF	423.45	424.16	423.4	423.97	10306.0
2023-06-02 05:30:00	SPY	ETF	424.0	424.07	423.68	423.77	27881.0
2023-06-02 06:00:00	SPY	ETF	423.8	424.04	423.69	423.98	64720.0
2023-06-02 06:30:00	SPY	ETF	423.98	424.11	423.8	423.87	55124.0
2023-06-02 07:00:00	SPY	ETF	423.87	424.21	423.84	424.16	73746.0
2023-06-02 07:30:00	SPY	ETF	424.13	424.25	423.73	423.8	115805.0
2023-06-02 08:00:00	SPY	ETF	423.8891	424.2	422.47	423.45	311181.0
2023-06-02 08:30:00	SPY	ETF	423.46	424.63	422.56	423.87	926561.0
2023-06-02 09:00:00	SPY	ETF	423.87	424.6	423.87	424.46	245874.0
2023-06-02 09:30:00	SPY	ETF	424.5	426.375	424.3	424.37	9160801.0
2023-06-02 10:00:00	SPY	ETF	424.365	425.83	423.95	425.51	6510179.0
2023-06-02 10:30:00	SPY	ETF	425.51	426.9	425.14	426.83	4826702.0
2023-06-02 11:00:00	SPY	ETF	426.835	427.69	426.835	427.545	5310448.0
2023-06-02 11:30:00	SPY	ETF	427.56	427.69	426.76	427.44	4581633.0
2023-06-02 12:00:00	SPY	ETF	427.45	427.56	426.9301	427.44	2557814.0
2023-06-02 12:30:00	SPY	ETF	427.46	428.14	427.29	428.015	2452356.0
2023-06-02 13:00:00	SPY	ETF	428.02	428.385	427.67	428.26	2600454.0
2023-06-02 13:30:00	SPY	ETF	428.27	428.34	427.715	428.14	2546353.0
2023-06-02 14:00:00	SPY	ETF	428.145	428.28	427.47	427.9224	3140404.0
2023-06-02 14:30:00	SPY	ETF	427.925	428.44	427.88	428.332	2637580.0
2023-06-02 15:00:00	SPY	ETF	428.34	428.74	428.05	428.095	3992049.0
2023-06-02 15:30:00	SPY	ETF	428.095	428.4	427.71	427.91	13642730.0
2023-06-02 16:00:00	SPY	ETF	427.9	428.02	427.72	427.86	4777222.0
2023-06-02 16:30:00	SPY	ETF	427.89	427.96	427.67	427.9	390495.0
2023-06-02 17:00:00	SPY	ETF	427.85	427.99	427.69	427.99	82208.0
2023-06-02 17:30:00	SPY	ETF	427.99	428.08	427.92	427.93	33606.0
2023-06-02 18:00:00	SPY	ETF	427.93	427.95	427.75	427.75	18409.0
2023-06-02 18:30:00	SPY	ETF	427.84	428.0	427.8202	427.88	8998.0
2023-06-02 19:00:00	SPY	ETF	427.95	427.99	427.91	427.91	1531.0
2023-06-02 19:30:00	SPY	ETF	427.91	428.03	427.89	428.03	15800.0
2023-06-02 04:00:00	QQQ	ETF	352.62	353.14	352.62	352.95	33362.0
2023-06-02 04:30:00	QQQ	ETF	353.0	353.39	353.0	353.39	26675.0
2023-06-02 05:00:00	QQQ	ETF	353.35	354.22	353.35	354.11	22891.0
2023-06-02 05:30:00	QQQ	ETF	354.13	354.15	353.66	353.73	39974.0
2023-06-02 06:00:00	QQQ	ETF	353.73	354.03	353.63	353.88	88329.0
2023-06-02 06:30:00	QQQ	ETF	353.91	353.94	353.4	353.45	100101.0
2023-06-02 07:00:00	QQQ	ETF	353.42	354.26	353.42	354.23	77995.0
2023-06-02 07:30:00	QQQ	ETF	354.22	354.24	353.88	354.0	148035.0
2023-06-02 08:00:00	QQQ	ETF	353.5983	354.2496	352.26	353.75	248171.0
2023-06-02 08:30:00	QQQ	ETF	353.63	353.88	352.5	353.0	727400.0
2023-06-02 09:00:00	QQQ	ETF	353.01	353.85	353.01	353.74	260568.0
2023-06-02 09:30:00	QQQ	ETF	353.76	355.83	352.16	352.3	7841220.0
2023-06-02 10:00:00	QQQ	ETF	352.3	353.69	352.01	353.32	4448199.0
2023-06-02 10:30:00	QQQ	ETF	353.32	354.98	352.82	354.8505	2983594.0
2023-06-02 11:00:00	QQQ	ETF	354.87	355.3	354.515	354.87	2729484.0
2023-06-02 11:30:00	QQQ	ETF	354.88	355.14	354.21	354.85	2059248.0
2023-06-02 12:00:00	QQQ	ETF	354.855	354.96	354.06	354.5	2146721.0
2023-06-02 12:30:00	QQQ	ETF	354.5096	355.36	354.3499	355.0	1493406.0

> showing 50 of 28,409 rows — these rows as CSV

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