PREVIEW / etf_30min / 2011-02-18

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-18.parquet
  size:    272 KB
  rows:    9,132

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-02-18 04:00:00	SPY	ETF	134.19	134.19	134.14	134.15	7194.0
2011-02-18 04:30:00	SPY	ETF	134.14	134.14	134.1	134.1	1800.0
2011-02-18 05:00:00	SPY	ETF	134.01	134.01	133.96	134.0	6050.0
2011-02-18 05:30:00	SPY	ETF	133.99	134.05	133.99	134.04	8500.0
2011-02-18 06:30:00	SPY	ETF	134.09	134.09	134.08	134.08	32400.0
2011-02-18 07:00:00	SPY	ETF	134.09	134.19	134.08	134.18	51900.0
2011-02-18 07:30:00	SPY	ETF	134.18	134.24	134.18	134.19	222235.0
2011-02-18 08:00:00	SPY	ETF	134.1	134.4	133.85	134.2	219525.0
2011-02-18 08:30:00	SPY	ETF	134.2	134.3	134.16	134.26	468718.0
2011-02-18 09:00:00	SPY	ETF	134.27	134.38	134.27	134.37	858482.0
2011-02-18 09:30:00	SPY	ETF	134.37	134.37	134.13	134.3	13028963.0
2011-02-18 10:00:00	SPY	ETF	134.3	134.43	134.2	134.33	9100163.0
2011-02-18 10:30:00	SPY	ETF	134.33	134.45	134.31	134.32	6352095.0
2011-02-18 11:00:00	SPY	ETF	134.31	134.56	134.3	134.53	7304949.0
2011-02-18 11:30:00	SPY	ETF	134.53	134.64	134.51	134.579	7174124.0
2011-02-18 12:00:00	SPY	ETF	134.57	134.69	134.53	134.64	6475826.0
2011-02-18 12:30:00	SPY	ETF	134.64	134.66	134.53	134.61	3787178.0
2011-02-18 13:00:00	SPY	ETF	134.61	134.62	134.46	134.47	3960529.0
2011-02-18 13:30:00	SPY	ETF	134.48	134.48	134.23	134.44	7592557.0
2011-02-18 14:00:00	SPY	ETF	134.44	134.45	134.07	134.13	8137628.0
2011-02-18 14:30:00	SPY	ETF	134.13	134.39	134.06	134.35	7531510.0
2011-02-18 15:00:00	SPY	ETF	134.35	134.38	134.235	134.26	7714964.0
2011-02-18 15:30:00	SPY	ETF	134.25	134.57	134.155	134.51	18799924.0
2011-02-18 16:00:00	SPY	ETF	134.57	134.72	134.15	134.63	12224418.0
2011-02-18 16:30:00	SPY	ETF	134.59	134.62	134.45	134.56	541965.0
2011-02-18 17:00:00	SPY	ETF	134.56	134.65	134.55	134.58	665333.0
2011-02-18 17:30:00	SPY	ETF	134.56	134.57	134.5	134.5	193883.0
2011-02-18 18:00:00	SPY	ETF	134.5	134.57	134.49	134.53	148941.0
2011-02-18 18:30:00	SPY	ETF	134.53	134.59	134.51	134.59	1650.0
2011-02-18 19:00:00	SPY	ETF	134.6	134.61	134.52	134.53	14900.0
2011-02-18 19:30:00	SPY	ETF	134.53	134.6	134.53	134.6	16300.0
2011-02-18 05:00:00	QQQ	ETF	58.76	58.76	58.75	58.75	4000.0
2011-02-18 05:30:00	QQQ	ETF	58.72	58.75	58.72	58.75	7100.0
2011-02-18 06:00:00	QQQ	ETF	58.73	58.73	58.73	58.73	100.0
2011-02-18 07:00:00	QQQ	ETF	58.78	58.82	58.78	58.82	31400.0
2011-02-18 07:30:00	QQQ	ETF	58.83	58.83	58.81	58.81	3613.0
2011-02-18 08:00:00	QQQ	ETF	58.81	58.95	58.81	58.83	53417.0
2011-02-18 08:30:00	QQQ	ETF	58.84	58.87	58.82	58.87	66123.0
2011-02-18 09:00:00	QQQ	ETF	58.87	58.93	58.87	58.88	394780.0
2011-02-18 09:30:00	QQQ	ETF	58.88	58.91	58.78	58.8701	3993265.0
2011-02-18 10:00:00	QQQ	ETF	58.875	58.905	58.74	58.8	2794714.0
2011-02-18 10:30:00	QQQ	ETF	58.8	58.87	58.77	58.77	2472152.0
2011-02-18 11:00:00	QQQ	ETF	58.76	58.87	58.74	58.86	2209486.0
2011-02-18 11:30:00	QQQ	ETF	58.87	58.97	58.87	58.9138	1951407.0
2011-02-18 12:00:00	QQQ	ETF	58.91	58.96	58.89	58.94	1021905.0
2011-02-18 12:30:00	QQQ	ETF	58.935	58.94	58.85	58.8835	1150923.0
2011-02-18 13:00:00	QQQ	ETF	58.89	58.9	58.78	58.79	1456806.0
2011-02-18 13:30:00	QQQ	ETF	58.8	58.8	58.6	58.759	5934249.0
2011-02-18 14:00:00	QQQ	ETF	58.76	58.77	58.55	58.5701	3023487.0
2011-02-18 14:30:00	QQQ	ETF	58.58	58.7	58.51	58.69	3044784.0

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

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