PREVIEW / etf_30min / 2012-09-17

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-17.parquet
  size:    293 KB
  rows:    9,891

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
2012-09-17 04:00:00	SPY	ETF	147.07	147.07	146.93	146.93	7800.0
2012-09-17 04:30:00	SPY	ETF	146.96	147.01	146.93	147.01	4300.0
2012-09-17 05:00:00	SPY	ETF	147.01	147.01	146.88	146.88	23075.0
2012-09-17 05:30:00	SPY	ETF	146.85	147.02	146.85	146.97	1700.0
2012-09-17 06:00:00	SPY	ETF	146.94	146.94	146.94	146.94	4400.0
2012-09-17 06:30:00	SPY	ETF	146.98	147.0	146.95	146.95	7200.0
2012-09-17 07:00:00	SPY	ETF	146.99	147.01	146.82	146.82	83073.0
2012-09-17 07:30:00	SPY	ETF	146.85	146.85	146.76	146.76	159045.0
2012-09-17 08:00:00	SPY	ETF	146.78	146.9	146.74	146.82	275323.0
2012-09-17 08:30:00	SPY	ETF	146.8	147.07	146.73	147.0	545649.0
2012-09-17 09:00:00	SPY	ETF	147.0	147.05	146.9	146.93	613025.0
2012-09-17 09:30:00	SPY	ETF	146.94	147.19	146.79	146.9	12733656.0
2012-09-17 10:00:00	SPY	ETF	146.9	147.08	146.81	147.0705	6676034.0
2012-09-17 10:30:00	SPY	ETF	147.07	147.14	146.85	146.9701	9994010.0
2012-09-17 11:00:00	SPY	ETF	146.97	147.08	146.88	146.91	9604707.0
2012-09-17 11:30:00	SPY	ETF	146.91	147.04	146.88	146.93	4070174.0
2012-09-17 12:00:00	SPY	ETF	146.92	146.99	146.88	146.96	3482917.0
2012-09-17 12:30:00	SPY	ETF	146.96	146.98	146.88	146.885	3037216.0
2012-09-17 13:00:00	SPY	ETF	146.89	146.96	146.83	146.8715	4313431.0
2012-09-17 13:30:00	SPY	ETF	146.8701	146.89	146.72	146.7818	4074915.0
2012-09-17 14:00:00	SPY	ETF	146.7804	146.83	146.53	146.66	8088339.0
2012-09-17 14:30:00	SPY	ETF	146.67	146.95	146.51	146.61	6399908.0
2012-09-17 15:00:00	SPY	ETF	146.61	146.67	146.39	146.43	6376259.0
2012-09-17 15:30:00	SPY	ETF	146.42	146.78	146.37	146.77	14319938.0
2012-09-17 16:00:00	SPY	ETF	146.78	146.8	146.67	146.7	6431153.0
2012-09-17 16:30:00	SPY	ETF	146.69	146.74	146.64	146.69	6929652.0
2012-09-17 17:00:00	SPY	ETF	146.69	146.75	146.69	146.73	81631.0
2012-09-17 17:30:00	SPY	ETF	146.71	146.73	146.71	146.72	6650.0
2012-09-17 18:00:00	SPY	ETF	146.73	146.75	146.69	146.75	7450.0
2012-09-17 18:30:00	SPY	ETF	146.75	146.76	146.74	146.74	14228.0
2012-09-17 19:00:00	SPY	ETF	146.74	146.77	146.74	146.75	3477.0
2012-09-17 19:30:00	SPY	ETF	146.75	146.77	146.71	146.73	15819.0
2012-09-17 04:00:00	QQQ	ETF	70.12	70.12	70.12	70.12	1000.0
2012-09-17 05:30:00	QQQ	ETF	70.06	70.06	70.06	70.06	1000.0
2012-09-17 07:00:00	QQQ	ETF	70.12	70.13	70.11	70.11	26100.0
2012-09-17 07:30:00	QQQ	ETF	70.09	70.09	70.06	70.07	23174.0
2012-09-17 08:00:00	QQQ	ETF	70.09	70.12	70.07	70.12	23205.0
2012-09-17 08:30:00	QQQ	ETF	70.09	70.23	70.09	70.19	79556.0
2012-09-17 09:00:00	QQQ	ETF	70.2	70.25	70.18	70.2	322496.0
2012-09-17 09:30:00	QQQ	ETF	70.2	70.24	69.97	69.99	4200200.0
2012-09-17 10:00:00	QQQ	ETF	70.0	70.2	69.99	70.16	1978326.0
2012-09-17 10:30:00	QQQ	ETF	70.17	70.193	70.04	70.11	2337821.0
2012-09-17 11:00:00	QQQ	ETF	70.12	70.16	70.03	70.04	1566488.0
2012-09-17 11:30:00	QQQ	ETF	70.05	70.14	70.05	70.11	1034241.0
2012-09-17 12:00:00	QQQ	ETF	70.1	70.16	70.08	70.12	760622.0
2012-09-17 12:30:00	QQQ	ETF	70.12	70.14	70.09	70.1	383566.0
2012-09-17 13:00:00	QQQ	ETF	70.1	70.12	70.06	70.09	676978.0
2012-09-17 13:30:00	QQQ	ETF	70.09	70.0982	70.05	70.08	811787.0
2012-09-17 14:00:00	QQQ	ETF	70.07	70.1	69.97	70.06	1668257.0
2012-09-17 14:30:00	QQQ	ETF	70.06	70.125	70.03	70.065	1054581.0

> showing 50 of 9,891 rows — these rows as CSV

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