PREVIEW / etf_30min / 2011-08-04

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-04.parquet
  size:    336 KB
  rows:    10,908

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
2011-08-04 04:00:00	SPY	ETF	126.3	126.3	125.77	125.86	2700.0
2011-08-04 04:30:00	SPY	ETF	125.82	125.95	125.82	125.92	1000.0
2011-08-04 05:00:00	SPY	ETF	125.99	125.99	125.52	125.6	12260.0
2011-08-04 05:30:00	SPY	ETF	125.6	125.67	125.15	125.48	27100.0
2011-08-04 06:00:00	SPY	ETF	125.3	125.4	124.6	124.88	68860.0
2011-08-04 06:30:00	SPY	ETF	124.86	125.12	124.75	125.05	98670.0
2011-08-04 07:00:00	SPY	ETF	125.06	125.14	124.82	124.89	622793.0
2011-08-04 07:30:00	SPY	ETF	124.92	125.24	124.91	124.91	1279435.0
2011-08-04 08:00:00	SPY	ETF	124.93	125.17	124.27	124.43	3178514.0
2011-08-04 08:30:00	SPY	ETF	124.45	125.38	124.12	124.88	9282053.0
2011-08-04 09:00:00	SPY	ETF	124.88	125.32	124.36	124.43	4974253.0
2011-08-04 09:30:00	SPY	ETF	124.42	124.62	123.74	124.16	37369023.0
2011-08-04 10:00:00	SPY	ETF	124.16	124.37	123.47	123.89	30177758.0
2011-08-04 10:30:00	SPY	ETF	123.89	124.19	123.03	123.19	36551214.0
2011-08-04 11:00:00	SPY	ETF	123.19	123.46	122.61	122.67	39052222.0
2011-08-04 11:30:00	SPY	ETF	122.67	123.06	121.76	122.41	42694809.0
2011-08-04 12:00:00	SPY	ETF	122.42	122.95	122.25	122.85	28534835.0
2011-08-04 12:30:00	SPY	ETF	122.86	123.33	122.84	122.86	18149413.0
2011-08-04 13:00:00	SPY	ETF	122.86	123.16	122.53	122.971	15995701.0
2011-08-04 13:30:00	SPY	ETF	122.98	123.0	122.19	122.36	19413205.0
2011-08-04 14:00:00	SPY	ETF	122.37	122.86	121.35	121.57	33304435.0
2011-08-04 14:30:00	SPY	ETF	121.5715	122.45	121.45	122.01	31294457.0
2011-08-04 15:00:00	SPY	ETF	122.0	122.47	121.11	121.12	38029215.0
2011-08-04 15:30:00	SPY	ETF	121.151	121.51	120.06	120.2	85489717.0
2011-08-04 16:00:00	SPY	ETF	120.2	126.1943	119.82	120.45	19769232.0
2011-08-04 16:30:00	SPY	ETF	120.45	126.4948	120.04	120.06	14108221.0
2011-08-04 17:00:00	SPY	ETF	120.08	120.29	120.05	120.19	3480306.0
2011-08-04 17:30:00	SPY	ETF	120.19	120.37	120.08	120.26	204341.0
2011-08-04 18:00:00	SPY	ETF	120.28	120.5	120.1	120.21	1258655.0
2011-08-04 18:30:00	SPY	ETF	120.23	120.38	120.13	120.31	38656.0
2011-08-04 19:00:00	SPY	ETF	120.23	120.23	119.97	120.16	172222.0
2011-08-04 19:30:00	SPY	ETF	120.17	120.21	120.0	120.06	105120.0
2011-08-04 04:00:00	QQQ	ETF	56.61	56.61	56.56	56.56	600.0
2011-08-04 04:30:00	QQQ	ETF	56.48	56.48	56.48	56.48	200.0
2011-08-04 05:00:00	QQQ	ETF	56.47	56.47	56.47	56.47	200.0
2011-08-04 05:30:00	QQQ	ETF	56.38	56.38	56.25	56.29	1400.0
2011-08-04 06:00:00	QQQ	ETF	56.34	56.35	56.06	56.11	83100.0
2011-08-04 06:30:00	QQQ	ETF	56.13	56.2	56.1	56.2	6500.0
2011-08-04 07:00:00	QQQ	ETF	56.2	56.23	56.11	56.14	41500.0
2011-08-04 07:30:00	QQQ	ETF	56.16	56.28	56.16	56.21	273380.0
2011-08-04 08:00:00	QQQ	ETF	56.2	56.23	55.93	56.0	1278533.0
2011-08-04 08:30:00	QQQ	ETF	56.01	56.36	55.86	56.19	1438273.0
2011-08-04 09:00:00	QQQ	ETF	56.18	56.36	55.97	55.98	1072829.0
2011-08-04 09:30:00	QQQ	ETF	55.98	56.09	55.69	55.87	11935899.0
2011-08-04 10:00:00	QQQ	ETF	55.86	56.01	55.5	55.72	10946033.0
2011-08-04 10:30:00	QQQ	ETF	55.71	55.91	55.33	55.39	10872475.0
2011-08-04 11:00:00	QQQ	ETF	55.39	55.55	55.18	55.2	8921005.0
2011-08-04 11:30:00	QQQ	ETF	55.19	55.36	54.83	55.0988	10294121.0
2011-08-04 12:00:00	QQQ	ETF	55.1	55.41	55.02	55.37	6104192.0
2011-08-04 12:30:00	QQQ	ETF	55.36	55.65	55.36	55.42	5152100.0

> showing 50 of 10,908 rows — these rows as CSV

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