PREVIEW / etf_30min / 2023-05-25

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-25.parquet
  size:    696 KB
  rows:    27,880

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-25 04:00:00	SPY	ETF	412.59	413.4	412.5	413.35	27051.0
2023-05-25 04:30:00	SPY	ETF	413.37	413.65	413.21	413.63	6067.0
2023-05-25 05:00:00	SPY	ETF	413.8	413.95	413.69	413.83	11645.0
2023-05-25 05:30:00	SPY	ETF	413.98	414.27	413.84	414.17	125222.0
2023-05-25 06:00:00	SPY	ETF	414.17	414.27	414.0	414.15	24358.0
2023-05-25 06:30:00	SPY	ETF	414.12	414.23	413.6	413.6	77597.0
2023-05-25 07:00:00	SPY	ETF	413.56	413.76	413.45	413.59	161174.0
2023-05-25 07:30:00	SPY	ETF	413.59	413.96	413.24	413.95	125408.0
2023-05-25 08:00:00	SPY	ETF	413.55	414.72	412.28	414.18	307066.0
2023-05-25 08:30:00	SPY	ETF	414.15	415.21	412.48	415.0	716806.0
2023-05-25 09:00:00	SPY	ETF	414.98	415.32	414.38	414.67	637763.0
2023-05-25 09:30:00	SPY	ETF	414.73	414.8	412.59	413.15	7875758.0
2023-05-25 10:00:00	SPY	ETF	413.14	413.8001	412.4101	413.13	5029354.0
2023-05-25 10:30:00	SPY	ETF	413.16	413.97	412.6814	413.73	3890457.0
2023-05-25 11:00:00	SPY	ETF	413.74	414.63	413.53	413.6	4521499.0
2023-05-25 11:30:00	SPY	ETF	413.61	413.68	412.59	413.1	4534708.0
2023-05-25 12:00:00	SPY	ETF	413.11	414.55	413.1	414.17	3559295.0
2023-05-25 12:30:00	SPY	ETF	414.18	414.32	413.56	413.67	2925501.0
2023-05-25 13:00:00	SPY	ETF	413.69	414.92	413.425	414.68	2291216.0
2023-05-25 13:30:00	SPY	ETF	414.68	415.1	414.5	414.9799	2699760.0
2023-05-25 14:00:00	SPY	ETF	414.98	416.16	414.76	415.07	5503474.0
2023-05-25 14:30:00	SPY	ETF	415.07	415.15	413.82	414.1199	3165142.0
2023-05-25 15:00:00	SPY	ETF	414.12	415.51	414.06	415.29	3851856.0
2023-05-25 15:30:00	SPY	ETF	415.29	415.68	414.54	414.63	11652299.0
2023-05-25 16:00:00	SPY	ETF	414.63	414.77	414.39	414.59	3353523.0
2023-05-25 16:30:00	SPY	ETF	414.55	414.65	414.42	414.49	238496.0
2023-05-25 17:00:00	SPY	ETF	414.52	414.56	414.14	414.2	71787.0
2023-05-25 17:30:00	SPY	ETF	414.2	414.65	414.1	414.3	90274.0
2023-05-25 18:00:00	SPY	ETF	414.3	414.54	413.94	414.39	52864.0
2023-05-25 18:30:00	SPY	ETF	414.2201	414.25	414.04	414.2	21477.0
2023-05-25 19:00:00	SPY	ETF	414.2204	414.23	413.87	413.92	16035.0
2023-05-25 19:30:00	SPY	ETF	413.95	413.98	413.85	413.92	22901.0
2023-05-25 04:00:00	QQQ	ETF	336.0	337.26	336.0	337.19	73618.0
2023-05-25 04:30:00	QQQ	ETF	337.24	337.46	337.08	337.43	53371.0
2023-05-25 05:00:00	QQQ	ETF	337.48	337.8	337.48	337.66	59782.0
2023-05-25 05:30:00	QQQ	ETF	337.7	337.99	337.56	337.98	96450.0
2023-05-25 06:00:00	QQQ	ETF	337.94	338.36	337.72	338.15	45751.0
2023-05-25 06:30:00	QQQ	ETF	338.17	338.21	337.62	337.72	65851.0
2023-05-25 07:00:00	QQQ	ETF	337.71	338.11	337.57	338.04	206386.0
2023-05-25 07:30:00	QQQ	ETF	338.01	338.55	337.84	338.55	225681.0
2023-05-25 08:00:00	QQQ	ETF	337.7407	339.44	336.1	338.8	627209.0
2023-05-25 08:30:00	QQQ	ETF	338.84	339.5	338.39	339.35	726354.0
2023-05-25 09:00:00	QQQ	ETF	339.34	339.62	339.03	339.16	659393.0
2023-05-25 09:30:00	QQQ	ETF	339.16	339.42	336.665	337.27	9604611.0
2023-05-25 10:00:00	QQQ	ETF	337.26	338.1	336.705	337.51	4463902.0
2023-05-25 10:30:00	QQQ	ETF	337.52	338.69	337.05	338.62	3687647.0
2023-05-25 11:00:00	QQQ	ETF	338.64	339.92	338.48	339.37	4537076.0
2023-05-25 11:30:00	QQQ	ETF	339.38	339.465	338.355	338.885	3341541.0
2023-05-25 12:00:00	QQQ	ETF	338.89	340.32	338.87	340.12	3159148.0
2023-05-25 12:30:00	QQQ	ETF	340.11	340.21	339.47	339.6277	2695365.0

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

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