PREVIEW / etf_30min / 2014-04-17

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-17.parquet
  size:    333 KB
  rows:    11,278

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-04-17 04:00:00	SPY	ETF	185.4	185.54	183.68	185.54	271450.0
2014-04-17 04:30:00	SPY	ETF	185.5	185.5	185.44	185.44	940.0
2014-04-17 05:00:00	SPY	ETF	185.44	185.46	185.43	185.46	2380.0
2014-04-17 05:30:00	SPY	ETF	185.4	185.45	185.25	185.4	2506.0
2014-04-17 06:00:00	SPY	ETF	185.36	185.38	185.17	185.28	61889.0
2014-04-17 06:30:00	SPY	ETF	185.32	185.5	185.32	185.4	61614.0
2014-04-17 07:00:00	SPY	ETF	185.45	185.61	185.45	185.56	77883.0
2014-04-17 07:30:00	SPY	ETF	185.6	185.85	185.6	185.83	316719.0
2014-04-17 08:00:00	SPY	ETF	185.76	186.11	185.45	186.09	475179.0
2014-04-17 08:30:00	SPY	ETF	186.09	186.23	186.06	186.12	511647.0
2014-04-17 09:00:00	SPY	ETF	186.12	186.15	185.84	185.88	1361333.0
2014-04-17 09:30:00	SPY	ETF	185.88	186.18	185.56	185.82	12032704.0
2014-04-17 10:00:00	SPY	ETF	185.82	186.23	185.65	186.23	9985167.0
2014-04-17 10:30:00	SPY	ETF	186.23	186.4199	186.09	186.3	6985238.0
2014-04-17 11:00:00	SPY	ETF	186.31	186.45	186.11	186.32	4686829.0
2014-04-17 11:30:00	SPY	ETF	186.33	186.36	185.96	186.13	6805692.0
2014-04-17 12:00:00	SPY	ETF	186.13	186.34	185.995	186.2	3885507.0
2014-04-17 12:30:00	SPY	ETF	186.21	186.41	186.05	186.37	5111980.0
2014-04-17 13:00:00	SPY	ETF	186.38	186.68	186.34	186.58	4222345.0
2014-04-17 13:30:00	SPY	ETF	186.58	186.86	186.57	186.76	4642061.0
2014-04-17 14:00:00	SPY	ETF	186.75	186.83	186.64	186.77	5153553.0
2014-04-17 14:30:00	SPY	ETF	186.77	186.81	186.53	186.61	4621231.0
2014-04-17 15:00:00	SPY	ETF	186.615	186.91	186.58	186.765	6297764.0
2014-04-17 15:30:00	SPY	ETF	186.765	186.765	186.36	186.39	14678555.0
2014-04-17 16:00:00	SPY	ETF	186.38	186.82	185.9	186.45	9512122.0
2014-04-17 16:30:00	SPY	ETF	186.45	186.49	186.39	186.46	333877.0
2014-04-17 17:00:00	SPY	ETF	186.46	186.46	186.25	186.38	2347069.0
2014-04-17 17:30:00	SPY	ETF	186.38	186.38	186.3	186.37	70523.0
2014-04-17 18:00:00	SPY	ETF	186.37	186.39	186.37	186.39	11895.0
2014-04-17 18:30:00	SPY	ETF	186.38	186.43	186.33	186.41	16949.0
2014-04-17 19:00:00	SPY	ETF	186.41	186.41	186.35	186.37	10457.0
2014-04-17 19:30:00	SPY	ETF	186.37	186.41	186.37	186.38	23071.0
2014-04-17 04:00:00	QQQ	ETF	85.61	85.61	85.54	85.55	5656.0
2014-04-17 04:30:00	QQQ	ETF	85.58	85.58	85.56	85.56	840.0
2014-04-17 05:00:00	QQQ	ETF	85.54	85.57	85.52	85.57	1400.0
2014-04-17 06:00:00	QQQ	ETF	85.52	85.52	85.44	85.45	25383.0
2014-04-17 06:30:00	QQQ	ETF	85.51	85.52	85.47	85.49	1000.0
2014-04-17 07:00:00	QQQ	ETF	85.5	85.61	85.5	85.6	7800.0
2014-04-17 07:30:00	QQQ	ETF	85.6	85.82	85.6	85.79	64050.0
2014-04-17 08:00:00	QQQ	ETF	85.59	85.94	85.59	85.87	127688.0
2014-04-17 08:30:00	QQQ	ETF	85.87	85.99	85.87	85.89	243404.0
2014-04-17 09:00:00	QQQ	ETF	85.91	85.95	85.77	85.88	455538.0
2014-04-17 09:30:00	QQQ	ETF	85.89	86.24	85.63	85.93	7787224.0
2014-04-17 10:00:00	QQQ	ETF	85.95	86.39	85.84	86.39	4866490.0
2014-04-17 10:30:00	QQQ	ETF	86.3899	86.4	86.04	86.21	4455902.0
2014-04-17 11:00:00	QQQ	ETF	86.22	86.32	86.1	86.27	2346747.0
2014-04-17 11:30:00	QQQ	ETF	86.28	86.32	85.91	86.1	2506264.0
2014-04-17 12:00:00	QQQ	ETF	86.1	86.2374	86.0	86.12	2124698.0
2014-04-17 12:30:00	QQQ	ETF	86.12	86.31	86.0	86.27	1394341.0
2014-04-17 13:00:00	QQQ	ETF	86.27	86.46	86.25	86.43	1443654.0

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

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