PREVIEW / etf_30min / 2007-08-29

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-29.parquet
  size:    124 KB
  rows:    4,511

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
2007-08-29 05:00:00	SPY	ETF	144.22	144.44	144.22	144.36	1300.0
2007-08-29 05:30:00	SPY	ETF	144.43	144.46	144.43	144.46	300.0
2007-08-29 06:00:00	SPY	ETF	144.35	144.43	144.35	144.36	13900.0
2007-08-29 06:30:00	SPY	ETF	144.45	144.6	144.45	144.6	84000.0
2007-08-29 07:00:00	SPY	ETF	144.63	144.69	144.33	144.6	141200.0
2007-08-29 07:30:00	SPY	ETF	144.6	144.78	144.46	144.5	211600.0
2007-08-29 08:00:00	SPY	ETF	144.58	144.66	143.75	144.44	3194500.0
2007-08-29 08:30:00	SPY	ETF	144.43	144.63	144.43	144.48	708300.0
2007-08-29 09:00:00	SPY	ETF	144.47	144.5	144.25	144.39	1417600.0
2007-08-29 09:30:00	SPY	ETF	144.37	144.79	144.18	144.28	21900297.0
2007-08-29 10:00:00	SPY	ETF	144.27	144.44	143.96	144.25	18440600.0
2007-08-29 10:30:00	SPY	ETF	144.24	144.77	144.041	144.75	11824400.0
2007-08-29 11:00:00	SPY	ETF	144.75	145.07	144.69	144.79	12189200.0
2007-08-29 11:30:00	SPY	ETF	144.8	145.63	144.79	145.25	13780400.0
2007-08-29 12:00:00	SPY	ETF	145.26	145.3	144.99	144.99	6485300.0
2007-08-29 12:30:00	SPY	ETF	144.99	145.15	144.7	144.81	7079800.0
2007-08-29 13:00:00	SPY	ETF	144.82	145.06	144.48	144.61	8078200.0
2007-08-29 13:30:00	SPY	ETF	144.6	144.84	144.47	144.78	7239000.0
2007-08-29 14:00:00	SPY	ETF	144.79	145.33	144.79	145.19	10450700.0
2007-08-29 14:30:00	SPY	ETF	145.19	145.68	145.18	145.44	15360900.0
2007-08-29 15:00:00	SPY	ETF	145.43	146.16	145.43	146.13	20965700.0
2007-08-29 15:30:00	SPY	ETF	146.13	146.74	146.13	146.71	29821500.0
2007-08-29 16:00:00	SPY	ETF	146.7	146.73	145.1705	146.58	9830700.0
2007-08-29 16:30:00	SPY	ETF	146.58	146.58	143.562	146.54	4367300.0
2007-08-29 17:00:00	SPY	ETF	146.56	146.78	146.55	146.72	76600.0
2007-08-29 17:30:00	SPY	ETF	146.63	146.63	146.54	146.59	56000.0
2007-08-29 18:00:00	SPY	ETF	146.65	146.76	146.65	146.74	122900.0
2007-08-29 18:30:00	SPY	ETF	146.7	146.76	146.7	146.76	1800.0
2007-08-29 19:00:00	SPY	ETF	146.69	146.69	146.63	146.63	30800.0
2007-08-29 19:30:00	SPY	ETF	146.6	146.65	146.53	146.55	7100.0
2007-08-29 04:00:00	QQQ	ETF	46.97	46.97	46.97	46.97	100.0
2007-08-29 05:00:00	QQQ	ETF	47.03	47.03	47.03	47.03	200.0
2007-08-29 07:00:00	QQQ	ETF	47.12	47.17	47.04	47.09	280111.0
2007-08-29 07:30:00	QQQ	ETF	47.09	47.11	47.05	47.05	247734.0
2007-08-29 08:00:00	QQQ	ETF	47.05	47.06	46.94	47.0	438799.0
2007-08-29 08:30:00	QQQ	ETF	46.99	47.04	46.98	47.0	785743.0
2007-08-29 09:00:00	QQQ	ETF	47.0	47.06	46.99	47.06	425680.0
2007-08-29 09:30:00	QQQ	ETF	47.05	47.21	47.05	47.12	11892108.0
2007-08-29 10:00:00	QQQ	ETF	47.12	47.22	47.06	47.13	5607137.0
2007-08-29 10:30:00	QQQ	ETF	47.13	47.39	47.09	47.35	8062618.0
2007-08-29 11:00:00	QQQ	ETF	47.35	47.46	47.33	47.3505	5627890.0
2007-08-29 11:30:00	QQQ	ETF	47.36	47.52	47.34	47.46	4527896.0
2007-08-29 12:00:00	QQQ	ETF	47.47	47.48	47.382	47.4195	3248202.0
2007-08-29 12:30:00	QQQ	ETF	47.4199	47.45	47.32	47.3491	2251604.0
2007-08-29 13:00:00	QQQ	ETF	47.35	47.43	47.27	47.28	3317658.0
2007-08-29 13:30:00	QQQ	ETF	47.28	47.35	47.23	47.32	4029565.0
2007-08-29 14:00:00	QQQ	ETF	47.32	47.48	47.32	47.46	4374737.0
2007-08-29 14:30:00	QQQ	ETF	47.4614	47.62	47.45	47.58	6375938.0
2007-08-29 15:00:00	QQQ	ETF	47.59	47.88	47.58	47.87	9892000.0
2007-08-29 15:30:00	QQQ	ETF	47.88	48.12	47.87	48.1	18027581.0

> showing 50 of 4,511 rows — these rows as CSV

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