PREVIEW / etf_30min / 2014-03-07

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-07.parquet
  size:    340 KB
  rows:    11,432

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
2014-03-07 04:00:00	SPY	ETF	188.11	188.22	188.1	188.19	14128.0
2014-03-07 04:30:00	SPY	ETF	188.17	188.29	188.16	188.29	2401.0
2014-03-07 05:00:00	SPY	ETF	188.24	188.25	188.19	188.2	7547.0
2014-03-07 05:30:00	SPY	ETF	188.2	188.28	188.2	188.24	1303.0
2014-03-07 06:00:00	SPY	ETF	188.26	188.48	188.22	188.42	7179.0
2014-03-07 06:30:00	SPY	ETF	188.45	188.45	188.25	188.3	10221.0
2014-03-07 07:00:00	SPY	ETF	188.31	188.32	188.22	188.31	144838.0
2014-03-07 07:30:00	SPY	ETF	188.25	188.38	188.25	188.28	53829.0
2014-03-07 08:00:00	SPY	ETF	188.3	188.41	188.21	188.37	581389.0
2014-03-07 08:30:00	SPY	ETF	188.42	189.26	188.42	189.08	4330667.0
2014-03-07 09:00:00	SPY	ETF	189.06	189.1	188.74	188.85	1728803.0
2014-03-07 09:30:00	SPY	ETF	188.87	188.96	187.9	188.18	17900158.0
2014-03-07 10:00:00	SPY	ETF	188.18	188.62	187.91	188.4	9926836.0
2014-03-07 10:30:00	SPY	ETF	188.4	188.56	188.02	188.02	6407609.0
2014-03-07 11:00:00	SPY	ETF	188.03	188.06	187.43	187.785	10275258.0
2014-03-07 11:30:00	SPY	ETF	187.785	188.2	187.67	188.135	7266366.0
2014-03-07 12:00:00	SPY	ETF	188.14	188.26	187.92	188.21	4050718.0
2014-03-07 12:30:00	SPY	ETF	188.21	188.24	188.0	188.035	2488086.0
2014-03-07 13:00:00	SPY	ETF	188.03	188.06	187.75	187.89	3357379.0
2014-03-07 13:30:00	SPY	ETF	187.88	187.98	187.67	187.92	3269536.0
2014-03-07 14:00:00	SPY	ETF	187.92	187.98	187.54	187.69	5148900.0
2014-03-07 14:30:00	SPY	ETF	187.7	188.09	187.63	187.96	5682186.0
2014-03-07 15:00:00	SPY	ETF	187.97	188.16	187.905	187.99	4306308.0
2014-03-07 15:30:00	SPY	ETF	187.99	188.22	187.69	188.21	13651405.0
2014-03-07 16:00:00	SPY	ETF	188.22	188.34	188.0	188.29	6351315.0
2014-03-07 16:30:00	SPY	ETF	188.28	188.28	188.21	188.26	606629.0
2014-03-07 17:00:00	SPY	ETF	188.26	188.28	188.18	188.26	117157.0
2014-03-07 17:30:00	SPY	ETF	188.23	188.26	188.18	188.24	16275.0
2014-03-07 18:00:00	SPY	ETF	188.21	188.24	188.18	188.18	8865.0
2014-03-07 18:30:00	SPY	ETF	188.2	188.22	188.2	188.21	3410.0
2014-03-07 19:00:00	SPY	ETF	188.2	188.25	188.2	188.25	9408.0
2014-03-07 19:30:00	SPY	ETF	188.22	188.24	188.21	188.21	15040.0
2014-03-07 04:00:00	QQQ	ETF	90.9	90.96	90.86	90.96	24500.0
2014-03-07 04:30:00	QQQ	ETF	90.97	90.99	90.96	90.99	16150.0
2014-03-07 05:30:00	QQQ	ETF	90.97	90.97	90.97	90.97	200.0
2014-03-07 06:00:00	QQQ	ETF	91.02	91.08	91.01	91.08	2921.0
2014-03-07 06:30:00	QQQ	ETF	91.03	91.05	91.03	91.04	1600.0
2014-03-07 07:00:00	QQQ	ETF	91.02	91.03	91.02	91.03	6200.0
2014-03-07 07:30:00	QQQ	ETF	90.99	91.03	90.98	90.99	63800.0
2014-03-07 08:00:00	QQQ	ETF	91.0	91.0	90.9	90.95	28055.0
2014-03-07 08:30:00	QQQ	ETF	91.03	91.4	91.03	91.3	570233.0
2014-03-07 09:00:00	QQQ	ETF	91.3	91.31	91.17	91.26	240205.0
2014-03-07 09:30:00	QQQ	ETF	91.27	91.36	90.36	90.54	6506933.0
2014-03-07 10:00:00	QQQ	ETF	90.54	90.78	90.41	90.68	3057969.0
2014-03-07 10:30:00	QQQ	ETF	90.69	90.77	90.47	90.48	2331392.0
2014-03-07 11:00:00	QQQ	ETF	90.48	90.48	90.12	90.33	3617298.0
2014-03-07 11:30:00	QQQ	ETF	90.33	90.5	90.25	90.47	1412064.0
2014-03-07 12:00:00	QQQ	ETF	90.475	90.475	90.33	90.461	910388.0
2014-03-07 12:30:00	QQQ	ETF	90.46	90.47	90.321	90.33	461160.0
2014-03-07 13:00:00	QQQ	ETF	90.33	90.33	90.071	90.29	1240472.0

> showing 50 of 11,432 rows — these rows as CSV

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