PREVIEW / etf_30min / 2014-07-17

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-17.parquet
  size:    367 KB
  rows:    12,503

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-07-17 04:00:00	SPY	ETF	197.68	197.7	197.49	197.56	6797.0
2014-07-17 04:30:00	SPY	ETF	197.54	197.54	197.5	197.5	3547.0
2014-07-17 05:00:00	SPY	ETF	197.42	197.5	197.28	197.28	5976.0
2014-07-17 05:30:00	SPY	ETF	197.38	197.38	197.23	197.25	3697.0
2014-07-17 06:00:00	SPY	ETF	197.24	197.25	197.18	197.21	13981.0
2014-07-17 06:30:00	SPY	ETF	197.21	197.21	196.75	196.82	59430.0
2014-07-17 07:00:00	SPY	ETF	196.83	196.94	196.7	196.93	270763.0
2014-07-17 07:30:00	SPY	ETF	196.93	197.14	196.86	196.96	312602.0
2014-07-17 08:00:00	SPY	ETF	196.93	197.614	196.93	197.21	508599.0
2014-07-17 08:30:00	SPY	ETF	197.21	197.96	197.08	197.18	466180.0
2014-07-17 09:00:00	SPY	ETF	197.18	197.35	197.12	197.34	591008.0
2014-07-17 09:30:00	SPY	ETF	197.35	197.9	197.3	197.84	9826145.0
2014-07-17 10:00:00	SPY	ETF	197.85	198.08	197.698	198.05	6541279.0
2014-07-17 10:30:00	SPY	ETF	198.05	198.1	197.76	197.78	3910562.0
2014-07-17 11:00:00	SPY	ETF	197.78	197.82	196.86	196.9	12572211.0
2014-07-17 11:30:00	SPY	ETF	196.905	197.24	196.68	196.86	12890227.0
2014-07-17 12:00:00	SPY	ETF	196.87	196.955	196.46	196.889	9930933.0
2014-07-17 12:30:00	SPY	ETF	196.89	197.19	196.83	197.1	4822184.0
2014-07-17 13:00:00	SPY	ETF	197.11	197.53	197.1	197.22	6009094.0
2014-07-17 13:30:00	SPY	ETF	197.22	197.35	196.84	196.97	4414397.0
2014-07-17 14:00:00	SPY	ETF	196.98	196.98	196.56	196.66	6646724.0
2014-07-17 14:30:00	SPY	ETF	196.66	196.915	196.61	196.69	5702778.0
2014-07-17 15:00:00	SPY	ETF	196.69	196.71	195.92	195.95	13670820.0
2014-07-17 15:30:00	SPY	ETF	195.955	196.08	195.43	195.72	24465514.0
2014-07-17 16:00:00	SPY	ETF	195.71	198.0539	195.68	195.9	12842743.0
2014-07-17 16:30:00	SPY	ETF	195.88	195.92	195.38	195.44	3530054.0
2014-07-17 17:00:00	SPY	ETF	195.43	195.48	195.32	195.35	968900.0
2014-07-17 17:30:00	SPY	ETF	195.35	195.41	195.31	195.4	183266.0
2014-07-17 18:00:00	SPY	ETF	195.41	195.55	194.88	195.03	446416.0
2014-07-17 18:30:00	SPY	ETF	195.01	195.18	194.81	194.86	222430.0
2014-07-17 19:00:00	SPY	ETF	194.91	195.21	194.85	195.21	156329.0
2014-07-17 19:30:00	SPY	ETF	195.21	195.39	195.15	195.38	154864.0
2014-07-17 04:00:00	QQQ	ETF	95.8	95.8	95.8	95.8	800.0
2014-07-17 04:30:00	QQQ	ETF	95.7	95.7	95.7	95.7	100.0
2014-07-17 05:30:00	QQQ	ETF	95.6	95.62	95.59	95.59	7600.0
2014-07-17 06:00:00	QQQ	ETF	95.58	95.58	95.51	95.55	9220.0
2014-07-17 06:30:00	QQQ	ETF	95.55	95.55	95.27	95.27	11500.0
2014-07-17 07:00:00	QQQ	ETF	95.29	95.34	95.19	95.3	26400.0
2014-07-17 07:30:00	QQQ	ETF	95.38	95.42	95.27	95.27	59335.0
2014-07-17 08:00:00	QQQ	ETF	95.27	95.49	95.27	95.49	144239.0
2014-07-17 08:30:00	QQQ	ETF	95.44	95.55	95.395	95.52	353081.0
2014-07-17 09:00:00	QQQ	ETF	95.53	95.64	95.51	95.63	297502.0
2014-07-17 09:30:00	QQQ	ETF	95.63	95.95	95.61	95.85	3428994.0
2014-07-17 10:00:00	QQQ	ETF	95.85	95.97	95.67	95.855	2715629.0
2014-07-17 10:30:00	QQQ	ETF	95.86	95.89	95.71	95.75	1889853.0
2014-07-17 11:00:00	QQQ	ETF	95.74	95.77	95.115	95.14	4317586.0
2014-07-17 11:30:00	QQQ	ETF	95.14	95.37	95.0	95.14	3005505.0
2014-07-17 12:00:00	QQQ	ETF	95.14	95.23	94.9	95.16	3152797.0
2014-07-17 12:30:00	QQQ	ETF	95.165	95.29	95.12	95.23	1583372.0
2014-07-17 13:00:00	QQQ	ETF	95.23	95.47	95.22	95.36	1655413.0

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

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