PREVIEW / etf_30min / 2015-07-16

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-16.parquet
  size:    379 KB
  rows:    12,904

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
2015-07-16 04:00:00	SPY	ETF	211.54	211.75	211.54	211.69	2876.0
2015-07-16 04:30:00	SPY	ETF	211.68	211.88	211.68	211.8	11145.0
2015-07-16 05:00:00	SPY	ETF	211.79	211.79	211.64	211.67	8900.0
2015-07-16 05:30:00	SPY	ETF	211.67	211.74	211.63	211.67	5218.0
2015-07-16 06:00:00	SPY	ETF	211.68	211.7	211.63	211.65	39140.0
2015-07-16 06:30:00	SPY	ETF	211.67	211.67	211.53	211.58	95919.0
2015-07-16 07:00:00	SPY	ETF	211.62	211.76	211.58	211.74	242431.0
2015-07-16 07:30:00	SPY	ETF	211.73	211.85	211.67	211.74	169565.0
2015-07-16 08:00:00	SPY	ETF	211.74	211.79	211.59	211.74	215262.0
2015-07-16 08:30:00	SPY	ETF	211.72	211.98	211.69	211.91	452778.0
2015-07-16 09:00:00	SPY	ETF	211.92	212.05	211.85	211.87	741105.0
2015-07-16 09:30:00	SPY	ETF	211.87	212.01	211.6	211.86	10789815.0
2015-07-16 10:00:00	SPY	ETF	211.85	211.96	211.58	211.81	9557885.0
2015-07-16 10:30:00	SPY	ETF	211.815	211.93	211.64	211.89	4692471.0
2015-07-16 11:00:00	SPY	ETF	211.88	211.95	211.75	211.905	4285209.0
2015-07-16 11:30:00	SPY	ETF	211.9	212.11	211.895	211.97	5938486.0
2015-07-16 12:00:00	SPY	ETF	211.975	212.155	211.945	212.06	5870043.0
2015-07-16 12:30:00	SPY	ETF	212.065	212.12	211.88	211.9	4519486.0
2015-07-16 13:00:00	SPY	ETF	211.905	212.0	211.81	211.955	4728360.0
2015-07-16 13:30:00	SPY	ETF	211.96	212.04	211.83	211.86	3297008.0
2015-07-16 14:00:00	SPY	ETF	211.86	211.99	211.83	211.96	3341170.0
2015-07-16 14:30:00	SPY	ETF	211.955	212.19	211.91	212.06	5550076.0
2015-07-16 15:00:00	SPY	ETF	212.065	212.24	211.96	212.21	8751211.0
2015-07-16 15:30:00	SPY	ETF	212.21	212.3	212.16	212.25	18492499.0
2015-07-16 16:00:00	SPY	ETF	212.25	212.36	212.13	212.2	8427401.0
2015-07-16 16:30:00	SPY	ETF	212.2	212.29	212.14	212.2	1468177.0
2015-07-16 17:00:00	SPY	ETF	212.2	212.3	212.2	212.29	80724.0
2015-07-16 17:30:00	SPY	ETF	212.29	212.3	211.81	212.23	568162.0
2015-07-16 18:00:00	SPY	ETF	212.23	212.23	212.15	212.16	64497.0
2015-07-16 18:30:00	SPY	ETF	212.15	212.22	212.14	212.22	10727.0
2015-07-16 19:00:00	SPY	ETF	212.21	212.33	212.21	212.32	10380.0
2015-07-16 19:30:00	SPY	ETF	212.3	212.3	212.21	212.25	64985.0
2015-07-16 04:00:00	QQQ	ETF	111.03	111.03	111.03	111.03	100.0
2015-07-16 04:30:00	QQQ	ETF	111.11	111.22	111.06	111.22	36957.0
2015-07-16 05:00:00	QQQ	ETF	111.22	111.22	111.22	111.22	1800.0
2015-07-16 05:30:00	QQQ	ETF	111.22	111.23	111.17	111.23	20377.0
2015-07-16 06:00:00	QQQ	ETF	111.19	111.19	111.19	111.19	500.0
2015-07-16 06:30:00	QQQ	ETF	111.2	111.2	111.15	111.18	22000.0
2015-07-16 07:00:00	QQQ	ETF	111.18	111.2	111.15	111.19	64622.0
2015-07-16 07:30:00	QQQ	ETF	111.19	111.22	111.17	111.2	123195.0
2015-07-16 08:00:00	QQQ	ETF	111.18	111.21	111.16	111.17	84231.0
2015-07-16 08:30:00	QQQ	ETF	111.16	111.31	111.16	111.26	167076.0
2015-07-16 09:00:00	QQQ	ETF	111.26	111.33	111.25	111.3	258371.0
2015-07-16 09:30:00	QQQ	ETF	111.29	111.42	111.07	111.3196	3230784.0
2015-07-16 10:00:00	QQQ	ETF	111.31	111.37	111.17	111.29	1441804.0
2015-07-16 10:30:00	QQQ	ETF	111.29	111.475	111.27	111.415	1504919.0
2015-07-16 11:00:00	QQQ	ETF	111.42	111.515	111.415	111.5	1160161.0
2015-07-16 11:30:00	QQQ	ETF	111.51	111.67	111.5	111.565	1283962.0
2015-07-16 12:00:00	QQQ	ETF	111.56	111.74	111.5548	111.69	1333242.0
2015-07-16 12:30:00	QQQ	ETF	111.69	111.71	111.54	111.565	945370.0

> showing 50 of 12,904 rows — these rows as CSV

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