PREVIEW / etf_30min / 2013-10-15

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-15.parquet
  size:    332 KB
  rows:    11,136

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-10-15 04:00:00	SPY	ETF	170.89	170.98	170.88	170.94	67614.0
2013-10-15 04:30:00	SPY	ETF	170.96	171.04	170.96	171.02	69942.0
2013-10-15 05:00:00	SPY	ETF	171.04	171.28	171.02	171.28	65533.0
2013-10-15 05:30:00	SPY	ETF	171.3	171.3	171.18	171.18	16126.0
2013-10-15 06:00:00	SPY	ETF	171.16	171.2	171.06	171.1	26800.0
2013-10-15 06:30:00	SPY	ETF	171.12	171.17	171.06	171.16	20500.0
2013-10-15 07:00:00	SPY	ETF	171.18	171.21	171.0	171.06	183163.0
2013-10-15 07:30:00	SPY	ETF	171.04	171.05	170.65	170.68	324809.0
2013-10-15 08:00:00	SPY	ETF	170.69	171.17	170.54	170.65	458997.0
2013-10-15 08:30:00	SPY	ETF	170.64	170.82	170.61	170.79	700106.0
2013-10-15 09:00:00	SPY	ETF	170.79	170.92	170.22	170.51	3148883.0
2013-10-15 09:30:00	SPY	ETF	170.51	170.7	170.01	170.54	17245660.0
2013-10-15 10:00:00	SPY	ETF	170.54	170.88	170.36	170.83	10367378.0
2013-10-15 10:30:00	SPY	ETF	170.83	170.92	170.38	170.44	7578360.0
2013-10-15 11:00:00	SPY	ETF	170.44	171.15	170.22	170.99	15421215.0
2013-10-15 11:30:00	SPY	ETF	170.99	171.055	170.53	170.72	7298956.0
2013-10-15 12:00:00	SPY	ETF	170.72	170.74	170.41	170.54	4343830.0
2013-10-15 12:30:00	SPY	ETF	170.54	170.745	170.46	170.6	3670059.0
2013-10-15 13:00:00	SPY	ETF	170.59	170.68	170.36	170.38	3392728.0
2013-10-15 13:30:00	SPY	ETF	170.385	170.62	170.32	170.54	4826779.0
2013-10-15 14:00:00	SPY	ETF	170.54	170.67	170.06	170.1099	11971153.0
2013-10-15 14:30:00	SPY	ETF	170.11	170.13	169.47	170.01	24423095.0
2013-10-15 15:00:00	SPY	ETF	170.015	170.44	169.86	170.26	12899948.0
2013-10-15 15:30:00	SPY	ETF	170.26	170.27	169.69	169.71	15758716.0
2013-10-15 16:00:00	SPY	ETF	169.71	170.696	169.69	169.82	5021748.0
2013-10-15 16:30:00	SPY	ETF	169.82	170.26	169.67	169.93	2625713.0
2013-10-15 17:00:00	SPY	ETF	169.93	170.08	169.89	169.98	272139.0
2013-10-15 17:30:00	SPY	ETF	169.96	169.99	169.7	169.91	1046977.0
2013-10-15 18:00:00	SPY	ETF	169.93	170.06	169.82	169.88	47500.0
2013-10-15 18:30:00	SPY	ETF	169.86	170.36	169.67	169.67	966527.0
2013-10-15 19:00:00	SPY	ETF	169.69	170.22	169.69	170.2	123196.0
2013-10-15 19:30:00	SPY	ETF	170.12	170.9	170.12	170.86	389731.0
2013-10-15 04:00:00	QQQ	ETF	79.97	79.97	79.78	79.81	4800.0
2013-10-15 04:30:00	QQQ	ETF	79.82	79.86	79.82	79.85	25500.0
2013-10-15 05:00:00	QQQ	ETF	79.86	79.97	79.86	79.97	7444.0
2013-10-15 05:30:00	QQQ	ETF	79.98	79.98	79.93	79.93	3007.0
2013-10-15 06:00:00	QQQ	ETF	79.92	79.93	79.88	79.89	2800.0
2013-10-15 06:30:00	QQQ	ETF	79.9	79.95	79.89	79.93	6632.0
2013-10-15 07:00:00	QQQ	ETF	79.94	79.96	79.9	79.93	17700.0
2013-10-15 07:30:00	QQQ	ETF	79.92	79.92	79.77	79.77	70600.0
2013-10-15 08:00:00	QQQ	ETF	79.76	79.91	79.73	79.75	24460.0
2013-10-15 08:30:00	QQQ	ETF	79.74	79.86	79.72	79.85	126588.0
2013-10-15 09:00:00	QQQ	ETF	79.86	79.91	79.62	79.73	350631.0
2013-10-15 09:30:00	QQQ	ETF	79.72	79.88	79.54	79.85	4239936.0
2013-10-15 10:00:00	QQQ	ETF	79.86	79.969	79.77	79.915	2386567.0
2013-10-15 10:30:00	QQQ	ETF	79.91	79.97	79.71	79.753	1794098.0
2013-10-15 11:00:00	QQQ	ETF	79.75	80.11	79.69	80.025	3309096.0
2013-10-15 11:30:00	QQQ	ETF	80.03	80.07	79.82	79.89	2126277.0
2013-10-15 12:00:00	QQQ	ETF	79.8901	79.8901	79.67	79.785	1899349.0
2013-10-15 12:30:00	QQQ	ETF	79.785	79.92	79.7501	79.805	1149089.0

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

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