PREVIEW / etf_30min / 2013-07-08

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-08.parquet
  size:    322 KB
  rows:    11,041

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-07-08 04:00:00	SPY	ETF	163.66	163.71	163.54	163.62	18333.0
2013-07-08 04:30:00	SPY	ETF	163.61	163.78	163.58	163.74	26905.0
2013-07-08 05:00:00	SPY	ETF	163.76	164.14	163.76	164.14	12274.0
2013-07-08 05:30:00	SPY	ETF	164.13	164.23	164.07	164.14	35900.0
2013-07-08 06:00:00	SPY	ETF	164.14	164.25	164.05	164.1	31000.0
2013-07-08 06:30:00	SPY	ETF	164.12	164.16	164.02	164.04	57456.0
2013-07-08 07:00:00	SPY	ETF	164.04	164.14	163.99	164.02	113914.0
2013-07-08 07:30:00	SPY	ETF	164.04	164.1	163.93	164.1	381262.0
2013-07-08 08:00:00	SPY	ETF	163.59	164.12	163.59	164.06	374168.0
2013-07-08 08:30:00	SPY	ETF	164.06	164.08	163.84	163.9	607215.0
2013-07-08 09:00:00	SPY	ETF	163.9	163.97	163.66	163.86	1558655.0
2013-07-08 09:30:00	SPY	ETF	163.86	164.16	163.66	164.08	17338719.0
2013-07-08 10:00:00	SPY	ETF	164.08	164.39	164.06	164.14	11917328.0
2013-07-08 10:30:00	SPY	ETF	164.13	164.32	164.0	164.061	7098778.0
2013-07-08 11:00:00	SPY	ETF	164.06	164.23	163.86	163.968	6000436.0
2013-07-08 11:30:00	SPY	ETF	163.96	163.98	163.65	163.76	5385489.0
2013-07-08 12:00:00	SPY	ETF	163.76	163.83	163.58	163.64	4308777.0
2013-07-08 12:30:00	SPY	ETF	163.63	163.91	163.625	163.7	4565602.0
2013-07-08 13:00:00	SPY	ETF	163.69	163.9	163.59	163.68	3684248.0
2013-07-08 13:30:00	SPY	ETF	163.68	164.06	163.66	164.01	4277927.0
2013-07-08 14:00:00	SPY	ETF	164.005	164.07	163.84	163.88	3842410.0
2013-07-08 14:30:00	SPY	ETF	163.87	164.12	163.87	164.05	3802991.0
2013-07-08 15:00:00	SPY	ETF	164.0499	164.06	163.78	163.8	4475642.0
2013-07-08 15:30:00	SPY	ETF	163.79	164.01	163.68	163.91	14794218.0
2013-07-08 16:00:00	SPY	ETF	163.89	164.0847	163.85	164.07	4427589.0
2013-07-08 16:30:00	SPY	ETF	164.07	164.19	163.59	164.16	247734.0
2013-07-08 17:00:00	SPY	ETF	164.18	164.23	163.95	164.22	225164.0
2013-07-08 17:30:00	SPY	ETF	164.2	164.22	164.15	164.16	86316.0
2013-07-08 18:00:00	SPY	ETF	164.15	164.15	164.08	164.13	87652.0
2013-07-08 18:30:00	SPY	ETF	164.13	164.13	164.1	164.12	1725.0
2013-07-08 19:00:00	SPY	ETF	164.12	164.22	164.12	164.18	10100.0
2013-07-08 19:30:00	SPY	ETF	164.19	164.26	164.19	164.26	149625.0
2013-07-08 04:00:00	QQQ	ETF	72.88	72.89	72.83	72.83	14700.0
2013-07-08 04:30:00	QQQ	ETF	72.85	72.88	72.82	72.88	2400.0
2013-07-08 05:00:00	QQQ	ETF	72.88	73.0	72.88	73.0	7000.0
2013-07-08 05:30:00	QQQ	ETF	73.01	73.05	72.99	73.02	6400.0
2013-07-08 06:00:00	QQQ	ETF	73.02	73.07	73.01	73.01	10600.0
2013-07-08 06:30:00	QQQ	ETF	72.99	72.99	72.98	72.98	900.0
2013-07-08 07:00:00	QQQ	ETF	72.96	73.01	72.95	72.96	10780.0
2013-07-08 07:30:00	QQQ	ETF	72.96	73.0	72.94	73.0	9652.0
2013-07-08 08:00:00	QQQ	ETF	72.99	73.01	72.95	73.0	19789.0
2013-07-08 08:30:00	QQQ	ETF	73.0	73.0	72.92	72.93	48546.0
2013-07-08 09:00:00	QQQ	ETF	72.92	72.95	72.86	72.94	118914.0
2013-07-08 09:30:00	QQQ	ETF	72.94	72.99	72.75	72.82	3336998.0
2013-07-08 10:00:00	QQQ	ETF	72.82	72.97	72.76	72.82	2567515.0
2013-07-08 10:30:00	QQQ	ETF	72.81	72.84	72.5792	72.62	2203846.0
2013-07-08 11:00:00	QQQ	ETF	72.62	72.711	72.54	72.58	1367934.0
2013-07-08 11:30:00	QQQ	ETF	72.5799	72.59	72.48	72.5	1074520.0
2013-07-08 12:00:00	QQQ	ETF	72.491	72.53	72.42	72.42	785921.0
2013-07-08 12:30:00	QQQ	ETF	72.42	72.55	72.38	72.42	1305412.0

> showing 50 of 11,041 rows — these rows as CSV

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