PREVIEW / etf_30min / 2014-12-23

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-23.parquet
  size:    376 KB
  rows:    12,761

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-12-23 04:00:00	SPY	ETF	207.18	207.22	207.13	207.19	21881.0
2014-12-23 04:30:00	SPY	ETF	207.2	207.25	207.1	207.25	3360.0
2014-12-23 05:00:00	SPY	ETF	207.2	207.2	207.15	207.15	4600.0
2014-12-23 05:30:00	SPY	ETF	207.22	207.27	207.22	207.27	499.0
2014-12-23 06:00:00	SPY	ETF	207.34	207.36	207.34	207.36	600.0
2014-12-23 06:30:00	SPY	ETF	207.4	207.4	207.34	207.34	600.0
2014-12-23 07:00:00	SPY	ETF	207.42	207.43	207.41	207.41	3800.0
2014-12-23 07:30:00	SPY	ETF	207.47	207.62	207.38	207.56	46219.0
2014-12-23 08:00:00	SPY	ETF	207.57	207.6	207.53	207.56	162146.0
2014-12-23 08:30:00	SPY	ETF	207.54	208.18	207.5	208.18	844043.0
2014-12-23 09:00:00	SPY	ETF	208.17	208.38	208.16	208.17	883615.0
2014-12-23 09:30:00	SPY	ETF	208.17	208.21	207.785	207.9	10809788.0
2014-12-23 10:00:00	SPY	ETF	207.91	208.15	207.66	207.9	15299680.0
2014-12-23 10:30:00	SPY	ETF	207.89	207.9	207.51	207.86	7927030.0
2014-12-23 11:00:00	SPY	ETF	207.86	207.98	207.77	207.9	6589603.0
2014-12-23 11:30:00	SPY	ETF	207.89	208.0	207.82	207.83	6840033.0
2014-12-23 12:00:00	SPY	ETF	207.82	207.99	207.765	207.86	4186129.0
2014-12-23 12:30:00	SPY	ETF	207.855	208.02	207.76	207.98	4414999.0
2014-12-23 13:00:00	SPY	ETF	207.985	208.115	207.91	208.03	3856882.0
2014-12-23 13:30:00	SPY	ETF	208.03	208.11	207.96	208.01	4859725.0
2014-12-23 14:00:00	SPY	ETF	208.02	208.11	207.92	208.08	4270476.0
2014-12-23 14:30:00	SPY	ETF	208.08	208.23	208.05	208.08	6797373.0
2014-12-23 15:00:00	SPY	ETF	208.08	208.17	207.85	207.92	5909105.0
2014-12-23 15:30:00	SPY	ETF	207.92	208.01	207.71	207.75	18503658.0
2014-12-23 16:00:00	SPY	ETF	207.75	207.991	207.67	207.98	5942457.0
2014-12-23 16:30:00	SPY	ETF	207.97	208.0	207.75	207.96	6123213.0
2014-12-23 17:00:00	SPY	ETF	207.96	207.96	207.7623	207.91	1370041.0
2014-12-23 17:30:00	SPY	ETF	207.89	207.96	207.88	207.92	92105.0
2014-12-23 18:00:00	SPY	ETF	207.92	207.93	207.83	207.93	92600.0
2014-12-23 18:30:00	SPY	ETF	207.94	207.94	207.75	207.94	1360832.0
2014-12-23 19:00:00	SPY	ETF	207.93	207.98	207.91	207.95	16021.0
2014-12-23 19:30:00	SPY	ETF	207.98	207.99	207.91	207.92	114365.0
2014-12-23 07:30:00	QQQ	ETF	104.62	104.71	104.62	104.71	6200.0
2014-12-23 08:00:00	QQQ	ETF	104.64	104.71	104.62	104.65	8900.0
2014-12-23 08:30:00	QQQ	ETF	104.71	104.86	104.67	104.83	241540.0
2014-12-23 09:00:00	QQQ	ETF	104.84	105.01	104.58	104.96	318137.0
2014-12-23 09:30:00	QQQ	ETF	104.96	104.97	104.33	104.48	3644038.0
2014-12-23 10:00:00	QQQ	ETF	104.48	104.58	104.25	104.37	2218794.0
2014-12-23 10:30:00	QQQ	ETF	104.36	104.365	104.09	104.31	2164510.0
2014-12-23 11:00:00	QQQ	ETF	104.3	104.5	104.26	104.445	2754578.0
2014-12-23 11:30:00	QQQ	ETF	104.45	104.51	104.37	104.41	1039461.0
2014-12-23 12:00:00	QQQ	ETF	104.415	104.44	104.27	104.289	1107631.0
2014-12-23 12:30:00	QQQ	ETF	104.289	104.35	104.2	104.28	968104.0
2014-12-23 13:00:00	QQQ	ETF	104.28	104.42	104.23	104.39	901569.0
2014-12-23 13:30:00	QQQ	ETF	104.39	104.51	104.37	104.45	1138277.0
2014-12-23 14:00:00	QQQ	ETF	104.45	104.47	104.38	104.415	1074430.0
2014-12-23 14:30:00	QQQ	ETF	104.42	104.51	104.39	104.3961	1356013.0
2014-12-23 15:00:00	QQQ	ETF	104.395	104.48	104.303	104.33	982229.0
2014-12-23 15:30:00	QQQ	ETF	104.33	104.4	104.2	104.22	2690902.0
2014-12-23 16:00:00	QQQ	ETF	104.21	104.569	104.15	104.25	1420408.0

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

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