PREVIEW / etf_30min / 2010-11-18

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-18.parquet
  size:    266 KB
  rows:    9,053

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-11-18 04:00:00	SPY	ETF	118.75	119.51	118.75	119.4	49408.0
2010-11-18 04:30:00	SPY	ETF	119.45	119.48	119.45	119.48	1850.0
2010-11-18 05:00:00	SPY	ETF	119.5	119.5	119.4	119.4	3400.0
2010-11-18 05:30:00	SPY	ETF	119.45	119.51	119.44	119.5	2750.0
2010-11-18 06:00:00	SPY	ETF	119.45	119.53	119.45	119.5	7800.0
2010-11-18 06:30:00	SPY	ETF	119.49	119.63	119.49	119.58	119944.0
2010-11-18 07:00:00	SPY	ETF	119.58	119.61	119.46	119.52	351710.0
2010-11-18 07:30:00	SPY	ETF	119.51	119.55	119.4	119.41	307229.0
2010-11-18 08:00:00	SPY	ETF	119.4	119.55	119.35	119.48	509120.0
2010-11-18 08:30:00	SPY	ETF	119.5	119.6	119.39	119.4	1944583.0
2010-11-18 09:00:00	SPY	ETF	119.4	119.48	119.33	119.37	1864701.0
2010-11-18 09:30:00	SPY	ETF	119.36	119.77	119.35	119.53	22509075.0
2010-11-18 10:00:00	SPY	ETF	119.53	120.34	119.52	120.26	27042406.0
2010-11-18 10:30:00	SPY	ETF	120.27	120.31	120.17	120.24	9183731.0
2010-11-18 11:00:00	SPY	ETF	120.25	120.36	120.11	120.19	11098834.0
2010-11-18 11:30:00	SPY	ETF	120.18	120.25	120.08	120.1599	6132200.0
2010-11-18 12:00:00	SPY	ETF	120.1592	120.39	120.14	120.28	7231789.0
2010-11-18 12:30:00	SPY	ETF	120.28	120.38	120.2	120.32	4854749.0
2010-11-18 13:00:00	SPY	ETF	120.32	120.33	120.24	120.27	3837435.0
2010-11-18 13:30:00	SPY	ETF	120.27	120.32	120.16	120.17	4951660.0
2010-11-18 14:00:00	SPY	ETF	120.17	120.27	120.01	120.06	10062037.0
2010-11-18 14:30:00	SPY	ETF	120.05	120.29	120.04	120.21	9272143.0
2010-11-18 15:00:00	SPY	ETF	120.21	120.27	120.04	120.13	6997008.0
2010-11-18 15:30:00	SPY	ETF	120.13	120.23	119.85	119.97	25598662.0
2010-11-18 16:00:00	SPY	ETF	119.98	120.31	119.5652	120.2	15956251.0
2010-11-18 16:30:00	SPY	ETF	120.22	120.23	118.188	120.17	5616521.0
2010-11-18 17:00:00	SPY	ETF	120.16	120.3	120.1537	120.3	9300099.0
2010-11-18 17:30:00	SPY	ETF	120.25	120.27	120.24	120.26	29185.0
2010-11-18 18:00:00	SPY	ETF	120.26	120.38	120.26	120.37	223697.0
2010-11-18 18:30:00	SPY	ETF	120.36	120.44	120.29	120.43	85524.0
2010-11-18 19:00:00	SPY	ETF	120.42	120.42	120.3	120.34	53041.0
2010-11-18 19:30:00	SPY	ETF	120.33	120.33	120.26	120.3	35873.0
2010-11-18 04:00:00	QQQ	ETF	52.0	52.24	52.0	52.19	12038.0
2010-11-18 04:30:00	QQQ	ETF	52.21	52.21	52.19	52.19	200.0
2010-11-18 05:00:00	QQQ	ETF	52.19	52.19	52.19	52.19	300.0
2010-11-18 05:30:00	QQQ	ETF	52.2	52.2	52.2	52.2	4000.0
2010-11-18 06:00:00	QQQ	ETF	52.19	52.23	52.19	52.23	4100.0
2010-11-18 06:30:00	QQQ	ETF	52.18	52.23	52.18	52.23	6875.0
2010-11-18 07:00:00	QQQ	ETF	52.21	52.22	52.18	52.2	129848.0
2010-11-18 07:30:00	QQQ	ETF	52.18	52.19	52.14	52.16	57375.0
2010-11-18 08:00:00	QQQ	ETF	52.15	52.21	52.15	52.2	255489.0
2010-11-18 08:30:00	QQQ	ETF	52.19	52.23	52.14	52.15	510675.0
2010-11-18 09:00:00	QQQ	ETF	52.16	52.19	52.13	52.15	782806.0
2010-11-18 09:30:00	QQQ	ETF	52.15	52.37	52.13	52.3	8325430.0
2010-11-18 10:00:00	QQQ	ETF	52.29	52.67	52.29	52.64	9982928.0
2010-11-18 10:30:00	QQQ	ETF	52.635	52.68	52.61	52.64	3028290.0
2010-11-18 11:00:00	QQQ	ETF	52.65	52.7	52.56	52.59	4319861.0
2010-11-18 11:30:00	QQQ	ETF	52.59	52.7	52.58	52.69	2495844.0
2010-11-18 12:00:00	QQQ	ETF	52.69	52.79	52.68	52.75	1826100.0
2010-11-18 12:30:00	QQQ	ETF	52.76	52.76	52.6901	52.72	1584046.0

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

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