PREVIEW / etf_30min / 2015-06-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-23.parquet
  size:    371 KB
  rows:    12,772

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-06-23 04:00:00	SPY	ETF	212.14	212.18	212.1	212.1	4200.0
2015-06-23 04:30:00	SPY	ETF	212.08	212.12	212.06	212.06	1200.0
2015-06-23 05:00:00	SPY	ETF	212.07	212.07	211.95	211.97	19050.0
2015-06-23 05:30:00	SPY	ETF	211.96	212.1	211.95	212.02	5500.0
2015-06-23 06:00:00	SPY	ETF	212.03	212.13	211.99	212.05	12763.0
2015-06-23 06:30:00	SPY	ETF	212.05	212.19	211.91	212.08	67355.0
2015-06-23 07:00:00	SPY	ETF	212.07	212.18	211.95	212.14	74122.0
2015-06-23 07:30:00	SPY	ETF	212.15	212.28	212.13	212.24	158101.0
2015-06-23 08:00:00	SPY	ETF	212.24	212.35	212.0	212.2	198894.0
2015-06-23 08:30:00	SPY	ETF	212.15	212.28	211.84	211.93	317963.0
2015-06-23 09:00:00	SPY	ETF	211.92	212.16	211.87	212.14	571825.0
2015-06-23 09:30:00	SPY	ETF	212.14	212.31	212.07	212.255	6356918.0
2015-06-23 10:00:00	SPY	ETF	212.255	212.44	211.865	211.93	7207986.0
2015-06-23 10:30:00	SPY	ETF	211.93	212.07	211.7	211.86	5183358.0
2015-06-23 11:00:00	SPY	ETF	211.85	212.02	211.73	211.75	5622214.0
2015-06-23 11:30:00	SPY	ETF	211.76	211.99	211.71	211.84	3763976.0
2015-06-23 12:00:00	SPY	ETF	211.8488	211.86	211.57	211.7	3769577.0
2015-06-23 12:30:00	SPY	ETF	211.71	211.79	211.65	211.68	3058797.0
2015-06-23 13:00:00	SPY	ETF	211.68	211.83	211.59	211.76	2416276.0
2015-06-23 13:30:00	SPY	ETF	211.77	211.94	211.74	211.89	2453063.0
2015-06-23 14:00:00	SPY	ETF	211.89	211.94	211.83	211.89	2435755.0
2015-06-23 14:30:00	SPY	ETF	211.895	212.15	211.84	212.07	3393082.0
2015-06-23 15:00:00	SPY	ETF	212.06	212.09	211.93	212.06	2939201.0
2015-06-23 15:30:00	SPY	ETF	212.05	212.17	212.0	212.03	8829608.0
2015-06-23 16:00:00	SPY	ETF	212.03	212.11	211.95	212.11	5522969.0
2015-06-23 16:30:00	SPY	ETF	212.11	212.24	212.11	212.12	1150669.0
2015-06-23 17:00:00	SPY	ETF	212.13	212.2	212.13	212.2	48244.0
2015-06-23 17:30:00	SPY	ETF	212.14	212.16	211.97	212.16	53591.0
2015-06-23 18:00:00	SPY	ETF	212.13	212.23	212.13	212.17	117522.0
2015-06-23 18:30:00	SPY	ETF	212.17	212.17	212.13	212.16	7704.0
2015-06-23 19:00:00	SPY	ETF	212.16	212.18	212.07	212.12	26715.0
2015-06-23 19:30:00	SPY	ETF	212.127	212.19	212.11	212.19	75300.0
2015-06-23 04:00:00	QQQ	ETF	110.81	110.81	110.81	110.81	641.0
2015-06-23 04:30:00	QQQ	ETF	110.8	110.8	110.8	110.8	100.0
2015-06-23 06:00:00	QQQ	ETF	110.8	110.8	110.8	110.8	100.0
2015-06-23 06:30:00	QQQ	ETF	110.85	110.85	110.8	110.8	500.0
2015-06-23 07:00:00	QQQ	ETF	110.8	110.83	110.76	110.83	45834.0
2015-06-23 07:30:00	QQQ	ETF	110.85	110.89	110.85	110.88	8963.0
2015-06-23 08:00:00	QQQ	ETF	110.87	110.95	110.77	110.863	29824.0
2015-06-23 08:30:00	QQQ	ETF	110.87	110.89	110.7	110.72	35752.0
2015-06-23 09:00:00	QQQ	ETF	110.73	110.84	110.71	110.81	18612.0
2015-06-23 09:30:00	QQQ	ETF	110.82	110.89	110.61	110.649	2233209.0
2015-06-23 10:00:00	QQQ	ETF	110.638	110.79	110.41	110.44	1871614.0
2015-06-23 10:30:00	QQQ	ETF	110.44	110.54	110.33	110.4986	1447466.0
2015-06-23 11:00:00	QQQ	ETF	110.49	110.64	110.45	110.53	962471.0
2015-06-23 11:30:00	QQQ	ETF	110.55	110.67	110.5222	110.61	602419.0
2015-06-23 12:00:00	QQQ	ETF	110.6	110.62	110.44	110.51	686705.0
2015-06-23 12:30:00	QQQ	ETF	110.51	110.55	110.47	110.5	412893.0
2015-06-23 13:00:00	QQQ	ETF	110.495	110.6	110.44	110.56	595029.0
2015-06-23 13:30:00	QQQ	ETF	110.56	110.68	110.55	110.635	717005.0

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

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