PREVIEW / etf_30min / 2014-02-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-03.parquet
  size:    378 KB
  rows:    12,388

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-03 04:00:00	SPY	ETF	178.32	178.32	177.81	177.82	40516.0
2014-02-03 04:30:00	SPY	ETF	177.95	178.05	177.82	177.88	14568.0
2014-02-03 05:00:00	SPY	ETF	177.93	178.11	177.73	177.76	22875.0
2014-02-03 05:30:00	SPY	ETF	177.81	177.83	177.62	177.72	17625.0
2014-02-03 06:00:00	SPY	ETF	177.73	177.86	177.68	177.78	69920.0
2014-02-03 06:30:00	SPY	ETF	177.78	178.2	177.78	178.06	152108.0
2014-02-03 07:00:00	SPY	ETF	178.09	178.25	178.01	178.07	109378.0
2014-02-03 07:30:00	SPY	ETF	178.14	178.55	178.12	178.55	120114.0
2014-02-03 08:00:00	SPY	ETF	178.11	178.66	178.11	178.44	421599.0
2014-02-03 08:30:00	SPY	ETF	178.44	178.47	178.08	178.13	547724.0
2014-02-03 09:00:00	SPY	ETF	178.14	178.23	177.92	177.93	1012882.0
2014-02-03 09:30:00	SPY	ETF	177.95	178.37	177.4	177.69	17456343.0
2014-02-03 10:00:00	SPY	ETF	177.68	177.68	176.21	176.47	25177389.0
2014-02-03 10:30:00	SPY	ETF	176.46	177.94	176.29	176.4799	14135576.0
2014-02-03 11:00:00	SPY	ETF	176.47	176.4799	175.66	175.85	14718610.0
2014-02-03 11:30:00	SPY	ETF	175.84	176.06	175.33	175.41	15332075.0
2014-02-03 12:00:00	SPY	ETF	175.4	175.44	174.98	175.42	14682179.0
2014-02-03 12:30:00	SPY	ETF	175.42	175.61	175.28	175.3	9264950.0
2014-02-03 13:00:00	SPY	ETF	175.295	175.395	174.56	174.66	12653115.0
2014-02-03 13:30:00	SPY	ETF	174.659	174.889	174.28	174.5064	15843538.0
2014-02-03 14:00:00	SPY	ETF	174.5	174.86	174.41	174.76	14582341.0
2014-02-03 14:30:00	SPY	ETF	174.76	174.77	174.05	174.05	13440620.0
2014-02-03 15:00:00	SPY	ETF	174.05	174.39	174.0	174.38	18903421.0
2014-02-03 15:30:00	SPY	ETF	174.375	174.475	173.83	174.17	38084952.0
2014-02-03 16:00:00	SPY	ETF	174.18	178.1575	173.73	173.86	9585375.0
2014-02-03 16:30:00	SPY	ETF	173.86	178.1575	173.77	174.15	10532303.0
2014-02-03 17:00:00	SPY	ETF	174.17	174.19	174.07	174.15	733924.0
2014-02-03 17:30:00	SPY	ETF	174.13	178.1574	174.0	174.21	592175.0
2014-02-03 18:00:00	SPY	ETF	174.21	174.29	174.14	174.29	98471.0
2014-02-03 18:30:00	SPY	ETF	174.29	174.4	174.27	174.3	147038.0
2014-02-03 19:00:00	SPY	ETF	174.3	174.38	174.17	174.25	69142.0
2014-02-03 19:30:00	SPY	ETF	174.25	174.5	174.2	174.5	145221.0
2014-02-03 04:00:00	QQQ	ETF	86.3	86.3	86.3	86.3	100.0
2014-02-03 05:00:00	QQQ	ETF	86.13	86.16	86.01	86.03	7000.0
2014-02-03 05:30:00	QQQ	ETF	86.05	86.05	85.97	85.97	3600.0
2014-02-03 06:00:00	QQQ	ETF	85.99	86.05	85.99	86.05	1400.0
2014-02-03 06:30:00	QQQ	ETF	86.18	86.28	86.18	86.18	2219.0
2014-02-03 07:00:00	QQQ	ETF	86.22	86.28	86.18	86.18	33600.0
2014-02-03 07:30:00	QQQ	ETF	86.27	86.46	86.26	86.46	28320.0
2014-02-03 08:00:00	QQQ	ETF	86.43	86.49	86.38	86.39	58515.0
2014-02-03 08:30:00	QQQ	ETF	86.38	86.4	86.24	86.25	536462.0
2014-02-03 09:00:00	QQQ	ETF	86.24	86.27	86.06	86.13	756377.0
2014-02-03 09:30:00	QQQ	ETF	86.14	86.5	85.81	86.07	4164801.0
2014-02-03 10:00:00	QQQ	ETF	86.01	86.01	85.24	85.35	7903081.0
2014-02-03 10:30:00	QQQ	ETF	85.34	85.66	85.26	85.4899	2813190.0
2014-02-03 11:00:00	QQQ	ETF	85.48	85.51	85.0601	85.1936	3689300.0
2014-02-03 11:30:00	QQQ	ETF	85.19	85.32	84.9305	84.97	4386613.0
2014-02-03 12:00:00	QQQ	ETF	84.96	84.98	84.71	84.97	4255528.0
2014-02-03 12:30:00	QQQ	ETF	84.97	85.0899	84.83	84.84	2603897.0
2014-02-03 13:00:00	QQQ	ETF	84.84	84.9	84.27	84.34	6372507.0

> showing 50 of 12,388 rows — these rows as CSV

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