PREVIEW / etf_30min / 2015-05-06

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-06.parquet
  size:    390 KB
  rows:    12,984

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
2015-05-06 04:00:00	SPY	ETF	209.19	209.66	209.19	209.6	11745.0
2015-05-06 04:30:00	SPY	ETF	209.6	209.6	209.21	209.6	30250.0
2015-05-06 05:00:00	SPY	ETF	209.54	209.8	209.54	209.59	14017.0
2015-05-06 05:30:00	SPY	ETF	209.6	209.66	209.5	209.51	25872.0
2015-05-06 06:00:00	SPY	ETF	209.54	209.64	209.45	209.47	28301.0
2015-05-06 06:30:00	SPY	ETF	209.49	209.49	209.25	209.32	45125.0
2015-05-06 07:00:00	SPY	ETF	209.34	209.52	209.33	209.51	199284.0
2015-05-06 07:30:00	SPY	ETF	209.52	209.71	209.52	209.67	233394.0
2015-05-06 08:00:00	SPY	ETF	209.65	209.7	209.35	209.52	465128.0
2015-05-06 08:30:00	SPY	ETF	209.54	209.57	209.4	209.43	400370.0
2015-05-06 09:00:00	SPY	ETF	209.44	209.65	209.41	209.54	300401.0
2015-05-06 09:30:00	SPY	ETF	209.56	209.93	207.98	208.36	15552055.0
2015-05-06 10:00:00	SPY	ETF	208.36	208.48	207.65	208.34	14095849.0
2015-05-06 10:30:00	SPY	ETF	208.35	208.98	208.01	208.8	9523957.0
2015-05-06 11:00:00	SPY	ETF	208.81	208.89	208.12	208.43	6390209.0
2015-05-06 11:30:00	SPY	ETF	208.43	208.73	208.24	208.5501	5209019.0
2015-05-06 12:00:00	SPY	ETF	208.55	208.58	208.08	208.14	4362372.0
2015-05-06 12:30:00	SPY	ETF	208.14	208.31	207.86	207.98	5791816.0
2015-05-06 13:00:00	SPY	ETF	207.99	208.17	207.76	207.85	4232990.0
2015-05-06 13:30:00	SPY	ETF	207.85	207.86	207.28	207.511	9648500.0
2015-05-06 14:00:00	SPY	ETF	207.52	207.65	207.22	207.42	5920058.0
2015-05-06 14:30:00	SPY	ETF	207.43	207.43	206.76	207.1742	13439552.0
2015-05-06 15:00:00	SPY	ETF	207.18	207.48	206.89	207.46	11409834.0
2015-05-06 15:30:00	SPY	ETF	207.46	208.09	207.25	208.03	15863971.0
2015-05-06 16:00:00	SPY	ETF	208.03	209.63	207.5025	208.04	8933914.0
2015-05-06 16:30:00	SPY	ETF	208.05	208.2	208.01	208.09	1126427.0
2015-05-06 17:00:00	SPY	ETF	208.09	208.1	208.03	208.06	69103.0
2015-05-06 17:30:00	SPY	ETF	208.07	208.13	208.03	208.08	37864.0
2015-05-06 18:00:00	SPY	ETF	208.08	208.17	208.08	208.17	14278.0
2015-05-06 18:30:00	SPY	ETF	208.14	208.15	208.05	208.05	9258.0
2015-05-06 19:00:00	SPY	ETF	208.05	208.07	207.78	207.93	34190.0
2015-05-06 19:30:00	SPY	ETF	207.94	207.98	207.9	207.92	26992.0
2015-05-06 06:00:00	QQQ	ETF	107.62	107.71	107.6	107.62	23094.0
2015-05-06 06:30:00	QQQ	ETF	107.62	107.64	107.52	107.6	23700.0
2015-05-06 07:00:00	QQQ	ETF	107.62	107.68	107.59	107.65	167052.0
2015-05-06 07:30:00	QQQ	ETF	107.66	107.76	107.65	107.76	55504.0
2015-05-06 08:00:00	QQQ	ETF	107.75	107.789	107.63	107.73	75309.0
2015-05-06 08:30:00	QQQ	ETF	107.73	107.74	107.59	107.59	46060.0
2015-05-06 09:00:00	QQQ	ETF	107.65	107.75	107.62	107.63	54166.0
2015-05-06 09:30:00	QQQ	ETF	107.64	107.95	106.71	106.9	6412595.0
2015-05-06 10:00:00	QQQ	ETF	106.895	106.96	106.46	106.9	3973891.0
2015-05-06 10:30:00	QQQ	ETF	106.91	107.22	106.62	107.14	3006137.0
2015-05-06 11:00:00	QQQ	ETF	107.15	107.31	106.85	107.02	1676994.0
2015-05-06 11:30:00	QQQ	ETF	107.03	107.17	106.87	107.07	1081584.0
2015-05-06 12:00:00	QQQ	ETF	107.08	107.08	106.78	106.85	974345.0
2015-05-06 12:30:00	QQQ	ETF	106.85	106.94	106.64	106.72	1104116.0
2015-05-06 13:00:00	QQQ	ETF	106.73	106.82	106.535	106.54	2073160.0
2015-05-06 13:30:00	QQQ	ETF	106.54	106.575	106.245	106.42	2517672.0
2015-05-06 14:00:00	QQQ	ETF	106.411	106.47	106.16	106.31	1584588.0
2015-05-06 14:30:00	QQQ	ETF	106.31	106.31	105.995	106.235	2310153.0

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

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