PREVIEW / etf_30min / 2017-04-04

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-04.parquet
  size:    424 KB
  rows:    14,425

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
2017-04-04 04:00:00	SPY	ETF	234.76	234.76	234.6	234.7	2640.0
2017-04-04 04:30:00	SPY	ETF	234.87	234.88	234.8	234.8	5300.0
2017-04-04 05:00:00	SPY	ETF	234.75	234.8	234.7	234.7	6002.0
2017-04-04 05:30:00	SPY	ETF	234.78	234.8	234.78	234.8	1301.0
2017-04-04 06:00:00	SPY	ETF	234.85	235.07	234.85	235.02	6210.0
2017-04-04 06:30:00	SPY	ETF	235.0	235.04	234.93	234.93	27536.0
2017-04-04 07:00:00	SPY	ETF	235.03	235.07	234.74	234.74	134996.0
2017-04-04 07:30:00	SPY	ETF	234.75	234.75	234.49	234.56	82554.0
2017-04-04 08:00:00	SPY	ETF	234.76	235.03	234.41	234.66	304385.0
2017-04-04 08:30:00	SPY	ETF	234.67	234.7	234.54	234.7	285892.0
2017-04-04 09:00:00	SPY	ETF	234.72	235.0	234.71	234.95	547800.0
2017-04-04 09:30:00	SPY	ETF	235.0	235.33	234.87	235.06	6644832.0
2017-04-04 10:00:00	SPY	ETF	235.06	235.15	234.555	234.8395	6554649.0
2017-04-04 10:30:00	SPY	ETF	234.84	235.13	234.74	234.885	3428157.0
2017-04-04 11:00:00	SPY	ETF	234.87	235.48	234.83	235.25	3082171.0
2017-04-04 11:30:00	SPY	ETF	235.255	235.51	235.17	235.315	2581987.0
2017-04-04 12:00:00	SPY	ETF	235.31	235.43	235.1701	235.26	2149877.0
2017-04-04 12:30:00	SPY	ETF	235.26	235.3352	235.02	235.07	1983832.0
2017-04-04 13:00:00	SPY	ETF	235.05	235.28	234.94	235.169	2078910.0
2017-04-04 13:30:00	SPY	ETF	235.165	235.33	235.14	235.27	1255882.0
2017-04-04 14:00:00	SPY	ETF	235.275	235.54	235.255	235.5	2132883.0
2017-04-04 14:30:00	SPY	ETF	235.5	235.52	235.23	235.245	2306110.0
2017-04-04 15:00:00	SPY	ETF	235.24	235.36	235.11	235.165	2449814.0
2017-04-04 15:30:00	SPY	ETF	235.17	235.58	235.17	235.51	9337898.0
2017-04-04 16:00:00	SPY	ETF	235.52	235.72	235.2115	235.61	7306668.0
2017-04-04 16:30:00	SPY	ETF	235.59	235.76	235.48	235.73	353705.0
2017-04-04 17:00:00	SPY	ETF	235.73	235.76	235.7	235.72	72012.0
2017-04-04 17:30:00	SPY	ETF	235.72	235.73	235.7	235.73	16209.0
2017-04-04 18:00:00	SPY	ETF	235.74	235.83	235.74	235.77	115058.0
2017-04-04 18:30:00	SPY	ETF	235.77	235.8	235.73	235.74	7701.0
2017-04-04 19:00:00	SPY	ETF	235.74	235.76	235.74	235.75	3565.0
2017-04-04 19:30:00	SPY	ETF	235.76	235.78	235.71	235.74	22404.0
2017-04-04 04:00:00	QQQ	ETF	131.99	131.99	131.87	131.87	3200.0
2017-04-04 04:30:00	QQQ	ETF	131.94	131.94	131.94	131.94	1400.0
2017-04-04 05:00:00	QQQ	ETF	131.95	131.95	131.95	131.95	400.0
2017-04-04 05:30:00	QQQ	ETF	131.9	131.9	131.9	131.9	100.0
2017-04-04 06:00:00	QQQ	ETF	132.06	132.06	132.06	132.06	300.0
2017-04-04 06:30:00	QQQ	ETF	132.03	132.03	132.03	132.03	100.0
2017-04-04 07:00:00	QQQ	ETF	131.99	132.03	131.88	131.88	17444.0
2017-04-04 07:30:00	QQQ	ETF	131.79	131.8	131.73	131.73	18300.0
2017-04-04 08:00:00	QQQ	ETF	131.76	132.0	131.66	131.77	53915.0
2017-04-04 08:30:00	QQQ	ETF	131.77	131.81	131.7	131.81	45374.0
2017-04-04 09:00:00	QQQ	ETF	131.82	131.94	131.81	131.89	250350.0
2017-04-04 09:30:00	QQQ	ETF	131.9	132.35	131.9	132.15	1815820.0
2017-04-04 10:00:00	QQQ	ETF	132.159	132.22	131.87	132.11	1317481.0
2017-04-04 10:30:00	QQQ	ETF	132.115	132.24	131.96	132.035	733171.0
2017-04-04 11:00:00	QQQ	ETF	132.03	132.39	132.01	132.24	680660.0
2017-04-04 11:30:00	QQQ	ETF	132.235	132.3664	132.19	132.23	592261.0
2017-04-04 12:00:00	QQQ	ETF	132.23	132.32	132.13	132.25	476256.0
2017-04-04 12:30:00	QQQ	ETF	132.2593	132.32	132.13	132.159	749155.0

> showing 50 of 14,425 rows — these rows as CSV

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