PREVIEW / etf_30min / 2013-12-18

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-18.parquet
  size:    344 KB
  rows:    11,361

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-12-18 04:00:00	SPY	ETF	178.71	179.17	178.71	179.03	69144.0
2013-12-18 04:30:00	SPY	ETF	178.96	179.04	178.94	179.04	4120.0
2013-12-18 05:00:00	SPY	ETF	179.05	179.19	178.98	179.14	27847.0
2013-12-18 05:30:00	SPY	ETF	179.14	179.2	179.14	179.17	19336.0
2013-12-18 06:00:00	SPY	ETF	179.15	179.15	178.98	179.02	9335.0
2013-12-18 06:30:00	SPY	ETF	178.98	179.05	178.86	178.96	16362.0
2013-12-18 07:00:00	SPY	ETF	178.93	178.93	178.75	178.81	61348.0
2013-12-18 07:30:00	SPY	ETF	178.81	178.86	178.81	178.82	58636.0
2013-12-18 08:00:00	SPY	ETF	178.83	178.91	178.72	178.81	162657.0
2013-12-18 08:30:00	SPY	ETF	178.83	178.87	178.77	178.86	496170.0
2013-12-18 09:00:00	SPY	ETF	178.86	178.95	178.81	178.92	982893.0
2013-12-18 09:30:00	SPY	ETF	178.92	179.09	178.74	178.9	11783280.0
2013-12-18 10:00:00	SPY	ETF	178.9	179.07	178.81	178.93	3916501.0
2013-12-18 10:30:00	SPY	ETF	178.93	179.06	178.64	178.8091	8095336.0
2013-12-18 11:00:00	SPY	ETF	178.805	178.88	178.74	178.75	3808523.0
2013-12-18 11:30:00	SPY	ETF	178.75	178.8	178.42	178.49	7281471.0
2013-12-18 12:00:00	SPY	ETF	178.49	178.61	178.4	178.59	5319397.0
2013-12-18 12:30:00	SPY	ETF	178.59	178.61	178.32	178.36	6334300.0
2013-12-18 13:00:00	SPY	ETF	178.35	178.35	177.87	178.13	10868647.0
2013-12-18 13:30:00	SPY	ETF	178.135	178.75	178.01	178.44	9685352.0
2013-12-18 14:00:00	SPY	ETF	178.44	180.13	177.32	179.81	47052404.0
2013-12-18 14:30:00	SPY	ETF	179.81	180.795	179.75	180.52	31827672.0
2013-12-18 15:00:00	SPY	ETF	180.52	181.26	180.37	180.91	25275642.0
2013-12-18 15:30:00	SPY	ETF	180.91	181.73	180.86	181.7	38703086.0
2013-12-18 16:00:00	SPY	ETF	181.69	181.84	178.3982	181.6	9513344.0
2013-12-18 16:30:00	SPY	ETF	181.6	181.69	178.6701	181.59	7049649.0
2013-12-18 17:00:00	SPY	ETF	181.59	181.65	181.56	181.64	100524.0
2013-12-18 17:30:00	SPY	ETF	181.64	181.66	181.59	181.62	120898.0
2013-12-18 18:00:00	SPY	ETF	181.62	181.82	181.59	181.72	191162.0
2013-12-18 18:30:00	SPY	ETF	181.72	181.79	181.69	181.69	43708.0
2013-12-18 19:00:00	SPY	ETF	181.67	181.67	181.59	181.6	29496.0
2013-12-18 19:30:00	SPY	ETF	181.62	181.62	181.51	181.52	113488.0
2013-12-18 04:00:00	QQQ	ETF	85.22	85.31	85.22	85.31	9800.0
2013-12-18 04:30:00	QQQ	ETF	85.29	85.31	85.25	85.31	3700.0
2013-12-18 05:00:00	QQQ	ETF	85.33	85.37	85.31	85.37	5400.0
2013-12-18 05:30:00	QQQ	ETF	85.36	85.39	85.36	85.39	1900.0
2013-12-18 06:00:00	QQQ	ETF	85.37	85.37	85.33	85.33	1600.0
2013-12-18 06:30:00	QQQ	ETF	85.31	85.31	85.23	85.25	5400.0
2013-12-18 07:00:00	QQQ	ETF	85.23	85.23	85.17	85.17	3400.0
2013-12-18 07:30:00	QQQ	ETF	85.17	85.22	85.17	85.22	69120.0
2013-12-18 08:00:00	QQQ	ETF	85.19	85.21	85.15	85.21	175005.0
2013-12-18 08:30:00	QQQ	ETF	85.17	85.23	85.17	85.23	197876.0
2013-12-18 09:00:00	QQQ	ETF	85.23	85.29	85.2	85.23	113820.0
2013-12-18 09:30:00	QQQ	ETF	85.22	85.29	84.91	84.95	3629856.0
2013-12-18 10:00:00	QQQ	ETF	84.95	85.08	84.87	85.05	1609634.0
2013-12-18 10:30:00	QQQ	ETF	85.0499	85.16	84.91	84.98	1186709.0
2013-12-18 11:00:00	QQQ	ETF	84.98	85.04	84.92	84.92	607053.0
2013-12-18 11:30:00	QQQ	ETF	84.92	84.94	84.62	84.69	2319095.0
2013-12-18 12:00:00	QQQ	ETF	84.69	84.78	84.64	84.74	1593082.0
2013-12-18 12:30:00	QQQ	ETF	84.75	84.75	84.51	84.55	2289180.0

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

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