PREVIEW / etf_30min / 2011-10-21

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-21.parquet
  size:    285 KB
  rows:    9,457

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-10-21 04:00:00	SPY	ETF	121.85	121.85	121.73	121.85	1500.0
2011-10-21 04:30:00	SPY	ETF	121.65	121.89	121.65	121.81	42600.0
2011-10-21 05:00:00	SPY	ETF	121.86	122.11	121.75	122.11	62700.0
2011-10-21 05:30:00	SPY	ETF	122.0	122.04	121.87	121.87	13450.0
2011-10-21 06:00:00	SPY	ETF	121.91	122.04	121.9	121.95	1800.0
2011-10-21 06:30:00	SPY	ETF	121.94	122.1	121.88	122.1	14100.0
2011-10-21 07:00:00	SPY	ETF	122.12	122.79	122.07	122.78	586206.0
2011-10-21 07:30:00	SPY	ETF	122.8	122.91	122.56	122.7	797489.0
2011-10-21 08:00:00	SPY	ETF	122.7	123.0	121.83	122.81	658011.0
2011-10-21 08:30:00	SPY	ETF	122.78	122.85	122.55	122.77	1378947.0
2011-10-21 09:00:00	SPY	ETF	122.79	123.27	121.96	123.06	3087820.0
2011-10-21 09:30:00	SPY	ETF	123.09	123.53	122.94	123.38	26356222.0
2011-10-21 10:00:00	SPY	ETF	123.37	124.03	123.18	123.98	24871935.0
2011-10-21 10:30:00	SPY	ETF	123.97	124.12	123.59	123.78	20695166.0
2011-10-21 11:00:00	SPY	ETF	123.77	123.81	123.39	123.639	14731034.0
2011-10-21 11:30:00	SPY	ETF	123.64	123.88	123.54	123.72	10312475.0
2011-10-21 12:00:00	SPY	ETF	123.7128	123.74	123.43	123.56	6656974.0
2011-10-21 12:30:00	SPY	ETF	123.56	123.58	123.29	123.3	7194579.0
2011-10-21 13:00:00	SPY	ETF	123.29	123.2999	122.82	122.86	14956435.0
2011-10-21 13:30:00	SPY	ETF	122.855	123.02	122.72	122.79	13837755.0
2011-10-21 14:00:00	SPY	ETF	122.8	123.34	122.72	123.199	12784186.0
2011-10-21 14:30:00	SPY	ETF	123.2	123.51	123.01	123.506	14760362.0
2011-10-21 15:00:00	SPY	ETF	123.5	123.69	123.41	123.47	15832941.0
2011-10-21 15:30:00	SPY	ETF	123.47	123.97	123.24	123.95	42776377.0
2011-10-21 16:00:00	SPY	ETF	123.945	124.11	121.6547	124.0	33405534.0
2011-10-21 16:30:00	SPY	ETF	124.0	124.07	123.9398	124.01	8343199.0
2011-10-21 17:00:00	SPY	ETF	124.03	124.08	123.9825	124.03	581383.0
2011-10-21 17:30:00	SPY	ETF	124.03	124.18	124.02	124.1	160977.0
2011-10-21 18:00:00	SPY	ETF	124.09	124.12	123.91	124.12	325009.0
2011-10-21 18:30:00	SPY	ETF	124.1	124.12	124.09	124.1	30602.0
2011-10-21 19:00:00	SPY	ETF	124.11	124.15	124.07	124.15	32602.0
2011-10-21 19:30:00	SPY	ETF	124.14	124.24	124.12	124.2	60684.0
2011-10-21 04:00:00	QQQ	ETF	56.86	56.86	56.86	56.86	113.0
2011-10-21 05:00:00	QQQ	ETF	56.68	56.68	56.68	56.68	500.0
2011-10-21 05:30:00	QQQ	ETF	56.77	56.77	56.77	56.77	100.0
2011-10-21 06:30:00	QQQ	ETF	56.78	56.84	56.78	56.84	2600.0
2011-10-21 07:00:00	QQQ	ETF	56.85	57.1	56.84	57.1	22450.0
2011-10-21 07:30:00	QQQ	ETF	57.14	57.19	57.01	57.07	90848.0
2011-10-21 08:00:00	QQQ	ETF	57.1	57.16	57.07	57.1	213078.0
2011-10-21 08:30:00	QQQ	ETF	57.09	57.12	56.97	57.1	195422.0
2011-10-21 09:00:00	QQQ	ETF	57.11	57.24	57.1	57.14	981851.0
2011-10-21 09:30:00	QQQ	ETF	57.15	57.47	57.07	57.32	8790931.0
2011-10-21 10:00:00	QQQ	ETF	57.32	57.64	57.26	57.61	4355015.0
2011-10-21 10:30:00	QQQ	ETF	57.61	57.66	57.41	57.45	4685655.0
2011-10-21 11:00:00	QQQ	ETF	57.45	57.47	57.37	57.4026	2311783.0
2011-10-21 11:30:00	QQQ	ETF	57.4	57.45	57.34	57.36	1902243.0
2011-10-21 12:00:00	QQQ	ETF	57.37	57.37	57.24	57.28	1895757.0
2011-10-21 12:30:00	QQQ	ETF	57.2729	57.28	57.11	57.11	1951281.0
2011-10-21 13:00:00	QQQ	ETF	57.11	57.115	56.82	56.84	4690653.0
2011-10-21 13:30:00	QQQ	ETF	56.85	56.9499	56.78	56.87	3510033.0

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

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