PREVIEW / etf_30min / 2014-01-13

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-13.parquet
  size:    358 KB
  rows:    11,812

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-01-13 04:00:00	SPY	ETF	183.8	183.8	183.61	183.76	33615.0
2014-01-13 04:30:00	SPY	ETF	183.74	183.84	183.74	183.84	3540.0
2014-01-13 05:00:00	SPY	ETF	183.81	183.81	183.68	183.71	7938.0
2014-01-13 05:30:00	SPY	ETF	183.69	183.71	183.63	183.71	7757.0
2014-01-13 06:00:00	SPY	ETF	183.68	183.69	183.49	183.56	23527.0
2014-01-13 06:30:00	SPY	ETF	183.59	183.59	183.42	183.51	16682.0
2014-01-13 07:00:00	SPY	ETF	183.54	183.66	183.5	183.62	151112.0
2014-01-13 07:30:00	SPY	ETF	183.63	183.76	183.63	183.71	80257.0
2014-01-13 08:00:00	SPY	ETF	183.74	183.76	183.49	183.71	314902.0
2014-01-13 08:30:00	SPY	ETF	183.7	183.77	183.6	183.61	346211.0
2014-01-13 09:00:00	SPY	ETF	183.62	183.72	183.53	183.71	905058.0
2014-01-13 09:30:00	SPY	ETF	183.71	184.0	183.61	183.78	8520309.0
2014-01-13 10:00:00	SPY	ETF	183.78	184.17	183.78	184.125	7190106.0
2014-01-13 10:30:00	SPY	ETF	184.13	184.18	184.01	184.01	3040777.0
2014-01-13 11:00:00	SPY	ETF	184.01	184.02	183.79	183.8779	5038056.0
2014-01-13 11:30:00	SPY	ETF	183.88	184.01	183.82	183.92	2450598.0
2014-01-13 12:00:00	SPY	ETF	183.915	183.94	183.41	183.45	4826101.0
2014-01-13 12:30:00	SPY	ETF	183.44	183.449	182.96	182.96	9004118.0
2014-01-13 13:00:00	SPY	ETF	182.96	183.0299	182.61	182.9	8774039.0
2014-01-13 13:30:00	SPY	ETF	182.89	182.9	182.54	182.79	8806691.0
2014-01-13 14:00:00	SPY	ETF	182.78	182.82	182.32	182.411	8981287.0
2014-01-13 14:30:00	SPY	ETF	182.42	182.458	181.96	182.09	12233972.0
2014-01-13 15:00:00	SPY	ETF	182.09	182.09	181.55	181.73	19472917.0
2014-01-13 15:30:00	SPY	ETF	181.74	181.76	181.34	181.72	24298338.0
2014-01-13 16:00:00	SPY	ETF	181.71	184.0539	181.63	181.84	13139850.0
2014-01-13 16:30:00	SPY	ETF	181.85	184.0538	181.81	181.84	6651167.0
2014-01-13 17:00:00	SPY	ETF	181.85	181.93	181.8	181.83	2149205.0
2014-01-13 17:30:00	SPY	ETF	181.82	181.88	181.79	181.88	133417.0
2014-01-13 18:00:00	SPY	ETF	181.88	181.97	181.88	181.89	207959.0
2014-01-13 18:30:00	SPY	ETF	181.89	181.97	181.89	181.94	61665.0
2014-01-13 19:00:00	SPY	ETF	181.96	181.99	181.92	181.94	38425.0
2014-01-13 19:30:00	SPY	ETF	181.94	181.97	181.91	181.93	43307.0
2014-01-13 04:00:00	QQQ	ETF	87.15	87.15	87.15	87.15	400.0
2014-01-13 05:00:00	QQQ	ETF	87.17	87.17	87.17	87.17	100.0
2014-01-13 05:30:00	QQQ	ETF	87.14	87.16	87.14	87.16	300.0
2014-01-13 06:00:00	QQQ	ETF	87.12	87.12	87.12	87.12	100.0
2014-01-13 06:30:00	QQQ	ETF	87.02	87.07	87.02	87.07	4100.0
2014-01-13 07:00:00	QQQ	ETF	87.09	87.14	87.08	87.14	2900.0
2014-01-13 07:30:00	QQQ	ETF	87.21	87.21	87.21	87.21	700.0
2014-01-13 08:00:00	QQQ	ETF	87.26	87.26	87.199	87.2	6240.0
2014-01-13 08:30:00	QQQ	ETF	87.21	87.26	87.15	87.16	49960.0
2014-01-13 09:00:00	QQQ	ETF	87.17	87.2	87.08	87.17	135435.0
2014-01-13 09:30:00	QQQ	ETF	87.18	87.35	87.13	87.24	3267739.0
2014-01-13 10:00:00	QQQ	ETF	87.24	87.48	87.24	87.44	1831040.0
2014-01-13 10:30:00	QQQ	ETF	87.44	87.48	87.35	87.45	1859275.0
2014-01-13 11:00:00	QQQ	ETF	87.45	87.47	87.35	87.41	1472282.0
2014-01-13 11:30:00	QQQ	ETF	87.41	87.46	87.4	87.435	587654.0
2014-01-13 12:00:00	QQQ	ETF	87.43	87.44	87.14	87.16	2068773.0
2014-01-13 12:30:00	QQQ	ETF	87.16	87.16	86.91	86.92	2165095.0
2014-01-13 13:00:00	QQQ	ETF	86.92	86.92	86.73	86.84	2160581.0

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

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