PREVIEW / etf_30min / 2013-01-31

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-31.parquet
  size:    308 KB
  rows:    10,501

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
2013-01-31 04:00:00	SPY	ETF	149.8	149.8	149.75	149.76	401.0
2013-01-31 04:30:00	SPY	ETF	149.89	149.89	149.84	149.84	1000.0
2013-01-31 05:00:00	SPY	ETF	149.86	149.98	149.85	149.85	33900.0
2013-01-31 05:30:00	SPY	ETF	149.82	149.82	149.75	149.75	800.0
2013-01-31 06:00:00	SPY	ETF	149.76	149.76	149.68	149.72	32279.0
2013-01-31 06:30:00	SPY	ETF	149.6	149.78	149.6	149.78	17728.0
2013-01-31 07:00:00	SPY	ETF	149.74	149.84	149.73	149.82	108041.0
2013-01-31 07:30:00	SPY	ETF	149.85	149.96	149.84	149.87	438480.0
2013-01-31 08:00:00	SPY	ETF	149.86	149.93	149.6	149.65	1467269.0
2013-01-31 08:30:00	SPY	ETF	149.58	150.01	149.54	149.87	1585599.0
2013-01-31 09:00:00	SPY	ETF	149.87	149.98	149.85	149.89	1999961.0
2013-01-31 09:30:00	SPY	ETF	149.89	150.38	149.71	150.25	17752871.0
2013-01-31 10:00:00	SPY	ETF	150.25	150.27	149.94	149.97	8230233.0
2013-01-31 10:30:00	SPY	ETF	149.96	150.19	149.89	149.89	8083068.0
2013-01-31 11:00:00	SPY	ETF	149.9	149.93	149.7	149.78	7206267.0
2013-01-31 11:30:00	SPY	ETF	149.77	149.87	149.6	149.69	6741926.0
2013-01-31 12:00:00	SPY	ETF	149.69	149.94	149.69	149.84	3838051.0
2013-01-31 12:30:00	SPY	ETF	149.83	150.06	149.79	150.03	6134715.0
2013-01-31 13:00:00	SPY	ETF	150.03	150.05	149.9	149.93	2744398.0
2013-01-31 13:30:00	SPY	ETF	149.94	150.12	149.93	150.075	2720195.0
2013-01-31 14:00:00	SPY	ETF	150.08	150.085	149.93	150.0501	2986300.0
2013-01-31 14:30:00	SPY	ETF	150.06	150.22	150.04	150.105	3640142.0
2013-01-31 15:00:00	SPY	ETF	150.1	150.16	149.8	149.86	6798957.0
2013-01-31 15:30:00	SPY	ETF	149.86	150.03	149.71	149.81	16772801.0
2013-01-31 16:00:00	SPY	ETF	149.83	150.1441	149.7	149.92	6053631.0
2013-01-31 16:30:00	SPY	ETF	149.93	150.1442	149.89	149.97	1555421.0
2013-01-31 17:00:00	SPY	ETF	149.96	150.01	149.91	149.91	187550.0
2013-01-31 17:30:00	SPY	ETF	149.91	149.94	149.89	149.93	87009.0
2013-01-31 18:00:00	SPY	ETF	149.94	150.14	149.94	150.11	278710.0
2013-01-31 18:30:00	SPY	ETF	150.09	150.15	150.05	150.12	121598.0
2013-01-31 19:00:00	SPY	ETF	150.12	150.19	150.09	150.18	54422.0
2013-01-31 19:30:00	SPY	ETF	150.17	150.18	150.14	150.15	46880.0
2013-01-31 04:30:00	QQQ	ETF	66.94	66.94	66.94	66.94	202.0
2013-01-31 05:00:00	QQQ	ETF	66.99	66.99	66.95	66.95	12000.0
2013-01-31 05:30:00	QQQ	ETF	66.93	66.93	66.93	66.93	1600.0
2013-01-31 06:30:00	QQQ	ETF	66.84	66.92	66.84	66.89	32900.0
2013-01-31 07:00:00	QQQ	ETF	66.89	66.93	66.88	66.93	7800.0
2013-01-31 07:30:00	QQQ	ETF	66.96	66.96	66.93	66.93	1407.0
2013-01-31 08:00:00	QQQ	ETF	66.89	66.93	66.85	66.85	521653.0
2013-01-31 08:30:00	QQQ	ETF	66.84	66.92	66.83	66.89	743391.0
2013-01-31 09:00:00	QQQ	ETF	66.92	67.03	66.91	67.0	639202.0
2013-01-31 09:30:00	QQQ	ETF	66.99	67.35	66.94	67.3	4782441.0
2013-01-31 10:00:00	QQQ	ETF	67.29	67.315	67.09	67.11	2089560.0
2013-01-31 10:30:00	QQQ	ETF	67.11	67.26	67.01	67.01	1617231.0
2013-01-31 11:00:00	QQQ	ETF	67.02	67.03	66.88	66.91	2592949.0
2013-01-31 11:30:00	QQQ	ETF	66.9	66.95	66.81	66.89	1586313.0
2013-01-31 12:00:00	QQQ	ETF	66.89	66.98	66.89	66.905	683517.0
2013-01-31 12:30:00	QQQ	ETF	66.91	67.05	66.8715	67.02	2298120.0
2013-01-31 13:00:00	QQQ	ETF	67.03	67.0399	66.93	66.95	457143.0
2013-01-31 13:30:00	QQQ	ETF	66.95	67.019	66.94	67.0	391339.0

> showing 50 of 10,501 rows — these rows as CSV

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