PREVIEW / etf_30min / 2014-02-11

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-11.parquet
  size:    351 KB
  rows:    11,738

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-02-11 04:00:00	SPY	ETF	180.6	180.72	180.6	180.68	17535.0
2014-02-11 04:30:00	SPY	ETF	180.72	180.83	180.7	180.83	5458.0
2014-02-11 05:00:00	SPY	ETF	180.78	180.94	180.78	180.82	12407.0
2014-02-11 05:30:00	SPY	ETF	180.78	180.79	180.75	180.75	2868.0
2014-02-11 06:00:00	SPY	ETF	180.73	180.79	180.61	180.61	14276.0
2014-02-11 06:30:00	SPY	ETF	180.6	180.65	180.5	180.5	26500.0
2014-02-11 07:00:00	SPY	ETF	180.52	180.67	180.48	180.61	65922.0
2014-02-11 07:30:00	SPY	ETF	180.63	180.66	180.55	180.6	125754.0
2014-02-11 08:00:00	SPY	ETF	180.6	180.68	180.51	180.63	416512.0
2014-02-11 08:30:00	SPY	ETF	180.62	180.8	180.16	180.2	2503552.0
2014-02-11 09:00:00	SPY	ETF	180.18	180.32	180.03	180.16	1147092.0
2014-02-11 09:30:00	SPY	ETF	180.16	180.73	180.06	180.48	11785270.0
2014-02-11 10:00:00	SPY	ETF	180.48	180.88	180.38	180.79	7883857.0
2014-02-11 10:30:00	SPY	ETF	180.79	180.91	180.59	180.76	7748736.0
2014-02-11 11:00:00	SPY	ETF	180.76	181.36	180.74	181.36	10240510.0
2014-02-11 11:30:00	SPY	ETF	181.36	181.51	181.31	181.48	8533035.0
2014-02-11 12:00:00	SPY	ETF	181.48	181.53	181.3	181.43	5147394.0
2014-02-11 12:30:00	SPY	ETF	181.43	181.6	181.42	181.58	3596872.0
2014-02-11 13:00:00	SPY	ETF	181.58	181.97	181.58	181.905	7451384.0
2014-02-11 13:30:00	SPY	ETF	181.9	182.01	181.79	181.809	4714562.0
2014-02-11 14:00:00	SPY	ETF	181.8	181.95	181.73	181.9	5147315.0
2014-02-11 14:30:00	SPY	ETF	181.89	182.21	181.85	182.18	6882435.0
2014-02-11 15:00:00	SPY	ETF	182.18	182.439	182.16	182.2	8018134.0
2014-02-11 15:30:00	SPY	ETF	182.2	182.265	181.88	181.95	16621153.0
2014-02-11 16:00:00	SPY	ETF	181.95	182.031	180.039	181.88	6367377.0
2014-02-11 16:30:00	SPY	ETF	181.88	181.9	181.74	181.77	832751.0
2014-02-11 17:00:00	SPY	ETF	181.77	181.87	181.77	181.86	70066.0
2014-02-11 17:30:00	SPY	ETF	181.86	181.97	181.86	181.9	152312.0
2014-02-11 18:00:00	SPY	ETF	181.87	181.9	181.68	181.76	113161.0
2014-02-11 18:30:00	SPY	ETF	181.76	181.84	181.76	181.82	20320.0
2014-02-11 19:00:00	SPY	ETF	181.81	181.84	181.75	181.75	31089.0
2014-02-11 19:30:00	SPY	ETF	181.73	181.78	181.71	181.71	71479.0
2014-02-11 04:00:00	QQQ	ETF	88.02	88.13	88.02	88.11	599.0
2014-02-11 04:30:00	QQQ	ETF	88.15	88.19	88.15	88.19	3400.0
2014-02-11 05:00:00	QQQ	ETF	88.17	88.25	88.16	88.18	27600.0
2014-02-11 05:30:00	QQQ	ETF	88.18	88.18	88.18	88.18	600.0
2014-02-11 06:00:00	QQQ	ETF	88.15	88.15	88.13	88.13	400.0
2014-02-11 06:30:00	QQQ	ETF	88.11	88.13	88.06	88.06	8400.0
2014-02-11 07:00:00	QQQ	ETF	88.06	88.13	88.06	88.1	8106.0
2014-02-11 07:30:00	QQQ	ETF	88.09	88.14	88.08	88.1	10600.0
2014-02-11 08:00:00	QQQ	ETF	88.11	88.18	88.07	88.16	23375.0
2014-02-11 08:30:00	QQQ	ETF	88.12	88.2	87.96	88.02	135630.0
2014-02-11 09:00:00	QQQ	ETF	88.0	88.04	87.93	87.95	588255.0
2014-02-11 09:30:00	QQQ	ETF	87.94	88.2	87.89	88.11	3543406.0
2014-02-11 10:00:00	QQQ	ETF	88.11	88.28	88.03	88.22	3559544.0
2014-02-11 10:30:00	QQQ	ETF	88.23	88.34	88.091	88.2051	4181737.0
2014-02-11 11:00:00	QQQ	ETF	88.2	88.42	88.11	88.4102	4123268.0
2014-02-11 11:30:00	QQQ	ETF	88.42	88.45	88.315	88.439	4173878.0
2014-02-11 12:00:00	QQQ	ETF	88.44	88.46	88.35	88.401	1144841.0
2014-02-11 12:30:00	QQQ	ETF	88.41	88.55	88.41	88.5499	845133.0

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

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