PREVIEW / etf_30min / 2023-05-11

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-11.parquet
  size:    671 KB
  rows:    26,952

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-11 04:00:00	SPY	ETF	414.1	414.51	413.86	414.24	17560.0
2023-05-11 04:30:00	SPY	ETF	414.25	414.32	414.04	414.1	17037.0
2023-05-11 05:00:00	SPY	ETF	414.17	414.55	413.94	414.41	3758.0
2023-05-11 05:30:00	SPY	ETF	414.37	414.5	414.18	414.18	9774.0
2023-05-11 06:00:00	SPY	ETF	414.3	414.3	413.85	413.95	15728.0
2023-05-11 06:30:00	SPY	ETF	413.95	413.98	413.66	413.66	84774.0
2023-05-11 07:00:00	SPY	ETF	413.6	413.69	412.48	412.83	386406.0
2023-05-11 07:30:00	SPY	ETF	412.82	412.92	412.26	412.44	131034.0
2023-05-11 08:00:00	SPY	ETF	412.7695	414.53	412.31	413.01	631478.0
2023-05-11 08:30:00	SPY	ETF	413.25	413.63	412.38	412.5	518012.0
2023-05-11 09:00:00	SPY	ETF	412.5	412.5	411.46	411.94	639085.0
2023-05-11 09:30:00	SPY	ETF	411.94	412.09	410.16	410.3095	7374589.0
2023-05-11 10:00:00	SPY	ETF	410.32	411.07	409.97	410.8701	5885692.0
2023-05-11 10:30:00	SPY	ETF	410.89	411.41	410.115	411.32	4423303.0
2023-05-11 11:00:00	SPY	ETF	411.36	411.6873	410.955	411.45	3699150.0
2023-05-11 11:30:00	SPY	ETF	411.4584	412.01	411.31	411.855	2818424.0
2023-05-11 12:00:00	SPY	ETF	411.86	412.25	411.28	411.8299	2935978.0
2023-05-11 12:30:00	SPY	ETF	411.82	412.18	411.72	412.01	1686880.0
2023-05-11 13:00:00	SPY	ETF	412.01	412.09	411.27	411.41	1833713.0
2023-05-11 13:30:00	SPY	ETF	411.41	411.87	410.27	411.3299	3755577.0
2023-05-11 14:00:00	SPY	ETF	411.33	411.59	410.935	411.52	2371792.0
2023-05-11 14:30:00	SPY	ETF	411.52	412.43	411.4	412.23	3131600.0
2023-05-11 15:00:00	SPY	ETF	412.2322	412.32	411.675	411.98	2870647.0
2023-05-11 15:30:00	SPY	ETF	411.97	412.3	411.46	412.16	7294671.0
2023-05-11 16:00:00	SPY	ETF	412.16	412.27	411.93	412.18	2163299.0
2023-05-11 16:30:00	SPY	ETF	412.18	412.35	412.03	412.32	291267.0
2023-05-11 17:00:00	SPY	ETF	412.3	412.31	412.2	412.22	10201.0
2023-05-11 17:30:00	SPY	ETF	412.275	412.29	412.1	412.1	284806.0
2023-05-11 18:00:00	SPY	ETF	412.1	412.7	412.1	412.56	199033.0
2023-05-11 18:30:00	SPY	ETF	412.57	412.64	412.45	412.63	39821.0
2023-05-11 19:00:00	SPY	ETF	412.63	412.64	412.53	412.58	9738.0
2023-05-11 19:30:00	SPY	ETF	412.58	412.59	412.39	412.4	19101.0
2023-05-11 04:00:00	QQQ	ETF	325.69	326.49	325.69	326.3	24449.0
2023-05-11 04:30:00	QQQ	ETF	326.24	326.39	326.07	326.25	10214.0
2023-05-11 05:00:00	QQQ	ETF	326.28	326.53	326.05	326.36	8463.0
2023-05-11 05:30:00	QQQ	ETF	326.34	326.5	326.33	326.33	9967.0
2023-05-11 06:00:00	QQQ	ETF	326.4	326.51	326.04	326.16	9965.0
2023-05-11 06:30:00	QQQ	ETF	326.14	326.17	325.92	325.92	5077.0
2023-05-11 07:00:00	QQQ	ETF	325.87	325.94	325.15	325.56	76036.0
2023-05-11 07:30:00	QQQ	ETF	325.55	325.67	325.25	325.46	97363.0
2023-05-11 08:00:00	QQQ	ETF	325.5212	326.61	325.15	326.04	377006.0
2023-05-11 08:30:00	QQQ	ETF	326.1	326.65	325.72	325.89	519320.0
2023-05-11 09:00:00	QQQ	ETF	325.84	325.85	325.23	325.641	746662.0
2023-05-11 09:30:00	QQQ	ETF	325.7	325.85	324.38	324.705	5165437.0
2023-05-11 10:00:00	QQQ	ETF	324.73	325.52	324.56	325.15	3196670.0
2023-05-11 10:30:00	QQQ	ETF	325.14	325.5	324.12	325.5	2995402.0
2023-05-11 11:00:00	QQQ	ETF	325.5	325.9	325.15	325.89	2250901.0
2023-05-11 11:30:00	QQQ	ETF	325.895	326.265	325.473	326.06	2128643.0
2023-05-11 12:00:00	QQQ	ETF	326.07	326.35	325.5	326.0	1948518.0
2023-05-11 12:30:00	QQQ	ETF	326.055	326.49	325.98	326.28	1407484.0

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

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