PREVIEW / etf_30min / 2006-01-20

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-20.parquet
  size:    63 KB
  rows:    2,182

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-01-20 06:30:00	SPY	ETF	128.1	128.12	128.0	128.0	4600.0
2006-01-20 07:00:00	SPY	ETF	128.0	128.03	127.97	128.03	6200.0
2006-01-20 07:30:00	SPY	ETF	128.02	128.05	128.02	128.04	12200.0
2006-01-20 08:00:00	SPY	ETF	128.05	128.13	127.97	128.02	37900.0
2006-01-20 08:30:00	SPY	ETF	128.02	128.36	128.0	128.05	247400.0
2006-01-20 09:00:00	SPY	ETF	128.09	128.38	128.07	128.26	324900.0
2006-01-20 09:30:00	SPY	ETF	128.28	128.31	128.05	128.08	7344200.0
2006-01-20 10:00:00	SPY	ETF	128.08	128.15	127.84	127.87	7651800.0
2006-01-20 10:30:00	SPY	ETF	127.87	127.9	127.26	127.49	12039000.0
2006-01-20 11:00:00	SPY	ETF	127.44	127.53	127.14	127.34	6548200.0
2006-01-20 11:30:00	SPY	ETF	127.34	127.42	126.78	126.91	9480800.0
2006-01-20 12:00:00	SPY	ETF	126.91	127.2	126.89	127.13	9017300.0
2006-01-20 12:30:00	SPY	ETF	127.13	127.15	126.74	126.88	4317200.0
2006-01-20 13:00:00	SPY	ETF	126.88	126.9	126.57	126.81	10142400.0
2006-01-20 13:30:00	SPY	ETF	126.8188	126.84	126.48	126.56	4996500.0
2006-01-20 14:00:00	SPY	ETF	126.56	127.04	126.44	126.81	6779500.0
2006-01-20 14:30:00	SPY	ETF	126.8	126.83	126.42	126.44	6632400.0
2006-01-20 15:00:00	SPY	ETF	126.45	126.67	126.25	126.31	9857800.0
2006-01-20 15:30:00	SPY	ETF	126.31	126.48	126.0	126.12	13664500.0
2006-01-20 16:00:00	SPY	ETF	126.13	126.17	125.81	126.0	2032400.0
2006-01-20 16:30:00	SPY	ETF	126.02	126.05	125.96	126.05	124600.0
2006-01-20 17:00:00	SPY	ETF	126.03	126.1	125.94	125.96	172400.0
2006-01-20 17:30:00	SPY	ETF	125.96	126.0	125.94	126.0	28900.0
2006-01-20 18:00:00	SPY	ETF	125.97	125.97	125.93	125.93	17100.0
2006-01-20 18:30:00	SPY	ETF	125.93	125.97	125.92	125.92	3500.0
2006-01-20 19:00:00	SPY	ETF	125.97	125.97	125.91	125.97	1300.0
2006-01-20 19:30:00	SPY	ETF	125.93	125.95	125.93	125.95	300.0
2006-01-20 09:30:00	QQQ	ETF	42.44	42.49	42.34	42.38	9073700.0
2006-01-20 10:00:00	QQQ	ETF	42.37	42.38	42.09	42.14	14765000.0
2006-01-20 10:30:00	QQQ	ETF	42.13	42.18	41.82	41.99	20494700.0
2006-01-20 11:00:00	QQQ	ETF	41.99	42.07	41.86	42.0	9117500.0
2006-01-20 11:30:00	QQQ	ETF	42.0	42.0	41.73	41.76	11534200.0
2006-01-20 12:00:00	QQQ	ETF	41.75	42.0	41.67	41.78	7921100.0
2006-01-20 12:30:00	QQQ	ETF	41.78	41.78	41.34	41.52	18172300.0
2006-01-20 13:00:00	QQQ	ETF	41.51	41.61	41.37	41.59	14318800.0
2006-01-20 13:30:00	QQQ	ETF	41.59	41.59	41.4	41.42	12063900.0
2006-01-20 14:00:00	QQQ	ETF	41.42	41.57	41.36	41.55	10022000.0
2006-01-20 14:30:00	QQQ	ETF	41.56	41.57	41.35	41.39	9120600.0
2006-01-20 15:00:00	QQQ	ETF	41.39	41.53	41.33	41.36	15073700.0
2006-01-20 15:30:00	QQQ	ETF	41.36	41.41	41.15	41.3	22622500.0
2006-01-20 08:00:00	IWM	ETF	70.83	70.85	70.81	70.81	6300.0
2006-01-20 08:30:00	IWM	ETF	70.78	70.84	70.77	70.81	37800.0
2006-01-20 09:00:00	IWM	ETF	70.81	71.09	70.81	71.05	31100.0
2006-01-20 09:30:00	IWM	ETF	71.03	71.12	70.9	70.95	2444600.0
2006-01-20 10:00:00	IWM	ETF	70.91	70.94	70.77	70.81	2322200.0
2006-01-20 10:30:00	IWM	ETF	70.8	70.83	70.55	70.58	2156200.0
2006-01-20 11:00:00	IWM	ETF	70.57	70.68	70.47	70.61	2220500.0
2006-01-20 11:30:00	IWM	ETF	70.59	70.6	70.18	70.23	3258700.0
2006-01-20 12:00:00	IWM	ETF	70.23	70.5	70.2	70.39	1295000.0
2006-01-20 12:30:00	IWM	ETF	70.38	70.5	70.2	70.28	2303200.0

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

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