PREVIEW / etf_30min / 2016-05-23

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-23.parquet
  size:    374 KB
  rows:    12,845

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
2016-05-23 04:00:00	SPY	ETF	205.4	206.12	205.25	205.96	16337.0
2016-05-23 04:30:00	SPY	ETF	206.06	206.11	205.98	205.99	3021.0
2016-05-23 05:00:00	SPY	ETF	206.0	206.0	205.62	205.65	4727.0
2016-05-23 05:30:00	SPY	ETF	205.73	205.73	205.23	205.29	4207.0
2016-05-23 06:00:00	SPY	ETF	205.25	205.25	205.07	205.23	2652.0
2016-05-23 06:30:00	SPY	ETF	205.27	205.3	205.2	205.21	1951.0
2016-05-23 07:00:00	SPY	ETF	205.25	205.38	205.13	205.3	139397.0
2016-05-23 07:30:00	SPY	ETF	205.39	205.75	205.25	205.6	98808.0
2016-05-23 08:00:00	SPY	ETF	205.6	205.69	204.861	205.4	383950.0
2016-05-23 08:30:00	SPY	ETF	205.42	205.53	205.31	205.34	166077.0
2016-05-23 09:00:00	SPY	ETF	205.33	205.53	205.3	205.49	248854.0
2016-05-23 09:30:00	SPY	ETF	205.51	205.69	205.2	205.43	7552592.0
2016-05-23 10:00:00	SPY	ETF	205.44	205.84	205.44	205.585	6771864.0
2016-05-23 10:30:00	SPY	ETF	205.57	205.7	205.29	205.4	4687539.0
2016-05-23 11:00:00	SPY	ETF	205.4	205.69	205.32	205.66	3395434.0
2016-05-23 11:30:00	SPY	ETF	205.65	205.71	205.1401	205.23	3350016.0
2016-05-23 12:00:00	SPY	ETF	205.24	205.44	205.19	205.42	2082924.0
2016-05-23 12:30:00	SPY	ETF	205.43	205.57	205.25	205.56	2964544.0
2016-05-23 13:00:00	SPY	ETF	205.57	205.68	205.49	205.56	2019771.0
2016-05-23 13:30:00	SPY	ETF	205.55	205.595	205.405	205.53	2127271.0
2016-05-23 14:00:00	SPY	ETF	205.53	205.7307	205.485	205.68	2368379.0
2016-05-23 14:30:00	SPY	ETF	205.6887	205.74	205.47	205.5299	1938412.0
2016-05-23 15:00:00	SPY	ETF	205.52	205.61	205.25	205.32	3165428.0
2016-05-23 15:30:00	SPY	ETF	205.32	205.49	204.985	205.15	9033938.0
2016-05-23 16:00:00	SPY	ETF	205.14	205.4449	204.96	205.04	4998037.0
2016-05-23 16:30:00	SPY	ETF	205.02	205.07	205.0	205.07	157524.0
2016-05-23 17:00:00	SPY	ETF	205.06	205.06	205.02	205.02	21782.0
2016-05-23 17:30:00	SPY	ETF	205.02	205.08	205.02	205.05	33540.0
2016-05-23 18:00:00	SPY	ETF	205.04	205.12	205.02	205.11	34995.0
2016-05-23 18:30:00	SPY	ETF	205.12	205.12	205.09	205.11	15821.0
2016-05-23 19:00:00	SPY	ETF	205.11	205.11	205.1	205.11	4529.0
2016-05-23 19:30:00	SPY	ETF	205.12	205.13	205.07	205.11	32728.0
2016-05-23 04:00:00	QQQ	ETF	106.3	106.85	106.3	106.82	4100.0
2016-05-23 04:30:00	QQQ	ETF	106.82	106.82	106.79	106.79	600.0
2016-05-23 05:00:00	QQQ	ETF	106.79	106.79	106.78	106.78	1200.0
2016-05-23 05:30:00	QQQ	ETF	106.66	106.66	106.66	106.66	2000.0
2016-05-23 06:00:00	QQQ	ETF	106.34	106.39	106.29	106.36	7400.0
2016-05-23 06:30:00	QQQ	ETF	106.4	106.4	106.38	106.38	1103.0
2016-05-23 07:00:00	QQQ	ETF	106.37	106.47	106.36	106.46	6865.0
2016-05-23 07:30:00	QQQ	ETF	106.45	106.7	106.45	106.66	4104.0
2016-05-23 08:00:00	QQQ	ETF	106.63	106.64	106.4	106.56	34067.0
2016-05-23 08:30:00	QQQ	ETF	106.55	106.59	106.48	106.48	12246.0
2016-05-23 09:00:00	QQQ	ETF	106.49	106.56	106.46	106.54	67770.0
2016-05-23 09:30:00	QQQ	ETF	106.55	106.94	106.47	106.81	3161938.0
2016-05-23 10:00:00	QQQ	ETF	106.81	106.97	106.73	106.8	1700748.0
2016-05-23 10:30:00	QQQ	ETF	106.8	106.94	106.62	106.68	862851.0
2016-05-23 11:00:00	QQQ	ETF	106.68	106.86	106.64	106.78	571608.0
2016-05-23 11:30:00	QQQ	ETF	106.77	106.8	106.5	106.56	547313.0
2016-05-23 12:00:00	QQQ	ETF	106.565	106.645	106.53	106.64	400492.0
2016-05-23 12:30:00	QQQ	ETF	106.64	106.7366	106.545	106.71	414692.0

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

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