PREVIEW / etf_30min / 2013-03-04

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-04.parquet
  size:    311 KB
  rows:    10,532

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
2013-03-04 04:00:00	SPY	ETF	151.53	151.69	151.53	151.69	73720.0
2013-03-04 04:30:00	SPY	ETF	151.68	151.68	151.54	151.6	11200.0
2013-03-04 05:00:00	SPY	ETF	151.59	151.59	151.49	151.56	1748.0
2013-03-04 05:30:00	SPY	ETF	151.69	151.69	151.56	151.56	12950.0
2013-03-04 06:00:00	SPY	ETF	151.54	151.59	151.36	151.42	17679.0
2013-03-04 06:30:00	SPY	ETF	151.4	151.63	151.39	151.6	11300.0
2013-03-04 07:00:00	SPY	ETF	151.63	151.74	151.53	151.74	220662.0
2013-03-04 07:30:00	SPY	ETF	151.77	152.08	151.77	151.92	444348.0
2013-03-04 08:00:00	SPY	ETF	151.6	151.99	151.46	151.97	583036.0
2013-03-04 08:30:00	SPY	ETF	151.95	152.01	151.83	151.85	375050.0
2013-03-04 09:00:00	SPY	ETF	151.84	151.85	151.44	151.76	463904.0
2013-03-04 09:30:00	SPY	ETF	151.76	152.09	151.6	151.91	11528428.0
2013-03-04 10:00:00	SPY	ETF	151.92	152.02	151.68	151.73	6810620.0
2013-03-04 10:30:00	SPY	ETF	151.73	152.13	151.68	152.01	6119063.0
2013-03-04 11:00:00	SPY	ETF	152.0	152.21	151.84	152.13	6129196.0
2013-03-04 11:30:00	SPY	ETF	152.12	152.23	152.01	152.13	3273954.0
2013-03-04 12:00:00	SPY	ETF	152.13	152.16	151.645	151.645	4910194.0
2013-03-04 12:30:00	SPY	ETF	151.64	151.89	151.52	151.85	5124660.0
2013-03-04 13:00:00	SPY	ETF	151.84	152.17	151.67	152.17	4918230.0
2013-03-04 13:30:00	SPY	ETF	152.17	152.29	152.08	152.24	6247532.0
2013-03-04 14:00:00	SPY	ETF	152.24	152.61	152.11	152.578	5585400.0
2013-03-04 14:30:00	SPY	ETF	152.57	152.78	152.48	152.71	6969615.0
2013-03-04 15:00:00	SPY	ETF	152.72	152.76	152.52	152.65	5029033.0
2013-03-04 15:30:00	SPY	ETF	152.6499	152.87	152.59	152.87	10609244.0
2013-03-04 16:00:00	SPY	ETF	152.86	153.04	152.135	153.0	7332835.0
2013-03-04 16:30:00	SPY	ETF	153.0	153.12	152.96	153.11	1011115.0
2013-03-04 17:00:00	SPY	ETF	153.115	153.17	153.08	153.1	288012.0
2013-03-04 17:30:00	SPY	ETF	153.1	153.14	153.07	153.12	64807.0
2013-03-04 18:00:00	SPY	ETF	153.13	153.13	153.07	153.09	37993.0
2013-03-04 18:30:00	SPY	ETF	153.09	153.13	153.08	153.09	9949.0
2013-03-04 19:00:00	SPY	ETF	153.09	153.12	153.03	153.04	33800.0
2013-03-04 19:30:00	SPY	ETF	153.06	153.14	153.06	153.09	44228.0
2013-03-04 04:00:00	QQQ	ETF	67.22	67.22	67.22	67.22	200.0
2013-03-04 04:30:00	QQQ	ETF	67.22	67.22	67.22	67.22	200.0
2013-03-04 05:30:00	QQQ	ETF	67.25	67.26	67.22	67.22	3500.0
2013-03-04 06:00:00	QQQ	ETF	67.19	67.19	67.09	67.09	6200.0
2013-03-04 06:30:00	QQQ	ETF	67.11	67.11	67.11	67.11	900.0
2013-03-04 07:00:00	QQQ	ETF	67.11	67.18	67.11	67.18	6072.0
2013-03-04 07:30:00	QQQ	ETF	67.33	67.34	67.27	67.27	29600.0
2013-03-04 08:00:00	QQQ	ETF	67.28	67.3	67.22	67.3	51700.0
2013-03-04 08:30:00	QQQ	ETF	67.3	67.3	67.22	67.23	19887.0
2013-03-04 09:00:00	QQQ	ETF	67.22	67.24	67.16	67.18	151970.0
2013-03-04 09:30:00	QQQ	ETF	67.19	67.37	67.11	67.21	2733497.0
2013-03-04 10:00:00	QQQ	ETF	67.21	67.2999	67.15	67.2	1195925.0
2013-03-04 10:30:00	QQQ	ETF	67.19	67.36	67.07	67.3199	1433355.0
2013-03-04 11:00:00	QQQ	ETF	67.32	67.42	67.21	67.39	1619132.0
2013-03-04 11:30:00	QQQ	ETF	67.39	67.45	67.36	67.38	521112.0
2013-03-04 12:00:00	QQQ	ETF	67.39	67.391	67.11	67.11	833981.0
2013-03-04 12:30:00	QQQ	ETF	67.1128	67.25	67.07	67.23	1092537.0
2013-03-04 13:00:00	QQQ	ETF	67.22	67.44	67.15	67.44	784534.0

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

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