PREVIEW / etf_30min / 2014-06-30

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-30.parquet
  size:    331 KB
  rows:    11,538

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-06-30 04:00:00	SPY	ETF	195.7	195.73	195.7	195.73	1750.0
2014-06-30 04:30:00	SPY	ETF	195.62	195.62	195.6	195.6	287.0
2014-06-30 05:00:00	SPY	ETF	195.63	195.63	195.63	195.63	2500.0
2014-06-30 05:30:00	SPY	ETF	195.64	195.67	195.64	195.65	2096.0
2014-06-30 06:00:00	SPY	ETF	195.72	195.88	195.55	195.57	5574.0
2014-06-30 06:30:00	SPY	ETF	195.62	195.62	195.51	195.51	11507.0
2014-06-30 07:00:00	SPY	ETF	195.47	195.49	195.26	195.49	174487.0
2014-06-30 07:30:00	SPY	ETF	195.49	195.6	195.47	195.49	97350.0
2014-06-30 08:00:00	SPY	ETF	195.51	195.855	195.51	195.72	245014.0
2014-06-30 08:30:00	SPY	ETF	195.72	195.72	195.62	195.63	120188.0
2014-06-30 09:00:00	SPY	ETF	195.62	195.76	195.62	195.7	299311.0
2014-06-30 09:30:00	SPY	ETF	195.7	195.83	195.55	195.78	7309826.0
2014-06-30 10:00:00	SPY	ETF	195.78	196.165	195.78	196.05	6386904.0
2014-06-30 10:30:00	SPY	ETF	196.05	196.11	195.69	195.73	4522030.0
2014-06-30 11:00:00	SPY	ETF	195.73	196.06	195.61	196.02	4200377.0
2014-06-30 11:30:00	SPY	ETF	196.01	196.031	195.77	195.845	4032398.0
2014-06-30 12:00:00	SPY	ETF	195.84	195.91	195.775	195.9	2060701.0
2014-06-30 12:30:00	SPY	ETF	195.895	195.95	195.815	195.87	2212085.0
2014-06-30 13:00:00	SPY	ETF	195.865	195.985	195.855	195.95	1566450.0
2014-06-30 13:30:00	SPY	ETF	195.945	195.99	195.89	195.925	1808398.0
2014-06-30 14:00:00	SPY	ETF	195.93	196.1	195.92	196.06	2766900.0
2014-06-30 14:30:00	SPY	ETF	196.065	196.09	195.75	195.77	3634731.0
2014-06-30 15:00:00	SPY	ETF	195.77	195.9	195.7	195.87	4868952.0
2014-06-30 15:30:00	SPY	ETF	195.865	195.9	195.53	195.71	14724507.0
2014-06-30 16:00:00	SPY	ETF	195.7	195.95	195.69	195.92	7738512.0
2014-06-30 16:30:00	SPY	ETF	195.91	195.97	195.72	195.92	279202.0
2014-06-30 17:00:00	SPY	ETF	195.92	195.96	195.9	195.92	164464.0
2014-06-30 17:30:00	SPY	ETF	195.93	195.94	195.72	195.9	207713.0
2014-06-30 18:00:00	SPY	ETF	195.92	195.98	195.88	195.89	63021.0
2014-06-30 18:30:00	SPY	ETF	195.9	195.9	195.87	195.87	13650.0
2014-06-30 19:00:00	SPY	ETF	195.89	195.98	195.89	195.94	11000.0
2014-06-30 19:30:00	SPY	ETF	195.94	195.97	195.92	195.97	19090.0
2014-06-30 06:30:00	QQQ	ETF	93.66	93.66	93.6	93.63	2200.0
2014-06-30 07:00:00	QQQ	ETF	93.62	93.63	93.56	93.56	5300.0
2014-06-30 07:30:00	QQQ	ETF	93.64	93.64	93.64	93.64	100.0
2014-06-30 08:00:00	QQQ	ETF	93.67	93.74	93.67	93.73	83759.0
2014-06-30 08:30:00	QQQ	ETF	93.71	93.72	93.69	93.7	29700.0
2014-06-30 09:00:00	QQQ	ETF	93.7	93.73	93.68	93.7	59078.0
2014-06-30 09:30:00	QQQ	ETF	93.71	93.93	93.67	93.86	3803083.0
2014-06-30 10:00:00	QQQ	ETF	93.87	94.0	93.86	93.94	2154052.0
2014-06-30 10:30:00	QQQ	ETF	93.94	94.0	93.83	93.84	1478642.0
2014-06-30 11:00:00	QQQ	ETF	93.84	94.03	93.79	94.01	1425403.0
2014-06-30 11:30:00	QQQ	ETF	94.01	94.025	93.92	93.94	868533.0
2014-06-30 12:00:00	QQQ	ETF	93.94	94.005	93.91	94.0	473303.0
2014-06-30 12:30:00	QQQ	ETF	94.0	94.04	93.97	93.995	495488.0
2014-06-30 13:00:00	QQQ	ETF	93.99	94.07	93.98	94.06	732792.0
2014-06-30 13:30:00	QQQ	ETF	94.07	94.1	94.04	94.06	594518.0
2014-06-30 14:00:00	QQQ	ETF	94.06	94.14	94.05	94.12	463595.0
2014-06-30 14:30:00	QQQ	ETF	94.12	94.14	93.93	93.935	894983.0
2014-06-30 15:00:00	QQQ	ETF	93.94	94.01	93.91	94.01	990684.0

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

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