PREVIEW / etf_30min / 2014-04-30

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-30.parquet
  size:    330 KB
  rows:    11,281

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-30 04:00:00	SPY	ETF	187.35	187.35	187.27	187.29	519.0
2014-04-30 04:30:00	SPY	ETF	187.33	187.38	187.33	187.38	1100.0
2014-04-30 05:00:00	SPY	ETF	187.41	187.41	187.29	187.38	9416.0
2014-04-30 05:30:00	SPY	ETF	187.35	187.54	187.35	187.5	1919.0
2014-04-30 06:00:00	SPY	ETF	187.49	187.5	187.45	187.5	3091.0
2014-04-30 06:30:00	SPY	ETF	187.44	187.52	187.44	187.51	2109.0
2014-04-30 07:00:00	SPY	ETF	187.45	187.6	187.45	187.6	17537.0
2014-04-30 07:30:00	SPY	ETF	187.62	187.66	187.55	187.59	126529.0
2014-04-30 08:00:00	SPY	ETF	187.56	187.89	187.54	187.83	865054.0
2014-04-30 08:30:00	SPY	ETF	187.83	187.83	187.38	187.59	1106147.0
2014-04-30 09:00:00	SPY	ETF	187.55	187.61	187.34	187.46	542835.0
2014-04-30 09:30:00	SPY	ETF	187.44	187.71	187.22	187.39	14921611.0
2014-04-30 10:00:00	SPY	ETF	187.39	187.83	187.18	187.77	7592190.0
2014-04-30 10:30:00	SPY	ETF	187.77	188.1	187.72	187.9	6162068.0
2014-04-30 11:00:00	SPY	ETF	187.9	187.95	187.58	187.73	4958297.0
2014-04-30 11:30:00	SPY	ETF	187.72	187.88	187.71	187.81	2709071.0
2014-04-30 12:00:00	SPY	ETF	187.81	187.98	187.8	187.91	2222116.0
2014-04-30 12:30:00	SPY	ETF	187.91	188.03	187.85	188.01	1658393.0
2014-04-30 13:00:00	SPY	ETF	188.01	188.1	187.9	188.025	2317912.0
2014-04-30 13:30:00	SPY	ETF	188.015	188.05	187.875	187.9	2300746.0
2014-04-30 14:00:00	SPY	ETF	187.91	188.3	187.63	188.06	12112725.0
2014-04-30 14:30:00	SPY	ETF	188.06	188.5	188.01	188.32	8407382.0
2014-04-30 15:00:00	SPY	ETF	188.32	188.4	187.85	188.24	8587530.0
2014-04-30 15:30:00	SPY	ETF	188.24	188.45	188.03	188.39	12537347.0
2014-04-30 16:00:00	SPY	ETF	188.39	188.58	187.4596	188.45	8021411.0
2014-04-30 16:30:00	SPY	ETF	188.44	188.51	188.38	188.49	371265.0
2014-04-30 17:00:00	SPY	ETF	188.49	188.6	188.31	188.6	304214.0
2014-04-30 17:30:00	SPY	ETF	188.57	188.6	188.5	188.5	68071.0
2014-04-30 18:00:00	SPY	ETF	188.5	188.55	188.38	188.54	168769.0
2014-04-30 18:30:00	SPY	ETF	188.52	188.53	188.45	188.51	11050.0
2014-04-30 19:00:00	SPY	ETF	188.49	188.53	188.44	188.46	5200.0
2014-04-30 19:30:00	SPY	ETF	188.45	188.52	188.44	188.52	14810.0
2014-04-30 04:00:00	QQQ	ETF	86.75	86.75	86.75	86.75	100.0
2014-04-30 05:00:00	QQQ	ETF	86.79	86.79	86.79	86.79	3000.0
2014-04-30 05:30:00	QQQ	ETF	86.78	86.88	86.78	86.88	2200.0
2014-04-30 07:00:00	QQQ	ETF	86.85	86.95	86.85	86.95	5900.0
2014-04-30 07:30:00	QQQ	ETF	86.95	86.97	86.92	86.94	31600.0
2014-04-30 08:00:00	QQQ	ETF	86.91	87.06	86.9	87.03	144089.0
2014-04-30 08:30:00	QQQ	ETF	87.01	87.01	86.79	86.94	218418.0
2014-04-30 09:00:00	QQQ	ETF	86.92	86.93	86.75	86.8	280824.0
2014-04-30 09:30:00	QQQ	ETF	86.79	87.02	86.54	86.73	7792174.0
2014-04-30 10:00:00	QQQ	ETF	86.72	87.165	86.54	87.08	3633035.0
2014-04-30 10:30:00	QQQ	ETF	87.08	87.29	87.04	87.1699	2461720.0
2014-04-30 11:00:00	QQQ	ETF	87.16	87.225	86.95	87.13	2264692.0
2014-04-30 11:30:00	QQQ	ETF	87.12	87.16	87.02	87.07	1093001.0
2014-04-30 12:00:00	QQQ	ETF	87.07	87.215	87.0525	87.135	661400.0
2014-04-30 12:30:00	QQQ	ETF	87.14	87.22	87.09	87.21	790163.0
2014-04-30 13:00:00	QQQ	ETF	87.21	87.29	87.19	87.245	768786.0
2014-04-30 13:30:00	QQQ	ETF	87.25	87.25	87.11	87.14	978073.0
2014-04-30 14:00:00	QQQ	ETF	87.14	87.45	87.0	87.19	4895627.0

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

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