PREVIEW / etf_30min / 2006-05-22

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-05-22.parquet
  size:    70 KB
  rows:    2,434

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
2006-05-22 04:00:00	SPY	ETF	126.3	126.3	126.06	126.08	4500.0
2006-05-22 04:30:00	SPY	ETF	126.04	126.04	126.04	126.04	3000.0
2006-05-22 05:30:00	SPY	ETF	126.27	126.27	126.27	126.27	100.0
2006-05-22 06:30:00	SPY	ETF	126.51	126.53	126.49	126.53	3100.0
2006-05-22 07:00:00	SPY	ETF	126.5	126.53	126.28	126.28	123100.0
2006-05-22 07:30:00	SPY	ETF	126.29	126.5	126.29	126.49	128600.0
2006-05-22 08:00:00	SPY	ETF	126.53	126.57	126.19	126.43	1294800.0
2006-05-22 08:30:00	SPY	ETF	126.44	126.45	126.3	126.44	1094600.0
2006-05-22 09:00:00	SPY	ETF	126.44	127.1	125.95	126.29	793200.0
2006-05-22 09:30:00	SPY	ETF	126.28	126.85	126.24	126.47	11983000.0
2006-05-22 10:00:00	SPY	ETF	126.47	126.79	126.1	126.34	8301600.0
2006-05-22 10:30:00	SPY	ETF	126.34	126.56	126.26	126.32	6326600.0
2006-05-22 11:00:00	SPY	ETF	126.34	126.86	125.77	126.08	10005600.0
2006-05-22 11:30:00	SPY	ETF	126.08	126.4	125.5	126.03	9609100.0
2006-05-22 12:00:00	SPY	ETF	126.07	126.73	125.9	126.06	7742500.0
2006-05-22 12:30:00	SPY	ETF	126.07	126.55	125.91	126.1	5532500.0
2006-05-22 13:00:00	SPY	ETF	126.1	126.34	125.94	126.27	4616900.0
2006-05-22 13:30:00	SPY	ETF	126.27	126.28	126.01	126.08	2236500.0
2006-05-22 14:00:00	SPY	ETF	126.09	126.5	125.7	126.48	9036300.0
2006-05-22 14:30:00	SPY	ETF	126.45	126.48	126.16	126.32	4301500.0
2006-05-22 15:00:00	SPY	ETF	126.3188	127.02	126.25	127.0	10531500.0
2006-05-22 15:30:00	SPY	ETF	127.0	127.17	126.4	126.4	9230600.0
2006-05-22 16:00:00	SPY	ETF	126.41	126.45	126.13	126.2	1823200.0
2006-05-22 16:30:00	SPY	ETF	126.2	126.33	126.2	126.3	380500.0
2006-05-22 17:00:00	SPY	ETF	126.3	126.34	126.28	126.32	232400.0
2006-05-22 17:30:00	SPY	ETF	126.33	126.35	126.3	126.3	74700.0
2006-05-22 18:00:00	SPY	ETF	126.3	126.38	126.3	126.37	24600.0
2006-05-22 18:30:00	SPY	ETF	126.35	126.38	126.35	126.38	2000.0
2006-05-22 19:00:00	SPY	ETF	126.39	126.4	126.39	126.4	1300.0
2006-05-22 19:30:00	SPY	ETF	126.32	126.33	126.32	126.33	200.0
2006-05-22 09:30:00	QQQ	ETF	39.02	39.24	38.99	39.06	18900400.0
2006-05-22 10:00:00	QQQ	ETF	39.06	39.09	38.89	38.99	14678200.0
2006-05-22 10:30:00	QQQ	ETF	38.99	39.09	38.93	38.95	9346400.0
2006-05-22 11:00:00	QQQ	ETF	38.96	38.98	38.78	38.89	12117100.0
2006-05-22 11:30:00	QQQ	ETF	38.89	39.01	38.7	38.85	12140500.0
2006-05-22 12:00:00	QQQ	ETF	38.85	39.1	38.83	38.92	11665500.0
2006-05-22 12:30:00	QQQ	ETF	38.92	39.02	38.77	38.84	8836700.0
2006-05-22 13:00:00	QQQ	ETF	38.85	38.92	38.76	38.9	8712400.0
2006-05-22 13:30:00	QQQ	ETF	38.9	38.9	38.77	38.82	9013400.0
2006-05-22 14:00:00	QQQ	ETF	38.82	38.91	38.62	38.89	17482900.0
2006-05-22 14:30:00	QQQ	ETF	38.89	38.9	38.74	38.79	6275300.0
2006-05-22 15:00:00	QQQ	ETF	38.79	39.13	38.77	39.1	11978100.0
2006-05-22 15:30:00	QQQ	ETF	39.09	39.21	38.95	38.96	14301200.0
2006-05-22 08:00:00	IWM	ETF	71.4	71.59	70.76	71.4	607500.0
2006-05-22 08:30:00	IWM	ETF	71.4	71.45	71.27	71.3	676200.0
2006-05-22 09:00:00	IWM	ETF	71.3	71.36	71.25	71.25	614500.0
2006-05-22 09:30:00	IWM	ETF	71.24	71.51	70.89	70.9	10252300.0
2006-05-22 10:00:00	IWM	ETF	70.89	70.91	70.42	70.78	8478000.0
2006-05-22 10:30:00	IWM	ETF	70.79	71.13	70.72	70.73	6939700.0
2006-05-22 11:00:00	IWM	ETF	70.74	71.08	70.24	70.46	7380600.0

> showing 50 of 2,434 rows — these rows as CSV

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