PREVIEW / etf_30min / 2015-08-17

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-17.parquet
  size:    366 KB
  rows:    12,318

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-08-17 04:00:00	SPY	ETF	209.47	209.47	209.11	209.22	109840.0
2015-08-17 04:30:00	SPY	ETF	209.31	209.5	209.29	209.45	17410.0
2015-08-17 05:00:00	SPY	ETF	209.53	209.61	209.45	209.58	3061.0
2015-08-17 05:30:00	SPY	ETF	209.54	209.64	209.54	209.64	1936.0
2015-08-17 06:00:00	SPY	ETF	209.45	209.52	209.39	209.43	11900.0
2015-08-17 06:30:00	SPY	ETF	209.4	209.49	209.35	209.44	18762.0
2015-08-17 07:00:00	SPY	ETF	209.41	209.49	209.35	209.45	42267.0
2015-08-17 07:30:00	SPY	ETF	209.54	209.54	209.29	209.37	164827.0
2015-08-17 08:00:00	SPY	ETF	209.37	209.5	209.05	209.15	387534.0
2015-08-17 08:30:00	SPY	ETF	209.14	209.14	208.64	208.78	1311951.0
2015-08-17 09:00:00	SPY	ETF	208.78	208.95	208.69	208.71	464898.0
2015-08-17 09:30:00	SPY	ETF	208.71	208.74	208.16	208.39	13219079.0
2015-08-17 10:00:00	SPY	ETF	208.4	209.44	208.27	209.23	9766489.0
2015-08-17 10:30:00	SPY	ETF	209.23	209.6999	209.04	209.66	5579095.0
2015-08-17 11:00:00	SPY	ETF	209.66	210.05	209.645	209.86	5468783.0
2015-08-17 11:30:00	SPY	ETF	209.855	210.0	209.72	209.83	3256250.0
2015-08-17 12:00:00	SPY	ETF	209.83	210.02	209.8	209.93	2662815.0
2015-08-17 12:30:00	SPY	ETF	209.935	210.24	209.9	210.22	3451039.0
2015-08-17 13:00:00	SPY	ETF	210.22	210.4	210.16	210.379	3348202.0
2015-08-17 13:30:00	SPY	ETF	210.38	210.42	210.28	210.28	3757838.0
2015-08-17 14:00:00	SPY	ETF	210.29	210.43	210.16	210.19	2559603.0
2015-08-17 14:30:00	SPY	ETF	210.195	210.38	210.175	210.37	2998577.0
2015-08-17 15:00:00	SPY	ETF	210.375	210.46	210.25	210.35	3734207.0
2015-08-17 15:30:00	SPY	ETF	210.35	210.58	210.26	210.58	12885089.0
2015-08-17 16:00:00	SPY	ETF	210.57	210.69	208.5948	210.59	2215746.0
2015-08-17 16:30:00	SPY	ETF	210.58	210.59	210.53	210.53	708312.0
2015-08-17 17:00:00	SPY	ETF	210.53	210.56	210.51	210.55	125263.0
2015-08-17 17:30:00	SPY	ETF	210.59	210.59	210.53	210.53	104284.0
2015-08-17 18:00:00	SPY	ETF	210.53	210.65	210.52	210.64	27145.0
2015-08-17 18:30:00	SPY	ETF	210.59	210.6	210.56	210.57	29510.0
2015-08-17 19:00:00	SPY	ETF	210.58	210.62	210.53	210.54	37506.0
2015-08-17 19:30:00	SPY	ETF	210.56	210.61	210.54	210.6	33827.0
2015-08-17 04:00:00	QQQ	ETF	110.5	110.53	110.4	110.4	14200.0
2015-08-17 04:30:00	QQQ	ETF	110.64	110.64	110.64	110.64	200.0
2015-08-17 07:00:00	QQQ	ETF	110.6	110.6	110.6	110.6	400.0
2015-08-17 07:30:00	QQQ	ETF	110.6	110.61	110.58	110.61	12900.0
2015-08-17 08:00:00	QQQ	ETF	110.607	110.61	110.43	110.49	58362.0
2015-08-17 08:30:00	QQQ	ETF	110.49	110.49	110.2	110.3	105577.0
2015-08-17 09:00:00	QQQ	ETF	110.29	110.38	110.23	110.24	166125.0
2015-08-17 09:30:00	QQQ	ETF	110.24	110.26	109.96	110.16	3145196.0
2015-08-17 10:00:00	QQQ	ETF	110.16	110.84	110.08	110.64	2689388.0
2015-08-17 10:30:00	QQQ	ETF	110.63	110.89	110.5	110.84	1766060.0
2015-08-17 11:00:00	QQQ	ETF	110.85	111.1068	110.84	110.92	1624390.0
2015-08-17 11:30:00	QQQ	ETF	110.91	111.06	110.85	110.948	943953.0
2015-08-17 12:00:00	QQQ	ETF	110.95	111.0499	110.9	110.99	569627.0
2015-08-17 12:30:00	QQQ	ETF	110.99	111.2	110.95	111.18	980635.0
2015-08-17 13:00:00	QQQ	ETF	111.19	111.36	111.165	111.33	1067849.0
2015-08-17 13:30:00	QQQ	ETF	111.34	111.37	111.2605	111.29	774215.0
2015-08-17 14:00:00	QQQ	ETF	111.29	111.41	111.2199	111.26	697672.0
2015-08-17 14:30:00	QQQ	ETF	111.265	111.36	111.245	111.34	646471.0

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

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