PREVIEW / etf_30min / 2011-07-14

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-14.parquet
  size:    285 KB
  rows:    9,472

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-07-14 04:00:00	SPY	ETF	131.85	132.03	131.85	132.03	3187.0
2011-07-14 04:30:00	SPY	ETF	132.09	132.2	132.09	132.12	11247.0
2011-07-14 05:00:00	SPY	ETF	132.14	132.27	132.14	132.17	1495.0
2011-07-14 05:30:00	SPY	ETF	132.07	132.07	131.77	131.77	2608.0
2011-07-14 06:00:00	SPY	ETF	131.69	132.24	131.58	131.66	14550.0
2011-07-14 06:30:00	SPY	ETF	131.76	131.9	131.55	131.8	156260.0
2011-07-14 07:00:00	SPY	ETF	131.83	132.2	131.53	132.17	430035.0
2011-07-14 07:30:00	SPY	ETF	132.2	132.2	131.98	132.08	1101154.0
2011-07-14 08:00:00	SPY	ETF	132.04	132.15	131.14	131.96	1784100.0
2011-07-14 08:30:00	SPY	ETF	131.98	132.25	131.94	132.21	2187690.0
2011-07-14 09:00:00	SPY	ETF	132.21	132.35	132.07	132.16	1612103.0
2011-07-14 09:30:00	SPY	ETF	132.17	132.72	131.97	132.65	18504311.0
2011-07-14 10:00:00	SPY	ETF	132.64	132.78	132.44	132.66	13000932.0
2011-07-14 10:30:00	SPY	ETF	132.66	132.7	131.76	131.82	24133974.0
2011-07-14 11:00:00	SPY	ETF	131.81	132.07	131.79	132.0	10480290.0
2011-07-14 11:30:00	SPY	ETF	131.99	132.01	131.61	131.81	11017107.0
2011-07-14 12:00:00	SPY	ETF	131.81	131.81	131.24	131.3801	11697874.0
2011-07-14 12:30:00	SPY	ETF	131.38	131.58	131.12	131.17	10409728.0
2011-07-14 13:00:00	SPY	ETF	131.17	131.24	130.68	131.1562	19533023.0
2011-07-14 13:30:00	SPY	ETF	131.16	131.69	131.06	131.48	28013918.0
2011-07-14 14:00:00	SPY	ETF	131.48	131.68	131.17	131.31	13750389.0
2011-07-14 14:30:00	SPY	ETF	131.32	131.39	131.03	131.18	9610874.0
2011-07-14 15:00:00	SPY	ETF	131.185	131.26	130.77	131.02	11265000.0
2011-07-14 15:30:00	SPY	ETF	131.02	131.31	130.72	130.94	26278261.0
2011-07-14 16:00:00	SPY	ETF	130.95	132.71	130.91	131.22	7162612.0
2011-07-14 16:30:00	SPY	ETF	131.24	131.35	131.14	131.15	454927.0
2011-07-14 17:00:00	SPY	ETF	131.16	131.25	131.11	131.25	167763.0
2011-07-14 17:30:00	SPY	ETF	131.25	131.29	131.21	131.25	132737.0
2011-07-14 18:00:00	SPY	ETF	131.25	131.29	130.94	131.28	246855.0
2011-07-14 18:30:00	SPY	ETF	131.29	131.31	131.15	131.17	42606.0
2011-07-14 19:00:00	SPY	ETF	131.17	131.26	131.17	131.22	63810.0
2011-07-14 19:30:00	SPY	ETF	131.22	131.22	130.41	130.81	356048.0
2011-07-14 04:00:00	QQQ	ETF	57.66	57.8	57.66	57.8	890.0
2011-07-14 05:00:00	QQQ	ETF	57.84	57.94	57.84	57.92	1100.0
2011-07-14 05:30:00	QQQ	ETF	57.8	57.8	57.8	57.8	100.0
2011-07-14 06:30:00	QQQ	ETF	57.76	57.76	57.76	57.76	900.0
2011-07-14 07:00:00	QQQ	ETF	57.84	57.91	57.77	57.88	61310.0
2011-07-14 07:30:00	QQQ	ETF	57.95	57.96	57.83	57.86	78850.0
2011-07-14 08:00:00	QQQ	ETF	57.88	57.92	57.81	57.82	1234715.0
2011-07-14 08:30:00	QQQ	ETF	57.83	57.94	57.82	57.93	992375.0
2011-07-14 09:00:00	QQQ	ETF	57.92	57.95	57.85	57.93	325340.0
2011-07-14 09:30:00	QQQ	ETF	57.93	58.12	57.74	58.11	6478106.0
2011-07-14 10:00:00	QQQ	ETF	58.12	58.18	58.03	58.095	3651454.0
2011-07-14 10:30:00	QQQ	ETF	58.1	58.13	57.6	57.64	7928057.0
2011-07-14 11:00:00	QQQ	ETF	57.63	57.76	57.62	57.68	5204315.0
2011-07-14 11:30:00	QQQ	ETF	57.67	57.68	57.47	57.57	5029860.0
2011-07-14 12:00:00	QQQ	ETF	57.56	57.56	57.24	57.31	2983895.0
2011-07-14 12:30:00	QQQ	ETF	57.31	57.3695	57.1	57.12	3499596.0
2011-07-14 13:00:00	QQQ	ETF	57.12	57.17	56.87	57.01	6295631.0
2011-07-14 13:30:00	QQQ	ETF	57.01	57.33	56.98	57.26	8130513.0

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

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