PREVIEW / etf_30min / 2014-12-04

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-04.parquet
  size:    360 KB
  rows:    12,164

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-04 04:00:00	SPY	ETF	207.86	207.94	207.86	207.94	602.0
2014-12-04 04:30:00	SPY	ETF	207.88	207.88	207.84	207.88	2600.0
2014-12-04 05:00:00	SPY	ETF	207.85	207.95	207.85	207.93	900.0
2014-12-04 05:30:00	SPY	ETF	207.98	208.08	207.98	208.03	14116.0
2014-12-04 06:00:00	SPY	ETF	208.01	208.03	207.98	208.01	71841.0
2014-12-04 06:30:00	SPY	ETF	208.01	208.01	207.95	207.98	32104.0
2014-12-04 07:00:00	SPY	ETF	207.98	208.05	207.98	208.0	42280.0
2014-12-04 07:30:00	SPY	ETF	207.98	208.01	207.95	208.0	120382.0
2014-12-04 08:00:00	SPY	ETF	207.89	208.05	207.83	207.97	194702.0
2014-12-04 08:30:00	SPY	ETF	207.96	208.15	207.03	207.24	2079912.0
2014-12-04 09:00:00	SPY	ETF	207.22	207.67	207.2	207.54	1367887.0
2014-12-04 09:30:00	SPY	ETF	207.54	207.77	207.35	207.47	8362970.0
2014-12-04 10:00:00	SPY	ETF	207.47	207.6465	207.27	207.295	5139828.0
2014-12-04 10:30:00	SPY	ETF	207.29	207.29	206.7	206.97	7958902.0
2014-12-04 11:00:00	SPY	ETF	206.96	207.06	206.83	206.85	4453287.0
2014-12-04 11:30:00	SPY	ETF	206.86	207.41	206.74	207.401	5430379.0
2014-12-04 12:00:00	SPY	ETF	207.4	207.65	207.36	207.625	3986815.0
2014-12-04 12:30:00	SPY	ETF	207.62	208.265	207.61	207.84	16302992.0
2014-12-04 13:00:00	SPY	ETF	207.84	207.98	207.78	207.94	2733417.0
2014-12-04 13:30:00	SPY	ETF	207.94	208.0	207.78	207.903	3756431.0
2014-12-04 14:00:00	SPY	ETF	207.89	207.97	207.82	207.84	2418243.0
2014-12-04 14:30:00	SPY	ETF	207.84	207.85	207.56	207.62	3763053.0
2014-12-04 15:00:00	SPY	ETF	207.6299	207.75	207.12	207.22	5122028.0
2014-12-04 15:30:00	SPY	ETF	207.22	207.67	207.12	207.66	9847608.0
2014-12-04 16:00:00	SPY	ETF	207.67	207.85	207.52	207.75	5378533.0
2014-12-04 16:30:00	SPY	ETF	207.76	207.84	207.72	207.73	1254610.0
2014-12-04 17:00:00	SPY	ETF	207.74	207.77	207.72	207.73	59615.0
2014-12-04 17:30:00	SPY	ETF	207.73	207.73	207.73	207.73	2425.0
2014-12-04 18:00:00	SPY	ETF	207.73	207.78	207.72	207.75	14041.0
2014-12-04 18:30:00	SPY	ETF	207.75	207.79	207.73	207.73	10005.0
2014-12-04 19:00:00	SPY	ETF	207.75	207.77	207.71	207.77	30274.0
2014-12-04 19:30:00	SPY	ETF	207.77	207.78	207.73	207.77	36563.0
2014-12-04 05:30:00	QQQ	ETF	105.5	105.53	105.5	105.53	1600.0
2014-12-04 06:00:00	QQQ	ETF	105.51	105.51	105.51	105.51	5000.0
2014-12-04 07:00:00	QQQ	ETF	105.5	105.52	105.5	105.5	9500.0
2014-12-04 07:30:00	QQQ	ETF	105.5	105.52	105.49	105.49	18174.0
2014-12-04 08:00:00	QQQ	ETF	105.5	105.51	105.41	105.47	40508.0
2014-12-04 08:30:00	QQQ	ETF	105.49	105.59	104.97	105.14	436326.0
2014-12-04 09:00:00	QQQ	ETF	105.13	105.43	105.12	105.3	228339.0
2014-12-04 09:30:00	QQQ	ETF	105.32	105.63	105.19	105.52	3896130.0
2014-12-04 10:00:00	QQQ	ETF	105.52	105.64	105.46	105.52	2467421.0
2014-12-04 10:30:00	QQQ	ETF	105.51	105.51	105.1	105.29	2660147.0
2014-12-04 11:00:00	QQQ	ETF	105.28	105.31	105.02	105.04	1477611.0
2014-12-04 11:30:00	QQQ	ETF	105.06	105.41	104.93	105.4	1525717.0
2014-12-04 12:00:00	QQQ	ETF	105.4	105.58	105.35	105.5532	1479899.0
2014-12-04 12:30:00	QQQ	ETF	105.559	105.78	105.52	105.59	2536240.0
2014-12-04 13:00:00	QQQ	ETF	105.59	105.65	105.52	105.59	963586.0
2014-12-04 13:30:00	QQQ	ETF	105.59	105.62	105.5	105.56	805836.0
2014-12-04 14:00:00	QQQ	ETF	105.57	105.64	105.54	105.575	915721.0
2014-12-04 14:30:00	QQQ	ETF	105.58	105.59	105.4	105.46	1288612.0

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

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