PREVIEW / etf_30min / 2015-05-26

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-26.parquet
  size:    386 KB
  rows:    13,012

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-05-26 04:00:00	SPY	ETF	212.6	212.6	212.1	212.1	23038.0
2015-05-26 04:30:00	SPY	ETF	212.15	212.22	212.15	212.22	705.0
2015-05-26 05:00:00	SPY	ETF	212.25	212.29	212.15	212.15	2000.0
2015-05-26 05:30:00	SPY	ETF	212.28	212.28	212.2	212.25	9100.0
2015-05-26 06:00:00	SPY	ETF	212.22	212.42	212.22	212.42	7802.0
2015-05-26 06:30:00	SPY	ETF	212.41	212.99	212.41	212.66	114893.0
2015-05-26 07:00:00	SPY	ETF	212.6	212.68	212.57	212.64	55906.0
2015-05-26 07:30:00	SPY	ETF	212.62	212.83	212.61	212.68	118661.0
2015-05-26 08:00:00	SPY	ETF	212.69	212.73	212.57	212.68	354541.0
2015-05-26 08:30:00	SPY	ETF	212.71	212.73	212.28	212.4	493983.0
2015-05-26 09:00:00	SPY	ETF	212.4	212.42	212.17	212.4	591123.0
2015-05-26 09:30:00	SPY	ETF	212.4	212.5	211.47	211.57	14739772.0
2015-05-26 10:00:00	SPY	ETF	211.59	211.69	211.05	211.289	11861535.0
2015-05-26 10:30:00	SPY	ETF	211.29	211.29	210.83	210.9	6655862.0
2015-05-26 11:00:00	SPY	ETF	210.91	211.02	210.61	210.98	6693305.0
2015-05-26 11:30:00	SPY	ETF	210.985	211.24	210.86	210.89	5267992.0
2015-05-26 12:00:00	SPY	ETF	210.9	211.11	210.8	211.03	3877768.0
2015-05-26 12:30:00	SPY	ETF	211.02	211.07	210.67	210.695	3225477.0
2015-05-26 13:00:00	SPY	ETF	210.7	210.88	210.43	210.83	5590910.0
2015-05-26 13:30:00	SPY	ETF	210.83	210.83	210.27	210.35	5882053.0
2015-05-26 14:00:00	SPY	ETF	210.34	212.9089	210.34	210.384	8025988.0
2015-05-26 14:30:00	SPY	ETF	210.385	210.54	210.21	210.24	10496171.0
2015-05-26 15:00:00	SPY	ETF	210.25	210.68	210.2	210.61	8490697.0
2015-05-26 15:30:00	SPY	ETF	210.61	210.92	210.58	210.73	17363067.0
2015-05-26 16:00:00	SPY	ETF	210.73	212.0	210.7	211.12	6873416.0
2015-05-26 16:30:00	SPY	ETF	211.15	211.18	210.7	211.13	4070235.0
2015-05-26 17:00:00	SPY	ETF	210.7	211.22	210.7	211.19	216489.0
2015-05-26 17:30:00	SPY	ETF	211.16	211.18	211.15	211.15	12610.0
2015-05-26 18:00:00	SPY	ETF	211.15	211.15	210.99	211.05	112042.0
2015-05-26 18:30:00	SPY	ETF	211.05	211.1	211.05	211.06	9537.0
2015-05-26 19:00:00	SPY	ETF	211.05	211.05	211.01	211.03	15134.0
2015-05-26 19:30:00	SPY	ETF	211.02	211.09	210.91	210.95	86443.0
2015-05-26 04:00:00	QQQ	ETF	110.07	110.07	109.95	109.95	31970.0
2015-05-26 05:30:00	QQQ	ETF	109.99	109.99	109.99	109.99	5890.0
2015-05-26 06:00:00	QQQ	ETF	110.0	110.18	110.0	110.18	2900.0
2015-05-26 06:30:00	QQQ	ETF	110.34	110.35	110.34	110.35	20200.0
2015-05-26 07:00:00	QQQ	ETF	110.34	110.36	110.34	110.35	29200.0
2015-05-26 07:30:00	QQQ	ETF	110.41	110.43	110.41	110.41	23700.0
2015-05-26 08:00:00	QQQ	ETF	110.42	110.42	110.35	110.4	110227.0
2015-05-26 08:30:00	QQQ	ETF	110.44	110.44	110.14	110.17	105336.0
2015-05-26 09:00:00	QQQ	ETF	110.15	110.24	110.07	110.24	196943.0
2015-05-26 09:30:00	QQQ	ETF	110.23	110.38	109.53	109.56	3882427.0
2015-05-26 10:00:00	QQQ	ETF	109.56	109.65	109.17	109.41	2776256.0
2015-05-26 10:30:00	QQQ	ETF	109.4	109.41	109.15	109.2	1764743.0
2015-05-26 11:00:00	QQQ	ETF	109.2	109.24	108.99	109.16	2002850.0
2015-05-26 11:30:00	QQQ	ETF	109.15	109.32	109.11	109.21	921025.0
2015-05-26 12:00:00	QQQ	ETF	109.22	109.33	109.13	109.3	796144.0
2015-05-26 12:30:00	QQQ	ETF	109.3	109.32	109.07	109.1	832662.0
2015-05-26 13:00:00	QQQ	ETF	109.1	109.2	108.92	109.1501	1206290.0
2015-05-26 13:30:00	QQQ	ETF	109.1551	109.16	108.84	108.87	1032663.0

> showing 50 of 13,012 rows — these rows as CSV

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