PREVIEW / etf_30min / 2006-07-28

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-28.parquet
  size:    75 KB
  rows:    2,671

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-28 04:30:00	SPY	ETF	126.95	126.95	126.95	126.95	100.0
2006-07-28 05:00:00	SPY	ETF	126.96	126.96	126.96	126.96	100.0
2006-07-28 06:30:00	SPY	ETF	126.83	126.83	126.83	126.83	100.0
2006-07-28 07:00:00	SPY	ETF	126.82	126.84	126.73	126.73	5800.0
2006-07-28 07:30:00	SPY	ETF	126.81	126.81	126.8	126.8	1500.0
2006-07-28 08:00:00	SPY	ETF	126.79	126.93	126.72	126.86	938500.0
2006-07-28 08:30:00	SPY	ETF	126.89	127.15	126.68	126.94	2430200.0
2006-07-28 09:00:00	SPY	ETF	126.95	127.08	126.9	126.96	1112000.0
2006-07-28 09:30:00	SPY	ETF	126.99	127.42	126.95	127.21	9317800.0
2006-07-28 10:00:00	SPY	ETF	127.22	127.38	126.86	126.89	8036000.0
2006-07-28 10:30:00	SPY	ETF	126.89	127.38	126.86	127.37	4538400.0
2006-07-28 11:00:00	SPY	ETF	127.37	127.9	127.34	127.84	12299700.0
2006-07-28 11:30:00	SPY	ETF	127.83	127.93	127.69	127.86	4413500.0
2006-07-28 12:00:00	SPY	ETF	127.84	127.89	127.66	127.8	2223100.0
2006-07-28 12:30:00	SPY	ETF	127.8	127.99	127.74	127.92	2742100.0
2006-07-28 13:00:00	SPY	ETF	127.91	128.06	127.69	127.82	8140600.0
2006-07-28 13:30:00	SPY	ETF	127.81	127.85	127.57	127.71	2943000.0
2006-07-28 14:00:00	SPY	ETF	127.72	127.94	127.69	127.8	3771800.0
2006-07-28 14:30:00	SPY	ETF	127.8	127.96	127.64	127.9	2520100.0
2006-07-28 15:00:00	SPY	ETF	127.87	127.99	127.76	127.88	2538600.0
2006-07-28 15:30:00	SPY	ETF	127.87	128.14	127.77	127.84	10046900.0
2006-07-28 16:00:00	SPY	ETF	127.83	128.0	127.8	127.97	1095200.0
2006-07-28 16:30:00	SPY	ETF	127.95	128.0	127.95	127.95	61900.0
2006-07-28 17:00:00	SPY	ETF	127.96	127.96	127.94	127.95	6600.0
2006-07-28 17:30:00	SPY	ETF	127.93	127.96	127.93	127.96	18700.0
2006-07-28 18:00:00	SPY	ETF	127.97	127.97	127.97	127.97	200.0
2006-07-28 18:30:00	SPY	ETF	128.0	128.0	127.96	127.96	200.0
2006-07-28 19:00:00	SPY	ETF	127.97	127.97	127.97	127.97	700.0
2006-07-28 19:30:00	SPY	ETF	127.97	127.97	127.97	127.97	800.0
2006-07-28 09:30:00	QQQ	ETF	36.56	36.8	36.51	36.7	12287000.0
2006-07-28 10:00:00	QQQ	ETF	36.7	36.75	36.5	36.53	8915300.0
2006-07-28 10:30:00	QQQ	ETF	36.54	36.72	36.52	36.7	5815000.0
2006-07-28 11:00:00	QQQ	ETF	36.7	36.92	36.7	36.88	10917900.0
2006-07-28 11:30:00	QQQ	ETF	36.89	36.97	36.82	36.9	5717800.0
2006-07-28 12:00:00	QQQ	ETF	36.89	36.98	36.83	36.97	4996400.0
2006-07-28 12:30:00	QQQ	ETF	36.96	37.04	36.93	37.01	3964500.0
2006-07-28 13:00:00	QQQ	ETF	37.02	37.1	36.95	36.98	5694000.0
2006-07-28 13:30:00	QQQ	ETF	36.98	37.0	36.87	36.95	4526400.0
2006-07-28 14:00:00	QQQ	ETF	36.95	37.06	36.95	36.99	4073200.0
2006-07-28 14:30:00	QQQ	ETF	36.99	37.06	36.92	37.03	2712200.0
2006-07-28 15:00:00	QQQ	ETF	37.02	37.05	36.98	37.02	4849500.0
2006-07-28 15:30:00	QQQ	ETF	37.02	37.14	37.02	37.1	11669800.0
2006-07-28 08:00:00	IWM	ETF	68.23	68.33	68.2	68.24	23200.0
2006-07-28 08:30:00	IWM	ETF	68.34	68.68	68.14	68.63	1781000.0
2006-07-28 09:00:00	IWM	ETF	68.63	68.75	68.54	68.75	872400.0
2006-07-28 09:30:00	IWM	ETF	68.75	69.36	68.5	69.01	11452000.0
2006-07-28 10:00:00	IWM	ETF	69.01	69.11	68.49	68.52	8355900.0
2006-07-28 10:30:00	IWM	ETF	68.53	69.01	68.49	69.0	4404200.0
2006-07-28 11:00:00	IWM	ETF	69.0	69.43	68.96	69.3	6335900.0
2006-07-28 11:30:00	IWM	ETF	69.31	69.46	69.11	69.32	4090300.0

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

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