PREVIEW / etf_30min / 2010-12-01

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-12-01.parquet
  size:    274 KB
  rows:    9,271

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
2010-12-01 04:00:00	SPY	ETF	119.19	119.33	119.19	119.3	9925.0
2010-12-01 04:30:00	SPY	ETF	119.14	119.39	119.14	119.39	325.0
2010-12-01 05:00:00	SPY	ETF	119.37	119.62	119.35	119.62	2420.0
2010-12-01 05:30:00	SPY	ETF	119.46	119.56	119.46	119.56	3500.0
2010-12-01 06:00:00	SPY	ETF	119.61	119.81	119.58	119.81	5824.0
2010-12-01 06:30:00	SPY	ETF	119.82	119.93	119.79	119.83	156714.0
2010-12-01 07:00:00	SPY	ETF	119.83	119.86	119.7	119.7	689432.0
2010-12-01 07:30:00	SPY	ETF	119.73	119.99	119.63	119.88	1113253.0
2010-12-01 08:00:00	SPY	ETF	119.85	120.07	119.63	120.0	3064271.0
2010-12-01 08:30:00	SPY	ETF	119.98	120.15	119.94	120.13	1515766.0
2010-12-01 09:00:00	SPY	ETF	120.13	120.23	118.49	120.2	2196109.0
2010-12-01 09:30:00	SPY	ETF	120.2	120.71	120.19	120.65	29037568.0
2010-12-01 10:00:00	SPY	ETF	120.65	120.8	120.31	120.35	15504521.0
2010-12-01 10:30:00	SPY	ETF	120.35	120.6	120.31	120.4801	12421363.0
2010-12-01 11:00:00	SPY	ETF	120.48	120.58	120.41	120.5	6984876.0
2010-12-01 11:30:00	SPY	ETF	120.51	121.13	120.5	121.058	16948651.0
2010-12-01 12:00:00	SPY	ETF	121.07	121.24	120.93	121.01	13876350.0
2010-12-01 12:30:00	SPY	ETF	121.02	121.08	120.93	121.0	5871456.0
2010-12-01 13:00:00	SPY	ETF	121.0	121.19	120.85	120.89	17208754.0
2010-12-01 13:30:00	SPY	ETF	120.89	121.05	120.845	120.98	12357208.0
2010-12-01 14:00:00	SPY	ETF	120.995	121.12	120.87	121.0	8484557.0
2010-12-01 14:30:00	SPY	ETF	121.0	121.21	121.0	121.1526	7579835.0
2010-12-01 15:00:00	SPY	ETF	121.16	121.16	120.95	121.0505	9933287.0
2010-12-01 15:30:00	SPY	ETF	121.05	121.16	120.88	121.01	22898227.0
2010-12-01 16:00:00	SPY	ETF	121.01	121.05	120.325	120.92	9346737.0
2010-12-01 16:30:00	SPY	ETF	120.9	121.01	118.49	120.91	9281179.0
2010-12-01 17:00:00	SPY	ETF	120.9	120.98	120.89	120.91	5155067.0
2010-12-01 17:30:00	SPY	ETF	120.91	120.96	120.9	120.94	57249.0
2010-12-01 18:00:00	SPY	ETF	120.95	121.07	120.95	121.05	125698.0
2010-12-01 18:30:00	SPY	ETF	121.06	121.09	121.05	121.09	20545.0
2010-12-01 19:00:00	SPY	ETF	121.09	121.13	121.03	121.03	36765.0
2010-12-01 19:30:00	SPY	ETF	121.01	121.1	120.92	121.1	50588.0
2010-12-01 04:00:00	QQQ	ETF	52.3	52.41	52.3	52.38	1900.0
2010-12-01 04:30:00	QQQ	ETF	52.4	52.4	52.4	52.4	100.0
2010-12-01 05:00:00	QQQ	ETF	52.37	52.5	52.37	52.5	2700.0
2010-12-01 05:30:00	QQQ	ETF	52.52	52.52	52.52	52.52	100.0
2010-12-01 06:00:00	QQQ	ETF	52.55	52.62	52.53	52.62	3675.0
2010-12-01 06:30:00	QQQ	ETF	52.59	52.62	52.58	52.62	2313.0
2010-12-01 07:00:00	QQQ	ETF	52.59	52.59	52.53	52.54	47784.0
2010-12-01 07:30:00	QQQ	ETF	52.53	52.69	52.5	52.63	392153.0
2010-12-01 08:00:00	QQQ	ETF	52.61	52.76	52.6	52.74	2305433.0
2010-12-01 08:30:00	QQQ	ETF	52.74	52.83	52.74	52.82	513172.0
2010-12-01 09:00:00	QQQ	ETF	52.83	52.88	52.77	52.88	462124.0
2010-12-01 09:30:00	QQQ	ETF	52.88	53.28	52.84	53.26	14134682.0
2010-12-01 10:00:00	QQQ	ETF	53.25	53.3	53.0899	53.11	5367890.0
2010-12-01 10:30:00	QQQ	ETF	53.11	53.28	53.1	53.23	4717081.0
2010-12-01 11:00:00	QQQ	ETF	53.23	53.26	53.18	53.23	2641318.0
2010-12-01 11:30:00	QQQ	ETF	53.24	53.43	53.22	53.4	5358516.0
2010-12-01 12:00:00	QQQ	ETF	53.4	53.46	53.32	53.37	7265077.0
2010-12-01 12:30:00	QQQ	ETF	53.375	53.4	53.32	53.38	1416151.0

> showing 50 of 9,271 rows — these rows as CSV

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