PREVIEW / etf_30min / 2011-11-02

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-02.parquet
  size:    288 KB
  rows:    9,544

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-11-02 04:00:00	SPY	ETF	123.63	124.25	123.6	124.15	24329.0
2011-11-02 04:30:00	SPY	ETF	123.83	124.2	123.78	123.81	5560.0
2011-11-02 05:00:00	SPY	ETF	124.0	124.08	123.45	123.48	39250.0
2011-11-02 05:30:00	SPY	ETF	123.5	123.5	122.61	122.8	63430.0
2011-11-02 06:00:00	SPY	ETF	122.8	123.25	122.8	123.24	37706.0
2011-11-02 06:30:00	SPY	ETF	123.24	123.44	123.16	123.25	117291.0
2011-11-02 07:00:00	SPY	ETF	123.23	123.58	123.08	123.51	336910.0
2011-11-02 07:30:00	SPY	ETF	123.51	123.63	123.31	123.4	459284.0
2011-11-02 08:00:00	SPY	ETF	123.43	124.04	123.39	123.68	1898635.0
2011-11-02 08:30:00	SPY	ETF	123.68	123.68	123.43	123.62	761118.0
2011-11-02 09:00:00	SPY	ETF	123.63	123.98	123.63	123.84	2028514.0
2011-11-02 09:30:00	SPY	ETF	123.83	124.02	123.38	123.53	22684888.0
2011-11-02 10:00:00	SPY	ETF	123.53	123.81	123.28	123.77	15380307.0
2011-11-02 10:30:00	SPY	ETF	123.77	124.4	123.47	124.22	20112950.0
2011-11-02 11:00:00	SPY	ETF	124.22	124.4	124.14	124.1905	11570580.0
2011-11-02 11:30:00	SPY	ETF	124.18	124.23	124.0	124.07	8414979.0
2011-11-02 12:00:00	SPY	ETF	124.068	124.14	123.77	124.0	9860826.0
2011-11-02 12:30:00	SPY	ETF	123.99	124.24	123.4	123.44	18212809.0
2011-11-02 13:00:00	SPY	ETF	123.45	123.49	122.7905	123.07	20968166.0
2011-11-02 13:30:00	SPY	ETF	123.07	123.47	123.02	123.07	10027384.0
2011-11-02 14:00:00	SPY	ETF	123.07	123.36	122.8	123.1298	16756114.0
2011-11-02 14:30:00	SPY	ETF	123.13	123.84	123.03	123.7	12818362.0
2011-11-02 15:00:00	SPY	ETF	123.7	124.22	123.44	123.955	17321141.0
2011-11-02 15:30:00	SPY	ETF	123.96	124.12	123.52	123.99	31642421.0
2011-11-02 16:00:00	SPY	ETF	123.99	124.0705	121.967	124.0	15094335.0
2011-11-02 16:30:00	SPY	ETF	123.99	124.09	123.97	124.06	3866235.0
2011-11-02 17:00:00	SPY	ETF	124.05	124.29	124.04	124.25	201386.0
2011-11-02 17:30:00	SPY	ETF	124.25	124.3	124.25	124.25	160581.0
2011-11-02 18:00:00	SPY	ETF	124.24	124.33	123.99	124.05	200680.0
2011-11-02 18:30:00	SPY	ETF	124.04	124.09	123.51	123.67	546460.0
2011-11-02 19:00:00	SPY	ETF	123.69	123.81	123.41	123.53	62640.0
2011-11-02 19:30:00	SPY	ETF	123.58	123.58	123.18	123.27	195905.0
2011-11-02 04:00:00	QQQ	ETF	57.09	57.24	57.09	57.24	1051.0
2011-11-02 04:30:00	QQQ	ETF	57.2	57.2	57.17	57.17	250.0
2011-11-02 05:30:00	QQQ	ETF	56.92	56.92	56.66	56.66	400.0
2011-11-02 06:00:00	QQQ	ETF	56.66	56.66	56.66	56.66	400.0
2011-11-02 07:00:00	QQQ	ETF	56.67	56.84	56.67	56.81	168250.0
2011-11-02 07:30:00	QQQ	ETF	56.81	56.85	56.74	56.8	61330.0
2011-11-02 08:00:00	QQQ	ETF	56.79	56.95	56.76	56.87	229599.0
2011-11-02 08:30:00	QQQ	ETF	56.85	56.88	56.78	56.86	100575.0
2011-11-02 09:00:00	QQQ	ETF	56.87	57.05	56.87	57.02	809389.0
2011-11-02 09:30:00	QQQ	ETF	57.01	57.05	56.66	56.71	7966249.0
2011-11-02 10:00:00	QQQ	ETF	56.72	56.81	56.56	56.79	4659185.0
2011-11-02 10:30:00	QQQ	ETF	56.8	57.12	56.6905	57.0607	4887533.0
2011-11-02 11:00:00	QQQ	ETF	57.07	57.16	56.97	57.04	5998755.0
2011-11-02 11:30:00	QQQ	ETF	57.04	57.06	56.89	56.93	1937202.0
2011-11-02 12:00:00	QQQ	ETF	56.92	56.95	56.76	56.8693	2118673.0
2011-11-02 12:30:00	QQQ	ETF	56.854	56.99	56.66	56.675	3535534.0
2011-11-02 13:00:00	QQQ	ETF	56.68	56.7101	56.45	56.52	3742136.0
2011-11-02 13:30:00	QQQ	ETF	56.5187	56.65	56.47	56.5	2167064.0

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

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