PREVIEW / etf_30min / 2006-07-26

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-26.parquet
  size:    78 KB
  rows:    2,684

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-07-26 04:00:00	SPY	ETF	126.75	126.75	126.66	126.66	1500.0
2006-07-26 06:00:00	SPY	ETF	126.54	126.55	126.5	126.5	150000.0
2006-07-26 06:30:00	SPY	ETF	126.52	126.56	126.52	126.56	5500.0
2006-07-26 07:00:00	SPY	ETF	126.65	126.7	126.6	126.6	24500.0
2006-07-26 07:30:00	SPY	ETF	126.6	126.69	126.6	126.65	36500.0
2006-07-26 08:00:00	SPY	ETF	126.6	126.7	126.52	126.62	321000.0
2006-07-26 08:30:00	SPY	ETF	126.61	126.8	126.61	126.75	558900.0
2006-07-26 09:00:00	SPY	ETF	126.76	126.8	126.58	126.58	390300.0
2006-07-26 09:30:00	SPY	ETF	126.59	126.69	126.38	126.62	7228400.0
2006-07-26 10:00:00	SPY	ETF	126.62	126.65	126.18	126.38	9811700.0
2006-07-26 10:30:00	SPY	ETF	126.38	126.5	126.23	126.36	5385800.0
2006-07-26 11:00:00	SPY	ETF	126.3515	126.7	126.29	126.52	4842700.0
2006-07-26 11:30:00	SPY	ETF	126.53	126.69	126.47	126.69	2380400.0
2006-07-26 12:00:00	SPY	ETF	126.69	127.09	126.68	126.9	7664300.0
2006-07-26 12:30:00	SPY	ETF	126.9	126.93	126.74	126.84	3447600.0
2006-07-26 13:00:00	SPY	ETF	126.83	126.96	126.77	126.86	1195200.0
2006-07-26 13:30:00	SPY	ETF	126.86	127.29	126.86	127.13	5418400.0
2006-07-26 14:00:00	SPY	ETF	127.13	127.34	126.78	127.1	15223900.0
2006-07-26 14:30:00	SPY	ETF	127.11	127.45	127.1	127.29	7003000.0
2006-07-26 15:00:00	SPY	ETF	127.3015	127.37	127.02	127.12	5530100.0
2006-07-26 15:30:00	SPY	ETF	127.13	127.28	126.88	126.89	4335600.0
2006-07-26 16:00:00	SPY	ETF	126.87	126.98	126.8	126.86	1155200.0
2006-07-26 16:30:00	SPY	ETF	126.86	126.86	126.8	126.8	163000.0
2006-07-26 17:00:00	SPY	ETF	126.78	126.82	126.78	126.81	786600.0
2006-07-26 17:30:00	SPY	ETF	126.79	126.8	126.79	126.8	300.0
2006-07-26 18:00:00	SPY	ETF	126.82	126.83	126.82	126.82	2300.0
2006-07-26 19:00:00	SPY	ETF	126.8	126.8	126.8	126.8	500.0
2006-07-26 19:30:00	SPY	ETF	126.77	126.81	126.76	126.77	3600.0
2006-07-26 09:30:00	QQQ	ETF	36.5	36.52	36.34	36.48	14494300.0
2006-07-26 10:00:00	QQQ	ETF	36.49	36.49	36.26	36.34	12299200.0
2006-07-26 10:30:00	QQQ	ETF	36.35	36.35	36.23	36.28	5731000.0
2006-07-26 11:00:00	QQQ	ETF	36.28	36.43	36.23	36.36	6742100.0
2006-07-26 11:30:00	QQQ	ETF	36.35	36.5	36.32	36.43	2797700.0
2006-07-26 12:00:00	QQQ	ETF	36.43	36.64	36.42	36.57	10649200.0
2006-07-26 12:30:00	QQQ	ETF	36.56	36.57	36.46	36.51	3928300.0
2006-07-26 13:00:00	QQQ	ETF	36.51	36.61	36.5	36.57	2588300.0
2006-07-26 13:30:00	QQQ	ETF	36.56	36.71	36.55	36.68	4400400.0
2006-07-26 14:00:00	QQQ	ETF	36.68	36.73	36.54	36.66	8558600.0
2006-07-26 14:30:00	QQQ	ETF	36.67	36.87	36.67	36.82	9774700.0
2006-07-26 15:00:00	QQQ	ETF	36.81	36.83	36.65	36.71	7643100.0
2006-07-26 15:30:00	QQQ	ETF	36.72	36.78	36.56	36.57	9373600.0
2006-07-26 08:00:00	IWM	ETF	68.95	69.05	68.82	68.9	649400.0
2006-07-26 08:30:00	IWM	ETF	68.89	69.03	68.89	69.03	70600.0
2006-07-26 09:00:00	IWM	ETF	69.03	69.09	68.91	68.95	393800.0
2006-07-26 09:30:00	IWM	ETF	68.93	69.0	68.52	68.78	7423300.0
2006-07-26 10:00:00	IWM	ETF	68.78	68.78	68.12	68.31	8682400.0
2006-07-26 10:30:00	IWM	ETF	68.3	68.41	68.12	68.4	3440500.0
2006-07-26 11:00:00	IWM	ETF	68.4	68.84	68.39	68.57	6372400.0
2006-07-26 11:30:00	IWM	ETF	68.57	68.8	68.53	68.8	1880500.0
2006-07-26 12:00:00	IWM	ETF	68.78	69.22	68.78	68.99	5233300.0

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

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