PREVIEW / etf_30min / 2015-08-11

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-11.parquet
  size:    388 KB
  rows:    13,015

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-08-11 04:00:00	SPY	ETF	209.85	210.1	209.6	210.0	41283.0
2015-08-11 04:30:00	SPY	ETF	210.06	210.06	209.67	209.73	13895.0
2015-08-11 05:00:00	SPY	ETF	209.68	209.73	209.49	209.49	54766.0
2015-08-11 05:30:00	SPY	ETF	209.48	209.54	209.22	209.31	163193.0
2015-08-11 06:00:00	SPY	ETF	209.28	209.39	209.21	209.37	146265.0
2015-08-11 06:30:00	SPY	ETF	209.32	209.86	209.29	209.84	122975.0
2015-08-11 07:00:00	SPY	ETF	209.81	209.84	209.58	209.66	199365.0
2015-08-11 07:30:00	SPY	ETF	209.62	209.62	209.35	209.51	272570.0
2015-08-11 08:00:00	SPY	ETF	209.51	210.6	208.97	209.1	1115228.0
2015-08-11 08:30:00	SPY	ETF	209.09	209.15	208.75	208.78	517063.0
2015-08-11 09:00:00	SPY	ETF	208.77	209.0	208.7	208.99	1014382.0
2015-08-11 09:30:00	SPY	ETF	208.97	209.3	208.71	208.99	16445346.0
2015-08-11 10:00:00	SPY	ETF	208.995	209.47	208.8199	209.23	8392171.0
2015-08-11 10:30:00	SPY	ETF	209.23	209.32	208.89	208.91	6964377.0
2015-08-11 11:00:00	SPY	ETF	208.9	209.0	208.28	208.36	6585818.0
2015-08-11 11:30:00	SPY	ETF	208.35	208.62	208.06	208.2	6227617.0
2015-08-11 12:00:00	SPY	ETF	208.2	208.47	208.16	208.43	6283883.0
2015-08-11 12:30:00	SPY	ETF	208.43	208.56	208.064	208.11	4030202.0
2015-08-11 13:00:00	SPY	ETF	208.11	208.16	207.76	208.02	7957514.0
2015-08-11 13:30:00	SPY	ETF	208.02	208.29	207.89	207.9	5297932.0
2015-08-11 14:00:00	SPY	ETF	207.9	208.26	207.82	208.17	5044141.0
2015-08-11 14:30:00	SPY	ETF	208.17	208.39	207.945	208.305	7624064.0
2015-08-11 15:00:00	SPY	ETF	208.31	208.6	208.17	208.54	6433282.0
2015-08-11 15:30:00	SPY	ETF	208.53	208.79	208.37	208.63	17595797.0
2015-08-11 16:00:00	SPY	ETF	208.65	208.84	208.5617	208.68	10838282.0
2015-08-11 16:30:00	SPY	ETF	208.68	208.79	208.67	208.72	4329122.0
2015-08-11 17:00:00	SPY	ETF	208.71	208.8	208.71	208.73	147673.0
2015-08-11 17:30:00	SPY	ETF	208.74	208.79	208.71	208.73	22184.0
2015-08-11 18:00:00	SPY	ETF	208.75	208.82	208.69	208.73	45930.0
2015-08-11 18:30:00	SPY	ETF	208.74	208.82	208.7	208.82	8040.0
2015-08-11 19:00:00	SPY	ETF	208.77	208.82	208.76	208.8	4000.0
2015-08-11 19:30:00	SPY	ETF	208.8	209.02	208.8	208.99	81002.0
2015-08-11 04:00:00	QQQ	ETF	111.48	111.57	111.48	111.57	600.0
2015-08-11 04:30:00	QQQ	ETF	111.39	111.39	111.29	111.29	7500.0
2015-08-11 05:00:00	QQQ	ETF	111.24	111.24	111.24	111.24	2500.0
2015-08-11 05:30:00	QQQ	ETF	111.2	111.2	111.09	111.09	10100.0
2015-08-11 06:00:00	QQQ	ETF	111.11	111.17	111.09	111.14	3150.0
2015-08-11 06:30:00	QQQ	ETF	111.19	111.42	111.19	111.42	800.0
2015-08-11 07:00:00	QQQ	ETF	111.44	111.44	111.31	111.33	30550.0
2015-08-11 07:30:00	QQQ	ETF	111.33	111.33	111.17	111.23	31150.0
2015-08-11 08:00:00	QQQ	ETF	111.23	111.34	110.86	110.93	183315.0
2015-08-11 08:30:00	QQQ	ETF	110.9	110.98	110.72	110.72	168491.0
2015-08-11 09:00:00	QQQ	ETF	110.73	110.98	110.71	110.98	382625.0
2015-08-11 09:30:00	QQQ	ETF	110.98	111.4101	110.71	111.16	4772228.0
2015-08-11 10:00:00	QQQ	ETF	111.16	111.25	110.88	111.06	2127922.0
2015-08-11 10:30:00	QQQ	ETF	111.07	111.09	110.75	110.7572	2118062.0
2015-08-11 11:00:00	QQQ	ETF	110.75	110.8268	110.27	110.31	2128883.0
2015-08-11 11:30:00	QQQ	ETF	110.3	110.49	110.02	110.13	2033988.0
2015-08-11 12:00:00	QQQ	ETF	110.12	110.24	110.07	110.21	1685282.0
2015-08-11 12:30:00	QQQ	ETF	110.216	110.344	109.95	109.9701	1013193.0

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

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