PREVIEW / etf_30min / 2015-10-14

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-14.parquet
  size:    373 KB
  rows:    12,509

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-10-14 04:00:00	SPY	ETF	200.1	200.3	200.09	200.18	1710.0
2015-10-14 04:30:00	SPY	ETF	200.07	200.1	199.68	199.83	9506.0
2015-10-14 05:00:00	SPY	ETF	199.81	199.99	199.81	199.99	1483.0
2015-10-14 05:30:00	SPY	ETF	199.91	200.07	199.91	200.07	2700.0
2015-10-14 06:00:00	SPY	ETF	200.02	200.13	199.91	199.92	8962.0
2015-10-14 06:30:00	SPY	ETF	200.0	200.06	199.88	199.99	54221.0
2015-10-14 07:00:00	SPY	ETF	199.98	200.2	199.98	200.15	46300.0
2015-10-14 07:30:00	SPY	ETF	200.18	200.31	200.09	200.26	161867.0
2015-10-14 08:00:00	SPY	ETF	200.25	200.55	200.04	200.41	341092.0
2015-10-14 08:30:00	SPY	ETF	200.48	200.5	199.95	200.04	875876.0
2015-10-14 09:00:00	SPY	ETF	200.03	200.19	199.89	200.18	872626.0
2015-10-14 09:30:00	SPY	ETF	200.18	200.87	200.0	200.7311	8731128.0
2015-10-14 10:00:00	SPY	ETF	200.75	200.79	199.75	199.915	7487508.0
2015-10-14 10:30:00	SPY	ETF	199.91	200.01	199.34	199.55	10133185.0
2015-10-14 11:00:00	SPY	ETF	199.56	199.83	199.23	199.52	6815831.0
2015-10-14 11:30:00	SPY	ETF	199.51	199.84	199.29	199.74	5181714.0
2015-10-14 12:00:00	SPY	ETF	199.74	199.84	199.34	199.71	4021832.0
2015-10-14 12:30:00	SPY	ETF	199.71	200.53	199.68	200.27	6592430.0
2015-10-14 13:00:00	SPY	ETF	200.26	200.38	199.87	199.96	3260317.0
2015-10-14 13:30:00	SPY	ETF	199.9699	200.1363	199.83	200.005	4245006.0
2015-10-14 14:00:00	SPY	ETF	200.005	200.24	199.28	199.3	6601589.0
2015-10-14 14:30:00	SPY	ETF	199.3	199.4	198.97	199.15	6765287.0
2015-10-14 15:00:00	SPY	ETF	199.14	199.53	198.94	199.34	6695552.0
2015-10-14 15:30:00	SPY	ETF	199.35	199.65	199.06	199.27	11899196.0
2015-10-14 16:00:00	SPY	ETF	199.28	200.6655	198.95	199.14	5276220.0
2015-10-14 16:30:00	SPY	ETF	199.2	199.3273	199.1	199.21	810761.0
2015-10-14 17:00:00	SPY	ETF	199.18	199.43	199.14	199.17	294843.0
2015-10-14 17:30:00	SPY	ETF	199.17	199.26	199.16	199.26	46484.0
2015-10-14 18:00:00	SPY	ETF	199.25	199.58	199.24	199.42	113559.0
2015-10-14 18:30:00	SPY	ETF	199.4	199.5	199.4	199.48	33205.0
2015-10-14 19:00:00	SPY	ETF	199.47	199.5	199.42	199.45	43047.0
2015-10-14 19:30:00	SPY	ETF	199.45	199.48	199.42	199.47	22745.0
2015-10-14 04:00:00	QQQ	ETF	105.89	105.91	105.89	105.91	4300.0
2015-10-14 04:30:00	QQQ	ETF	105.78	105.78	105.7	105.7	2200.0
2015-10-14 05:00:00	QQQ	ETF	105.8	105.8	105.8	105.8	100.0
2015-10-14 06:00:00	QQQ	ETF	105.86	105.96	105.85	105.85	1146.0
2015-10-14 06:30:00	QQQ	ETF	105.84	105.91	105.84	105.88	2045.0
2015-10-14 07:00:00	QQQ	ETF	105.97	105.97	105.94	105.97	2400.0
2015-10-14 07:30:00	QQQ	ETF	105.97	105.98	105.94	105.97	7329.0
2015-10-14 08:00:00	QQQ	ETF	105.9	106.26	105.86	106.21	45626.0
2015-10-14 08:30:00	QQQ	ETF	106.17	106.17	105.99	106.02	16049.0
2015-10-14 09:00:00	QQQ	ETF	105.96	106.13	105.94	106.1	51923.0
2015-10-14 09:30:00	QQQ	ETF	106.1	106.6	106.06	106.51	3545230.0
2015-10-14 10:00:00	QQQ	ETF	106.505	106.54	105.64	105.8	3462109.0
2015-10-14 10:30:00	QQQ	ETF	105.81	105.81	105.49	105.7	3356683.0
2015-10-14 11:00:00	QQQ	ETF	105.705	105.91	105.595	105.7749	1808174.0
2015-10-14 11:30:00	QQQ	ETF	105.78	105.96	105.64	105.92	1353930.0
2015-10-14 12:00:00	QQQ	ETF	105.92	106.07	105.69	105.9851	1008435.0
2015-10-14 12:30:00	QQQ	ETF	105.99	106.63	105.95	106.49	2631015.0
2015-10-14 13:00:00	QQQ	ETF	106.49	106.57	106.25	106.3399	1295644.0

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

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