PREVIEW / etf_30min / 2012-11-16

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-16.parquet
  size:    302 KB
  rows:    10,082

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-11-16 04:00:00	SPY	ETF	135.68	135.74	135.4	135.4	9600.0
2012-11-16 04:30:00	SPY	ETF	135.21	135.32	135.21	135.27	4500.0
2012-11-16 05:00:00	SPY	ETF	135.13	135.23	135.12	135.23	18990.0
2012-11-16 05:30:00	SPY	ETF	135.33	135.33	135.24	135.29	1952.0
2012-11-16 06:00:00	SPY	ETF	135.34	135.48	135.3	135.46	9000.0
2012-11-16 06:30:00	SPY	ETF	135.48	135.69	135.43	135.69	33290.0
2012-11-16 07:00:00	SPY	ETF	135.68	135.8	135.42	135.52	168427.0
2012-11-16 07:30:00	SPY	ETF	135.51	135.83	135.47	135.83	737084.0
2012-11-16 08:00:00	SPY	ETF	135.79	136.25	135.425	136.18	2353758.0
2012-11-16 08:30:00	SPY	ETF	136.19	136.36	135.7	136.17	635882.0
2012-11-16 09:00:00	SPY	ETF	136.18	136.29	135.7	135.9	2645167.0
2012-11-16 09:30:00	SPY	ETF	135.9	135.92	135.21	135.35	22901093.0
2012-11-16 10:00:00	SPY	ETF	135.36	135.51	134.87	135.43	20294276.0
2012-11-16 10:30:00	SPY	ETF	135.43	135.63	135.245	135.25	11610377.0
2012-11-16 11:00:00	SPY	ETF	135.26	135.45	134.7	134.759	15674723.0
2012-11-16 11:30:00	SPY	ETF	134.76	136.23	134.745	136.22	33541071.0
2012-11-16 12:00:00	SPY	ETF	136.22	136.38	135.96	136.28	16594034.0
2012-11-16 12:30:00	SPY	ETF	136.29	136.57	136.15	136.195	12559453.0
2012-11-16 13:00:00	SPY	ETF	136.18	136.29	135.87	136.1	7759311.0
2012-11-16 13:30:00	SPY	ETF	136.11	136.34	135.94	136.23	18617563.0
2012-11-16 14:00:00	SPY	ETF	136.24	136.28	135.7	135.76	11529744.0
2012-11-16 14:30:00	SPY	ETF	135.755	136.1	135.47	136.015	11230401.0
2012-11-16 15:00:00	SPY	ETF	136.02	136.32	135.835	136.26	8284321.0
2012-11-16 15:30:00	SPY	ETF	136.26	136.64	136.19	136.39	23558340.0
2012-11-16 16:00:00	SPY	ETF	136.36	136.7	135.7365	136.6	12771188.0
2012-11-16 16:30:00	SPY	ETF	136.58	136.7374	136.58	136.68	1336607.0
2012-11-16 17:00:00	SPY	ETF	136.68	136.69	136.64	136.66	1968231.0
2012-11-16 17:30:00	SPY	ETF	136.66	136.69	136.64	136.68	36247.0
2012-11-16 18:00:00	SPY	ETF	136.69	136.72	136.68	136.69	67851.0
2012-11-16 18:30:00	SPY	ETF	136.71	136.72	136.68	136.7	15854.0
2012-11-16 19:00:00	SPY	ETF	136.71	136.72	136.69	136.72	31058.0
2012-11-16 19:30:00	SPY	ETF	136.72	136.83	136.72	136.83	52976.0
2012-11-16 04:00:00	QQQ	ETF	62.02	62.02	61.9	61.9	5200.0
2012-11-16 04:30:00	QQQ	ETF	61.87	61.87	61.87	61.87	100.0
2012-11-16 05:00:00	QQQ	ETF	61.87	61.94	61.83	61.94	42400.0
2012-11-16 06:00:00	QQQ	ETF	61.9	61.9	61.9	61.9	500.0
2012-11-16 06:30:00	QQQ	ETF	61.93	61.97	61.91	61.97	1900.0
2012-11-16 07:00:00	QQQ	ETF	62.0	62.02	61.84	61.87	788500.0
2012-11-16 07:30:00	QQQ	ETF	61.89	62.05	61.88	61.97	153845.0
2012-11-16 08:00:00	QQQ	ETF	62.02	62.26	61.86	62.25	1091506.0
2012-11-16 08:30:00	QQQ	ETF	62.25	62.34	62.21	62.23	298550.0
2012-11-16 09:00:00	QQQ	ETF	62.24	62.26	62.08	62.09	253979.0
2012-11-16 09:30:00	QQQ	ETF	62.08	62.1	61.64	61.77	6235905.0
2012-11-16 10:00:00	QQQ	ETF	61.76	61.85	61.55	61.83	6003128.0
2012-11-16 10:30:00	QQQ	ETF	61.83	61.92	61.74	61.77	2596967.0
2012-11-16 11:00:00	QQQ	ETF	61.7701	61.82	61.34	61.369	3854948.0
2012-11-16 11:30:00	QQQ	ETF	61.368	62.08	61.31	62.07	5456813.0
2012-11-16 12:00:00	QQQ	ETF	62.08	62.36	62.0	62.35	4681494.0
2012-11-16 12:30:00	QQQ	ETF	62.35	62.47	62.25	62.28	3244514.0
2012-11-16 13:00:00	QQQ	ETF	62.279	62.32	62.1	62.245	1951813.0

> showing 50 of 10,082 rows — these rows as CSV

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