PREVIEW / etf_30min / 2011-09-19

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-19.parquet
  size:    281 KB
  rows:    9,414

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-09-19 04:00:00	SPY	ETF	120.0	120.11	119.33	119.6	143256.0
2011-09-19 04:30:00	SPY	ETF	119.6	119.6	119.38	119.4	200275.0
2011-09-19 05:00:00	SPY	ETF	119.48	119.48	119.37	119.45	14700.0
2011-09-19 05:30:00	SPY	ETF	119.46	119.66	119.43	119.66	23713.0
2011-09-19 06:00:00	SPY	ETF	119.63	119.8	119.5	119.5	35900.0
2011-09-19 06:30:00	SPY	ETF	119.55	120.0	119.55	119.95	85556.0
2011-09-19 07:00:00	SPY	ETF	119.86	120.05	119.85	119.98	572308.0
2011-09-19 07:30:00	SPY	ETF	120.06	120.14	119.85	119.89	401374.0
2011-09-19 08:00:00	SPY	ETF	119.89	120.3	119.5	119.81	1316723.0
2011-09-19 08:30:00	SPY	ETF	119.84	120.25	119.64	119.64	1452714.0
2011-09-19 09:00:00	SPY	ETF	119.64	119.77	119.37	119.53	3935746.0
2011-09-19 09:30:00	SPY	ETF	119.53	119.69	118.81	118.87	30394230.0
2011-09-19 10:00:00	SPY	ETF	118.85	119.24	118.72	119.05	17593893.0
2011-09-19 10:30:00	SPY	ETF	119.05	119.27	118.88	118.97	11874733.0
2011-09-19 11:00:00	SPY	ETF	118.98	119.52	118.96	119.3	13620505.0
2011-09-19 11:30:00	SPY	ETF	119.31	119.925	119.19	119.625	16485237.0
2011-09-19 12:00:00	SPY	ETF	119.63	119.85	119.36	119.41	9587377.0
2011-09-19 12:30:00	SPY	ETF	119.4	119.45	119.12	119.23	6769943.0
2011-09-19 13:00:00	SPY	ETF	119.23	119.32	119.02	119.25	6752271.0
2011-09-19 13:30:00	SPY	ETF	119.26	119.5	119.19	119.47	6993465.0
2011-09-19 14:00:00	SPY	ETF	119.47	119.82	119.22	119.5805	11719034.0
2011-09-19 14:30:00	SPY	ETF	119.59	120.05	119.54	119.58	13281886.0
2011-09-19 15:00:00	SPY	ETF	119.575	120.63	119.39	120.55	30134836.0
2011-09-19 15:30:00	SPY	ETF	120.55	120.93	120.24	120.32	34347299.0
2011-09-19 16:00:00	SPY	ETF	120.31	121.5132	119.67	120.22	18314182.0
2011-09-19 16:30:00	SPY	ETF	120.22	121.5132	120.19	120.34	2119927.0
2011-09-19 17:00:00	SPY	ETF	120.34	120.34	120.15	120.27	105627.0
2011-09-19 17:30:00	SPY	ETF	120.23	120.3	120.18	120.19	1061548.0
2011-09-19 18:00:00	SPY	ETF	120.22	120.34	119.46	119.64	514523.0
2011-09-19 18:30:00	SPY	ETF	119.65	119.66	119.27	119.29	589964.0
2011-09-19 19:00:00	SPY	ETF	119.26	119.48	119.14	119.42	293616.0
2011-09-19 19:30:00	SPY	ETF	119.43	119.59	119.35	119.56	294857.0
2011-09-19 04:00:00	QQQ	ETF	55.98	55.98	55.71	55.85	6262.0
2011-09-19 04:30:00	QQQ	ETF	55.8	55.8	55.69	55.69	2700.0
2011-09-19 05:00:00	QQQ	ETF	55.7	55.71	55.7	55.71	2000.0
2011-09-19 05:30:00	QQQ	ETF	55.78	55.87	55.78	55.86	1250.0
2011-09-19 06:00:00	QQQ	ETF	55.83	55.88	55.78	55.84	6800.0
2011-09-19 06:30:00	QQQ	ETF	55.81	55.96	55.81	55.96	1600.0
2011-09-19 07:00:00	QQQ	ETF	55.96	56.0	55.88	55.94	31274.0
2011-09-19 07:30:00	QQQ	ETF	55.96	56.02	55.91	55.94	190765.0
2011-09-19 08:00:00	QQQ	ETF	55.91	55.96	55.85	55.9	337466.0
2011-09-19 08:30:00	QQQ	ETF	55.9	55.92	55.85	55.86	129425.0
2011-09-19 09:00:00	QQQ	ETF	55.86	55.9	55.76	55.9	490313.0
2011-09-19 09:30:00	QQQ	ETF	55.9	55.93	55.43	55.46	7551653.0
2011-09-19 10:00:00	QQQ	ETF	55.45	55.72	55.44	55.65	3640328.0
2011-09-19 10:30:00	QQQ	ETF	55.6499	55.79	55.57	55.6898	3949388.0
2011-09-19 11:00:00	QQQ	ETF	55.69	56.18	55.6898	56.07	5009646.0
2011-09-19 11:30:00	QQQ	ETF	56.07	56.46	56.0	56.23	4800233.0
2011-09-19 12:00:00	QQQ	ETF	56.24	56.34	56.07	56.115	3283199.0
2011-09-19 12:30:00	QQQ	ETF	56.1	56.1978	55.98	56.05	1523699.0

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

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