PREVIEW / etf_30min / 2006-08-08

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-08.parquet
  size:    76 KB
  rows:    2,695

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-08-08 05:30:00	SPY	ETF	128.2	128.2	128.2	128.2	1000.0
2006-08-08 06:00:00	SPY	ETF	128.18	128.18	128.13	128.13	100000.0
2006-08-08 06:30:00	SPY	ETF	128.17	128.19	128.17	128.17	36000.0
2006-08-08 07:00:00	SPY	ETF	128.17	128.2	128.14	128.17	304200.0
2006-08-08 07:30:00	SPY	ETF	128.17	128.21	128.11	128.11	173300.0
2006-08-08 08:00:00	SPY	ETF	128.14	128.28	128.12	128.25	1308200.0
2006-08-08 08:30:00	SPY	ETF	128.2	128.2	127.92	128.02	1014800.0
2006-08-08 09:00:00	SPY	ETF	128.0	128.21	127.98	128.1	1006400.0
2006-08-08 09:30:00	SPY	ETF	128.09	128.17	127.84	128.06	6431400.0
2006-08-08 10:00:00	SPY	ETF	128.06	128.17	128.02	128.04	3041300.0
2006-08-08 10:30:00	SPY	ETF	128.04	128.1	127.97	128.03	1705700.0
2006-08-08 11:00:00	SPY	ETF	128.032	128.15	127.97	128.11	2484600.0
2006-08-08 11:30:00	SPY	ETF	128.11	128.17	127.98	128.0	1200400.0
2006-08-08 12:00:00	SPY	ETF	128.0	128.09	127.99	128.02	1517300.0
2006-08-08 12:30:00	SPY	ETF	128.03	128.04	127.9	127.99	2837800.0
2006-08-08 13:00:00	SPY	ETF	128.0	128.01	127.92	127.92	1996800.0
2006-08-08 13:30:00	SPY	ETF	127.92	127.97	127.79	127.83	2380500.0
2006-08-08 14:00:00	SPY	ETF	127.84	128.46	127.1	127.62	22565600.0
2006-08-08 14:30:00	SPY	ETF	127.6	128.09	127.44	127.53	17772200.0
2006-08-08 15:00:00	SPY	ETF	127.53	127.73	127.08	127.22	7361500.0
2006-08-08 15:30:00	SPY	ETF	127.22	128.05	126.95	127.33	9550300.0
2006-08-08 16:00:00	SPY	ETF	127.33	128.265	127.28	127.38	4125700.0
2006-08-08 16:30:00	SPY	ETF	127.38	127.62	127.35	127.61	580700.0
2006-08-08 17:00:00	SPY	ETF	127.61	127.64	127.56	127.64	252800.0
2006-08-08 17:30:00	SPY	ETF	127.65	127.7	127.59	127.7	68000.0
2006-08-08 18:00:00	SPY	ETF	127.64	127.71	127.61	127.65	32900.0
2006-08-08 18:30:00	SPY	ETF	127.64	127.64	127.64	127.64	100.0
2006-08-08 19:00:00	SPY	ETF	127.67	127.67	127.61	127.61	2000.0
2006-08-08 19:30:00	SPY	ETF	127.63	127.63	127.63	127.63	1200.0
2006-08-08 09:30:00	QQQ	ETF	36.82	36.85	36.66	36.75	8137100.0
2006-08-08 10:00:00	QQQ	ETF	36.75	36.85	36.74	36.81	6581800.0
2006-08-08 10:30:00	QQQ	ETF	36.82	36.84	36.77	36.79	4181200.0
2006-08-08 11:00:00	QQQ	ETF	36.8	36.9	36.76	36.87	2984700.0
2006-08-08 11:30:00	QQQ	ETF	36.87	36.89	36.74	36.77	3251800.0
2006-08-08 12:00:00	QQQ	ETF	36.77	36.83	36.76	36.79	1384000.0
2006-08-08 12:30:00	QQQ	ETF	36.79	36.79	36.75	36.77	1334600.0
2006-08-08 13:00:00	QQQ	ETF	36.77	36.8	36.75	36.77	834300.0
2006-08-08 13:30:00	QQQ	ETF	36.76	36.77	36.68	36.69	2397700.0
2006-08-08 14:00:00	QQQ	ETF	36.69	36.88	36.26	36.48	37572500.0
2006-08-08 14:30:00	QQQ	ETF	36.48	36.74	36.36	36.51	25534800.0
2006-08-08 15:00:00	QQQ	ETF	36.51	36.57	36.36	36.43	9151000.0
2006-08-08 15:30:00	QQQ	ETF	36.43	36.58	36.3	36.49	15991200.0
2006-08-08 08:00:00	IWM	ETF	69.58	69.67	69.54	69.67	20900.0
2006-08-08 08:30:00	IWM	ETF	69.6	69.65	69.33	69.42	1180300.0
2006-08-08 09:00:00	IWM	ETF	69.41	69.55	69.38	69.45	176000.0
2006-08-08 09:30:00	IWM	ETF	69.43	69.61	69.04	69.32	4673300.0
2006-08-08 10:00:00	IWM	ETF	69.32	69.5	69.31	69.4	2556100.0
2006-08-08 10:30:00	IWM	ETF	69.4	69.45	69.21	69.3	1033800.0
2006-08-08 11:00:00	IWM	ETF	69.29	69.42	69.18	69.39	1772900.0
2006-08-08 11:30:00	IWM	ETF	69.38	69.45	69.19	69.22	1347300.0

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

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