PREVIEW / etf_30min / 2011-06-03

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-03.parquet
  size:    283 KB
  rows:    9,440

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-06-03 04:00:00	SPY	ETF	131.52	131.53	131.41	131.45	5000.0
2011-06-03 05:00:00	SPY	ETF	131.5	131.5	131.4	131.49	550.0
2011-06-03 05:30:00	SPY	ETF	131.36	131.36	131.36	131.36	100.0
2011-06-03 06:00:00	SPY	ETF	131.39	131.4	131.23	131.27	29375.0
2011-06-03 06:30:00	SPY	ETF	131.24	131.3	131.1	131.23	44183.0
2011-06-03 07:00:00	SPY	ETF	131.3	131.46	131.24	131.37	206200.0
2011-06-03 07:30:00	SPY	ETF	131.42	131.46	131.35	131.4	181150.0
2011-06-03 08:00:00	SPY	ETF	131.3	131.55	131.25	131.4	2233320.0
2011-06-03 08:30:00	SPY	ETF	131.38	131.4	129.97	130.24	11763109.0
2011-06-03 09:00:00	SPY	ETF	130.24	130.3	130.04	130.14	2375492.0
2011-06-03 09:30:00	SPY	ETF	130.15	130.65	130.08	130.54	27273062.0
2011-06-03 10:00:00	SPY	ETF	130.54	130.96	130.51	130.92	22689830.0
2011-06-03 10:30:00	SPY	ETF	130.92	131.28	130.89	131.03	22610769.0
2011-06-03 11:00:00	SPY	ETF	131.03	131.16	130.71	130.775	16287033.0
2011-06-03 11:30:00	SPY	ETF	130.77	131.0	130.62	130.99	9745772.0
2011-06-03 12:00:00	SPY	ETF	131.0	131.22	130.88	131.15	8333257.0
2011-06-03 12:30:00	SPY	ETF	131.16	131.42	131.08	131.21	8511637.0
2011-06-03 13:00:00	SPY	ETF	131.21	131.26	131.0	131.04	5007698.0
2011-06-03 13:30:00	SPY	ETF	131.04	131.2	130.93	130.96	4792738.0
2011-06-03 14:00:00	SPY	ETF	130.95	130.97	130.79	130.86	6217824.0
2011-06-03 14:30:00	SPY	ETF	130.87	130.89	130.58	130.6	9670331.0
2011-06-03 15:00:00	SPY	ETF	130.605	130.61	130.27	130.422	13630639.0
2011-06-03 15:30:00	SPY	ETF	130.43	130.8	130.28	130.43	25645357.0
2011-06-03 16:00:00	SPY	ETF	130.42	131.7117	130.07	130.18	13877725.0
2011-06-03 16:30:00	SPY	ETF	130.18	131.7117	130.17	130.28	10232452.0
2011-06-03 17:00:00	SPY	ETF	130.27	131.7117	130.26	130.27	6090922.0
2011-06-03 17:30:00	SPY	ETF	130.29	130.3	130.26	130.3	60520.0
2011-06-03 18:00:00	SPY	ETF	130.27	130.4	130.26	130.28	162491.0
2011-06-03 18:30:00	SPY	ETF	130.29	130.29	130.25	130.25	16914.0
2011-06-03 19:00:00	SPY	ETF	130.25	130.28	130.25	130.28	6475.0
2011-06-03 19:30:00	SPY	ETF	130.28	130.32	130.26	130.29	48269.0
2011-06-03 04:00:00	QQQ	ETF	57.05	57.05	57.05	57.05	100.0
2011-06-03 05:00:00	QQQ	ETF	57.02	57.02	57.02	57.02	100.0
2011-06-03 06:00:00	QQQ	ETF	57.0	57.0	56.93	56.93	320.0
2011-06-03 07:00:00	QQQ	ETF	56.95	57.0	56.95	56.98	22061.0
2011-06-03 07:30:00	QQQ	ETF	56.97	57.02	56.96	57.02	34772.0
2011-06-03 08:00:00	QQQ	ETF	57.01	57.02	56.93	57.02	132598.0
2011-06-03 08:30:00	QQQ	ETF	56.95	57.0	56.47	56.6	1930191.0
2011-06-03 09:00:00	QQQ	ETF	56.6	56.64	56.52	56.56	2164621.0
2011-06-03 09:30:00	QQQ	ETF	56.56	56.8	56.55	56.7	4440597.0
2011-06-03 10:00:00	QQQ	ETF	56.6906	56.84	56.66	56.8	5001665.0
2011-06-03 10:30:00	QQQ	ETF	56.8	56.99	56.79	56.93	3370696.0
2011-06-03 11:00:00	QQQ	ETF	56.92	56.94	56.72	56.75	3725389.0
2011-06-03 11:30:00	QQQ	ETF	56.75	56.82	56.68	56.79	1667798.0
2011-06-03 12:00:00	QQQ	ETF	56.8	56.85	56.77	56.82	1091352.0
2011-06-03 12:30:00	QQQ	ETF	56.83	56.88	56.77	56.8	1387755.0
2011-06-03 13:00:00	QQQ	ETF	56.8	56.849	56.74	56.76	793243.0
2011-06-03 13:30:00	QQQ	ETF	56.76	56.77	56.68	56.7	2089294.0
2011-06-03 14:00:00	QQQ	ETF	56.695	56.7	56.611	56.64	1647487.0
2011-06-03 14:30:00	QQQ	ETF	56.65	56.65	56.5	56.515	2091043.0

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

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