PREVIEW / etf_30min / 2006-07-17

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-17.parquet
  size:    74 KB
  rows:    2,635

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-17 04:30:00	SPY	ETF	123.1	123.1	123.06	123.06	1500.0
2006-07-17 05:00:00	SPY	ETF	123.11	123.14	123.11	123.14	1500.0
2006-07-17 05:30:00	SPY	ETF	123.23	123.23	123.16	123.16	4900.0
2006-07-17 06:00:00	SPY	ETF	123.6	123.6	123.49	123.49	36200.0
2006-07-17 06:30:00	SPY	ETF	123.32	123.32	123.15	123.25	63000.0
2006-07-17 07:00:00	SPY	ETF	123.38	123.72	123.17	123.25	360000.0
2006-07-17 07:30:00	SPY	ETF	123.29	123.35	123.24	123.3	171300.0
2006-07-17 08:00:00	SPY	ETF	123.29	123.7	123.11	123.32	1802800.0
2006-07-17 08:30:00	SPY	ETF	123.3	123.34	123.17	123.32	297600.0
2006-07-17 09:00:00	SPY	ETF	123.3	123.64	123.2	123.51	1159400.0
2006-07-17 09:30:00	SPY	ETF	123.5	124.1	123.48	123.81	17919500.0
2006-07-17 10:00:00	SPY	ETF	123.81	123.88	123.34	123.39	9245600.0
2006-07-17 10:30:00	SPY	ETF	123.39	123.68	123.15	123.68	8962600.0
2006-07-17 11:00:00	SPY	ETF	123.68	123.82	123.45	123.62	6266300.0
2006-07-17 11:30:00	SPY	ETF	123.61	123.88	123.52	123.68	4877400.0
2006-07-17 12:00:00	SPY	ETF	123.69	123.78	123.47	123.65	3184300.0
2006-07-17 12:30:00	SPY	ETF	123.66	123.83	123.45	123.59	2867300.0
2006-07-17 13:00:00	SPY	ETF	123.58	123.78	123.5	123.71	4342800.0
2006-07-17 13:30:00	SPY	ETF	123.7	123.72	123.52	123.68	2145200.0
2006-07-17 14:00:00	SPY	ETF	123.68	123.84	123.57	123.68	3142600.0
2006-07-17 14:30:00	SPY	ETF	123.67	123.72	123.48	123.53	2227500.0
2006-07-17 15:00:00	SPY	ETF	123.52	123.56	123.29	123.4	4201100.0
2006-07-17 15:30:00	SPY	ETF	123.4	123.71	123.29	123.41	5107300.0
2006-07-17 16:00:00	SPY	ETF	123.39	123.45	123.18	123.18	610500.0
2006-07-17 16:30:00	SPY	ETF	123.36	123.45	123.3	123.41	1386400.0
2006-07-17 17:00:00	SPY	ETF	123.43	123.46	123.39	123.39	22500.0
2006-07-17 17:30:00	SPY	ETF	123.38	123.41	123.32	123.4	49000.0
2006-07-17 18:00:00	SPY	ETF	123.41	123.45	123.39	123.39	61200.0
2006-07-17 18:30:00	SPY	ETF	123.37	123.38	123.35	123.38	1300.0
2006-07-17 19:30:00	SPY	ETF	123.39	123.39	123.39	123.39	600.0
2006-07-17 09:30:00	QQQ	ETF	35.95	36.25	35.95	36.07	26624300.0
2006-07-17 10:00:00	QQQ	ETF	36.08	36.13	35.95	35.97	13544400.0
2006-07-17 10:30:00	QQQ	ETF	35.97	36.15	35.87	36.12	14979500.0
2006-07-17 11:00:00	QQQ	ETF	36.13	36.18	36.02	36.1	11312900.0
2006-07-17 11:30:00	QQQ	ETF	36.09	36.24	36.04	36.11	8210300.0
2006-07-17 12:00:00	QQQ	ETF	36.11	36.15	36.0	36.12	6699600.0
2006-07-17 12:30:00	QQQ	ETF	36.12	36.19	36.05	36.08	3755000.0
2006-07-17 13:00:00	QQQ	ETF	36.07	36.18	36.04	36.16	7212800.0
2006-07-17 13:30:00	QQQ	ETF	36.16	36.17	36.11	36.14	2602900.0
2006-07-17 14:00:00	QQQ	ETF	36.15	36.2	36.12	36.15	4037000.0
2006-07-17 14:30:00	QQQ	ETF	36.15	36.16	36.05	36.09	3768700.0
2006-07-17 15:00:00	QQQ	ETF	36.09	36.1	35.96	36.02	7310300.0
2006-07-17 15:30:00	QQQ	ETF	36.02	36.12	35.96	36.04	8992300.0
2006-07-17 08:00:00	IWM	ETF	67.45	67.45	67.25	67.35	27700.0
2006-07-17 08:30:00	IWM	ETF	67.35	67.45	67.3	67.4	824400.0
2006-07-17 09:00:00	IWM	ETF	67.41	67.71	67.39	67.6	689100.0
2006-07-17 09:30:00	IWM	ETF	67.6	68.2	67.5	67.57	9430500.0
2006-07-17 10:00:00	IWM	ETF	67.57	67.66	67.25	67.36	7848500.0
2006-07-17 10:30:00	IWM	ETF	67.27	67.65	67.03	67.64	8773700.0
2006-07-17 11:00:00	IWM	ETF	67.64	67.88	67.35	67.47	9398900.0

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

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