PREVIEW / etf_30min / 2014-05-07

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-07.parquet
  size:    334 KB
  rows:    11,441

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-05-07 04:00:00	SPY	ETF	187.03	187.03	186.9	186.96	5018.0
2014-05-07 04:30:00	SPY	ETF	186.98	187.1	186.98	187.1	507.0
2014-05-07 05:00:00	SPY	ETF	187.04	187.04	187.04	187.04	350.0
2014-05-07 05:30:00	SPY	ETF	187.01	187.03	186.86	186.95	7378.0
2014-05-07 06:00:00	SPY	ETF	186.9	186.91	186.87	186.91	3390.0
2014-05-07 06:30:00	SPY	ETF	186.88	187.02	186.88	187.01	1052.0
2014-05-07 07:00:00	SPY	ETF	187.04	187.4	187.03	187.35	162345.0
2014-05-07 07:30:00	SPY	ETF	187.36	187.41	187.24	187.27	116371.0
2014-05-07 08:00:00	SPY	ETF	187.31	187.72	187.26	187.54	768874.0
2014-05-07 08:30:00	SPY	ETF	187.54	187.54	187.35	187.4	510186.0
2014-05-07 09:00:00	SPY	ETF	187.4	187.43	187.15	187.42	786361.0
2014-05-07 09:30:00	SPY	ETF	187.43	187.69	186.915	186.96	12686589.0
2014-05-07 10:00:00	SPY	ETF	186.96	187.33	186.01	186.47	17452881.0
2014-05-07 10:30:00	SPY	ETF	186.475	187.02	186.42	186.77	10088439.0
2014-05-07 11:00:00	SPY	ETF	186.77	187.01	186.57	186.82	6454015.0
2014-05-07 11:30:00	SPY	ETF	186.83	187.75	186.785	187.53	9569643.0
2014-05-07 12:00:00	SPY	ETF	187.53	187.66	187.34	187.4167	3389286.0
2014-05-07 12:30:00	SPY	ETF	187.415	187.5	187.07	187.11	3721651.0
2014-05-07 13:00:00	SPY	ETF	187.11	187.39	186.99	187.2	3781212.0
2014-05-07 13:30:00	SPY	ETF	187.21	187.48	186.92	186.94	3580594.0
2014-05-07 14:00:00	SPY	ETF	186.94	187.56	186.88	187.5	4509678.0
2014-05-07 14:30:00	SPY	ETF	187.509	187.6201	187.3	187.5	3125558.0
2014-05-07 15:00:00	SPY	ETF	187.5	187.517	187.21	187.37	4548567.0
2014-05-07 15:30:00	SPY	ETF	187.38	187.97	187.37	187.9	13411865.0
2014-05-07 16:00:00	SPY	ETF	187.9	188.13	186.5	188.0	5066517.0
2014-05-07 16:30:00	SPY	ETF	188.0	188.05	187.8884	188.05	342063.0
2014-05-07 17:00:00	SPY	ETF	188.04	188.07	187.86	187.95	1215513.0
2014-05-07 17:30:00	SPY	ETF	187.88	187.97	187.86	187.92	454253.0
2014-05-07 18:00:00	SPY	ETF	187.94	188.03	187.94	188.01	51702.0
2014-05-07 18:30:00	SPY	ETF	188.01	188.01	187.91	187.95	32920.0
2014-05-07 19:00:00	SPY	ETF	187.96	187.98	187.94	187.97	4147.0
2014-05-07 19:30:00	SPY	ETF	187.99	187.99	187.84	187.88	40940.0
2014-05-07 04:00:00	QQQ	ETF	86.71	86.74	86.71	86.74	820.0
2014-05-07 05:30:00	QQQ	ETF	86.74	86.74	86.68	86.68	5400.0
2014-05-07 06:30:00	QQQ	ETF	86.71	86.71	86.71	86.71	1000.0
2014-05-07 07:00:00	QQQ	ETF	86.8	87.05	86.8	86.97	24200.0
2014-05-07 07:30:00	QQQ	ETF	86.99	87.01	86.95	86.96	83400.0
2014-05-07 08:00:00	QQQ	ETF	86.78	87.21	86.78	87.18	393264.0
2014-05-07 08:30:00	QQQ	ETF	87.14	87.14	87.04	87.08	85188.0
2014-05-07 09:00:00	QQQ	ETF	87.08	87.08	86.89	87.02	200240.0
2014-05-07 09:30:00	QQQ	ETF	87.0	87.08	86.15	86.19	7044397.0
2014-05-07 10:00:00	QQQ	ETF	86.18	86.48	85.53	85.86	7881131.0
2014-05-07 10:30:00	QQQ	ETF	85.87	86.09	85.77	85.87	5582264.0
2014-05-07 11:00:00	QQQ	ETF	85.88	85.9	85.65	85.79	2569072.0
2014-05-07 11:30:00	QQQ	ETF	85.8	86.42	85.78	86.28	4229571.0
2014-05-07 12:00:00	QQQ	ETF	86.28	86.31	86.14	86.17	1470398.0
2014-05-07 12:30:00	QQQ	ETF	86.1734	86.2	85.84	85.86	1998532.0
2014-05-07 13:00:00	QQQ	ETF	85.85	86.0599	85.78	85.95	2086035.0
2014-05-07 13:30:00	QQQ	ETF	85.96	86.16	85.77	85.79	1856550.0
2014-05-07 14:00:00	QQQ	ETF	85.78	86.17	85.75	86.14	2164572.0

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

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