PREVIEW / etf_30min / 2012-07-26

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-26.parquet
  size:    287 KB
  rows:    9,705

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
2012-07-26 04:00:00	SPY	ETF	133.9	133.9	133.83	133.83	300.0
2012-07-26 04:30:00	SPY	ETF	133.88	133.88	133.76	133.8	1247.0
2012-07-26 05:00:00	SPY	ETF	133.66	133.66	133.44	133.6	19360.0
2012-07-26 05:30:00	SPY	ETF	133.62	133.68	133.62	133.68	22400.0
2012-07-26 06:00:00	SPY	ETF	133.55	134.78	133.55	134.51	86067.0
2012-07-26 06:30:00	SPY	ETF	134.56	135.1	134.53	135.0	274105.0
2012-07-26 07:00:00	SPY	ETF	134.99	136.02	134.99	135.47	1181697.0
2012-07-26 07:30:00	SPY	ETF	135.46	135.74	135.37	135.58	1724050.0
2012-07-26 08:00:00	SPY	ETF	135.56	135.97	134.63	135.56	1766619.0
2012-07-26 08:30:00	SPY	ETF	135.52	136.0	135.52	135.81	2787759.0
2012-07-26 09:00:00	SPY	ETF	135.82	135.94	135.62	135.89	1306594.0
2012-07-26 09:30:00	SPY	ETF	135.89	136.27	135.88	135.98	19849458.0
2012-07-26 10:00:00	SPY	ETF	135.98	136.31	135.82	136.045	12645004.0
2012-07-26 10:30:00	SPY	ETF	136.05	136.19	135.53	135.719	12318601.0
2012-07-26 11:00:00	SPY	ETF	135.71	135.74	135.37	135.57	9524489.0
2012-07-26 11:30:00	SPY	ETF	135.57	135.68	135.29	135.41	6267965.0
2012-07-26 12:00:00	SPY	ETF	135.4	135.65	135.26	135.59	4854775.0
2012-07-26 12:30:00	SPY	ETF	135.59	135.76	135.47	135.725	4346265.0
2012-07-26 13:00:00	SPY	ETF	135.725	136.025	135.69	135.935	5155175.0
2012-07-26 13:30:00	SPY	ETF	135.94	136.07	135.77	135.791	4791998.0
2012-07-26 14:00:00	SPY	ETF	135.8	135.95	135.75	135.89	3863607.0
2012-07-26 14:30:00	SPY	ETF	135.89	136.14	135.76	136.01	10180535.0
2012-07-26 15:00:00	SPY	ETF	136.0	136.16	135.93	136.14	6183453.0
2012-07-26 15:30:00	SPY	ETF	136.14	136.46	136.06	136.109	26152449.0
2012-07-26 16:00:00	SPY	ETF	136.14	136.35	135.96	136.11	7905354.0
2012-07-26 16:30:00	SPY	ETF	136.1	136.18	133.9191	136.09	9043203.0
2012-07-26 17:00:00	SPY	ETF	136.1	136.28	136.09	136.2	174439.0
2012-07-26 17:30:00	SPY	ETF	136.21	136.29	136.11	136.16	199629.0
2012-07-26 18:00:00	SPY	ETF	136.19	136.19	136.04	136.15	245206.0
2012-07-26 18:30:00	SPY	ETF	136.15	136.17	136.12	136.13	27207.0
2012-07-26 19:00:00	SPY	ETF	136.13	136.13	136.04	136.09	10996.0
2012-07-26 19:30:00	SPY	ETF	136.06	136.1	136.05	136.08	71333.0
2012-07-26 05:00:00	QQQ	ETF	62.25	62.27	62.23	62.26	2550.0
2012-07-26 05:30:00	QQQ	ETF	62.27	62.27	62.27	62.27	1900.0
2012-07-26 06:00:00	QQQ	ETF	62.38	62.73	62.38	62.66	8877.0
2012-07-26 06:30:00	QQQ	ETF	62.73	63.01	62.71	63.01	11600.0
2012-07-26 07:00:00	QQQ	ETF	63.0	63.43	63.0	63.1	200800.0
2012-07-26 07:30:00	QQQ	ETF	63.1	63.31	63.09	63.31	61400.0
2012-07-26 08:00:00	QQQ	ETF	63.27	63.36	63.2	63.28	1019736.0
2012-07-26 08:30:00	QQQ	ETF	63.38	63.45	63.28	63.32	308848.0
2012-07-26 09:00:00	QQQ	ETF	63.31	63.45	63.25	63.42	282580.0
2012-07-26 09:30:00	QQQ	ETF	63.43	63.73	63.42	63.46	7145052.0
2012-07-26 10:00:00	QQQ	ETF	63.45	63.7	63.36	63.57	3809759.0
2012-07-26 10:30:00	QQQ	ETF	63.58	63.63	63.175	63.3	4291014.0
2012-07-26 11:00:00	QQQ	ETF	63.31	63.35	63.11	63.2	2808973.0
2012-07-26 11:30:00	QQQ	ETF	63.21	63.25	62.98	63.061	1686469.0
2012-07-26 12:00:00	QQQ	ETF	63.065	63.2	62.97	63.17	1651420.0
2012-07-26 12:30:00	QQQ	ETF	63.16	63.27	63.09	63.24	943772.0
2012-07-26 13:00:00	QQQ	ETF	63.23	63.3998	63.22	63.36	1555769.0
2012-07-26 13:30:00	QQQ	ETF	63.36	63.43	63.2	63.2	1308307.0

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

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