PREVIEW / etf_30min / 2013-04-17

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-17.parquet
  size:    329 KB
  rows:    10,912

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-04-17 04:00:00	SPY	ETF	156.61	156.63	156.34	156.53	50924.0
2013-04-17 04:30:00	SPY	ETF	156.67	156.67	156.51	156.66	2300.0
2013-04-17 05:00:00	SPY	ETF	156.61	156.64	156.52	156.52	7790.0
2013-04-17 05:30:00	SPY	ETF	156.55	156.6	156.44	156.59	15500.0
2013-04-17 06:00:00	SPY	ETF	156.59	156.59	156.35	156.46	52298.0
2013-04-17 06:30:00	SPY	ETF	156.46	156.5	156.02	156.1	153520.0
2013-04-17 07:00:00	SPY	ETF	156.13	156.31	156.03	156.12	328569.0
2013-04-17 07:30:00	SPY	ETF	156.15	156.26	156.0	156.23	798389.0
2013-04-17 08:00:00	SPY	ETF	156.23	156.47	156.03	156.47	504432.0
2013-04-17 08:30:00	SPY	ETF	156.47	156.52	156.12	156.13	2180214.0
2013-04-17 09:00:00	SPY	ETF	156.13	156.38	156.09	156.29	900899.0
2013-04-17 09:30:00	SPY	ETF	156.29	156.32	155.67	155.97	22301019.0
2013-04-17 10:00:00	SPY	ETF	155.96	156.08	155.37	155.66	18327595.0
2013-04-17 10:30:00	SPY	ETF	155.66	155.66	154.72	154.74	18515871.0
2013-04-17 11:00:00	SPY	ETF	154.73	155.15	154.52	155.0	25340755.0
2013-04-17 11:30:00	SPY	ETF	155.008	155.17	154.799	154.93	10452298.0
2013-04-17 12:00:00	SPY	ETF	154.93	155.07	154.32	154.36	11196502.0
2013-04-17 12:30:00	SPY	ETF	154.37	154.8	154.28	154.78	11305935.0
2013-04-17 13:00:00	SPY	ETF	154.79	155.02	154.63	154.88	11439700.0
2013-04-17 13:30:00	SPY	ETF	154.885	155.39	154.85	155.1	12026692.0
2013-04-17 14:00:00	SPY	ETF	155.1	155.39	154.97	155.29	8814051.0
2013-04-17 14:30:00	SPY	ETF	155.295	155.35	154.74	155.08	11246594.0
2013-04-17 15:00:00	SPY	ETF	155.07	155.49	154.97	155.26	12374130.0
2013-04-17 15:30:00	SPY	ETF	155.257	155.44	154.92	155.06	24916437.0
2013-04-17 16:00:00	SPY	ETF	155.04	157.4028	155.0	155.09	9828188.0
2013-04-17 16:30:00	SPY	ETF	155.08	155.08	154.97	155.07	6463116.0
2013-04-17 17:00:00	SPY	ETF	155.06	155.08	154.86	154.9	226233.0
2013-04-17 17:30:00	SPY	ETF	154.89	154.92	154.87	154.9	160152.0
2013-04-17 18:00:00	SPY	ETF	154.91	155.09	154.9	155.09	135685.0
2013-04-17 18:30:00	SPY	ETF	155.09	155.11	155.02	155.11	67599.0
2013-04-17 19:00:00	SPY	ETF	155.1	155.13	155.1	155.11	35154.0
2013-04-17 19:30:00	SPY	ETF	155.1	155.26	155.1	155.26	35965.0
2013-04-17 04:00:00	QQQ	ETF	69.07	69.07	69.0	69.01	17346.0
2013-04-17 04:30:00	QQQ	ETF	69.02	69.02	69.02	69.02	100.0
2013-04-17 05:00:00	QQQ	ETF	69.05	69.05	69.05	69.05	300.0
2013-04-17 06:00:00	QQQ	ETF	69.03	69.03	69.0	69.0	3900.0
2013-04-17 06:30:00	QQQ	ETF	69.01	69.01	68.94	68.94	6900.0
2013-04-17 07:00:00	QQQ	ETF	68.88	68.94	68.8	68.8	11500.0
2013-04-17 07:30:00	QQQ	ETF	68.83	68.91	68.77	68.9	46076.0
2013-04-17 08:00:00	QQQ	ETF	68.85	68.97	68.84	68.97	43391.0
2013-04-17 08:30:00	QQQ	ETF	69.02	69.03	68.83	68.85	1477080.0
2013-04-17 09:00:00	QQQ	ETF	68.84	68.93	68.83	68.83	187913.0
2013-04-17 09:30:00	QQQ	ETF	68.84	68.889	68.6	68.7001	5810681.0
2013-04-17 10:00:00	QQQ	ETF	68.7	68.76	68.22	68.39	4669306.0
2013-04-17 10:30:00	QQQ	ETF	68.39	68.39	67.96	67.97	4080894.0
2013-04-17 11:00:00	QQQ	ETF	67.97	68.27	67.87	68.19	4503711.0
2013-04-17 11:30:00	QQQ	ETF	68.18	68.24	68.03	68.052	1676230.0
2013-04-17 12:00:00	QQQ	ETF	68.05	68.131	67.77	67.79	2542879.0
2013-04-17 12:30:00	QQQ	ETF	67.81	68.02	67.71	68.01	2691148.0
2013-04-17 13:00:00	QQQ	ETF	68.011	68.15	67.95	68.09	2365834.0

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

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