PREVIEW / etf_30min / 2011-05-23

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-23.parquet
  size:    287 KB
  rows:    9,834

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-05-23 04:00:00	SPY	ETF	132.6	132.6	132.08	132.15	7913.0
2011-05-23 04:30:00	SPY	ETF	132.24	132.37	132.22	132.24	2724.0
2011-05-23 05:00:00	SPY	ETF	132.26	132.26	131.76	131.98	38400.0
2011-05-23 05:30:00	SPY	ETF	131.97	132.09	131.96	132.04	7025.0
2011-05-23 06:00:00	SPY	ETF	132.09	132.12	132.03	132.12	9067.0
2011-05-23 06:30:00	SPY	ETF	132.14	132.23	131.96	132.0	182934.0
2011-05-23 07:00:00	SPY	ETF	132.0	132.16	131.96	132.09	198871.0
2011-05-23 07:30:00	SPY	ETF	132.1	132.33	132.07	132.16	185356.0
2011-05-23 08:00:00	SPY	ETF	132.16	133.07	131.97	132.1	1873817.0
2011-05-23 08:30:00	SPY	ETF	132.08	132.2476	132.01	132.18	1345056.0
2011-05-23 09:00:00	SPY	ETF	132.18	132.19	131.95	131.98	1646540.0
2011-05-23 09:30:00	SPY	ETF	131.98	132.25	131.74	132.065	22279718.0
2011-05-23 10:00:00	SPY	ETF	132.06	132.28	131.87	132.075	14891033.0
2011-05-23 10:30:00	SPY	ETF	132.075	132.27	131.91	132.0	10737019.0
2011-05-23 11:00:00	SPY	ETF	132.0	132.19	131.82	131.99	10472974.0
2011-05-23 11:30:00	SPY	ETF	131.985	132.01	131.65	131.82	11485618.0
2011-05-23 12:00:00	SPY	ETF	131.81	131.92	131.59	131.91	9716623.0
2011-05-23 12:30:00	SPY	ETF	131.91	132.03	131.835	131.97	6292664.0
2011-05-23 13:00:00	SPY	ETF	131.96	133.6475	131.76	131.81	4888377.0
2011-05-23 13:30:00	SPY	ETF	131.811	132.11	131.81	132.04	7098143.0
2011-05-23 14:00:00	SPY	ETF	132.04	132.28	132.0	132.1	7832591.0
2011-05-23 14:30:00	SPY	ETF	132.1	132.46	132.09	132.28	10002110.0
2011-05-23 15:00:00	SPY	ETF	132.25	132.435	132.13	132.185	11527995.0
2011-05-23 15:30:00	SPY	ETF	132.1805	132.22	131.96	132.04	23504612.0
2011-05-23 16:00:00	SPY	ETF	132.05	132.0795	131.75	132.01	9372323.0
2011-05-23 16:30:00	SPY	ETF	132.0	132.01	131.92	131.93	937272.0
2011-05-23 17:00:00	SPY	ETF	131.95	131.96	131.89	131.91	60070.0
2011-05-23 17:30:00	SPY	ETF	131.91	132.0	131.91	131.95	14471.0
2011-05-23 18:00:00	SPY	ETF	131.94	132.04	131.85	131.92	275148.0
2011-05-23 18:30:00	SPY	ETF	131.92	131.95	131.87	131.88	19195.0
2011-05-23 19:00:00	SPY	ETF	131.87	131.88	131.78	131.78	61128.0
2011-05-23 19:30:00	SPY	ETF	131.77	131.92	131.76	131.88	95457.0
2011-05-23 04:00:00	QQQ	ETF	57.4	57.4	57.12	57.12	623.0
2011-05-23 05:00:00	QQQ	ETF	57.06	57.06	57.0	57.0	800.0
2011-05-23 05:30:00	QQQ	ETF	56.98	57.08	56.98	57.04	500.0
2011-05-23 06:00:00	QQQ	ETF	57.09	57.12	57.09	57.09	5800.0
2011-05-23 06:30:00	QQQ	ETF	57.08	57.1	57.04	57.05	3000.0
2011-05-23 07:00:00	QQQ	ETF	57.07	57.08	57.02	57.06	25356.0
2011-05-23 07:30:00	QQQ	ETF	57.07	57.14	57.06	57.07	13700.0
2011-05-23 08:00:00	QQQ	ETF	57.07	57.26	57.0	57.03	254975.0
2011-05-23 08:30:00	QQQ	ETF	57.01	57.1	57.01	57.1	194368.0
2011-05-23 09:00:00	QQQ	ETF	57.09	57.09	56.98	56.99	470465.0
2011-05-23 09:30:00	QQQ	ETF	56.99	57.0	56.67	56.755	5322095.0
2011-05-23 10:00:00	QQQ	ETF	56.75	56.88	56.65	56.705	3392838.0
2011-05-23 10:30:00	QQQ	ETF	56.71	56.88	56.7	56.79	3249311.0
2011-05-23 11:00:00	QQQ	ETF	56.78	56.87	56.73	56.81	1742872.0
2011-05-23 11:30:00	QQQ	ETF	56.81	56.83	56.66	56.78	3009006.0
2011-05-23 12:00:00	QQQ	ETF	56.7785	56.8	56.67	56.78	2155921.0
2011-05-23 12:30:00	QQQ	ETF	56.7801	56.869	56.75	56.86	1465793.0
2011-05-23 13:00:00	QQQ	ETF	56.85	56.87	56.76	56.77	1100740.0

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

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