PREVIEW / etf_30min / 2014-07-25

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-25.parquet
  size:    337 KB
  rows:    11,720

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-07-25 04:00:00	SPY	ETF	198.51	198.54	198.51	198.51	821.0
2014-07-25 04:30:00	SPY	ETF	198.52	198.52	198.45	198.45	598.0
2014-07-25 05:00:00	SPY	ETF	198.46	198.46	198.31	198.36	5814.0
2014-07-25 05:30:00	SPY	ETF	198.36	198.36	198.32	198.36	602.0
2014-07-25 06:00:00	SPY	ETF	198.3	198.32	198.12	198.21	5770.0
2014-07-25 06:30:00	SPY	ETF	198.17	198.22	198.08	198.19	8229.0
2014-07-25 07:00:00	SPY	ETF	198.2	198.29	198.14	198.24	74259.0
2014-07-25 07:30:00	SPY	ETF	198.25	198.39	198.25	198.33	150500.0
2014-07-25 08:00:00	SPY	ETF	198.31	198.34	198.23	198.34	181843.0
2014-07-25 08:30:00	SPY	ETF	198.35	198.4	198.2	198.27	343604.0
2014-07-25 09:00:00	SPY	ETF	198.26	198.26	198.02	198.1	450488.0
2014-07-25 09:30:00	SPY	ETF	198.09	198.2	197.75	198.125	9942754.0
2014-07-25 10:00:00	SPY	ETF	198.12	198.26	197.94	198.16	5530080.0
2014-07-25 10:30:00	SPY	ETF	198.165	198.2	197.79	197.845	3761655.0
2014-07-25 11:00:00	SPY	ETF	197.85	198.17	197.33	197.56	10668775.0
2014-07-25 11:30:00	SPY	ETF	197.55	197.77	197.54	197.67	4740910.0
2014-07-25 12:00:00	SPY	ETF	197.67	197.87	197.66	197.76	2450814.0
2014-07-25 12:30:00	SPY	ETF	197.77	197.93	197.71	197.88	2549303.0
2014-07-25 13:00:00	SPY	ETF	197.875	197.88	197.631	197.73	3613992.0
2014-07-25 13:30:00	SPY	ETF	197.73	197.74	197.5	197.53	3137598.0
2014-07-25 14:00:00	SPY	ETF	197.53	197.84	197.42	197.79	3945769.0
2014-07-25 14:30:00	SPY	ETF	197.79	197.88	197.65	197.73	2618696.0
2014-07-25 15:00:00	SPY	ETF	197.725	197.76	197.58	197.6	4270168.0
2014-07-25 15:30:00	SPY	ETF	197.595	197.74	197.48	197.71	10213983.0
2014-07-25 16:00:00	SPY	ETF	197.72	197.75	197.6	197.61	3884451.0
2014-07-25 16:30:00	SPY	ETF	197.62	197.72	197.61	197.63	2282207.0
2014-07-25 17:00:00	SPY	ETF	197.61	197.64	197.59	197.62	156005.0
2014-07-25 17:30:00	SPY	ETF	197.63	197.63	197.55	197.55	11321.0
2014-07-25 18:00:00	SPY	ETF	197.55	197.55	197.48	197.51	30976.0
2014-07-25 18:30:00	SPY	ETF	197.55	197.72	197.53	197.65	13653.0
2014-07-25 19:00:00	SPY	ETF	197.6	197.65	197.57	197.64	3000.0
2014-07-25 19:30:00	SPY	ETF	197.6	197.6	197.55	197.58	6752.0
2014-07-25 04:00:00	QQQ	ETF	96.82	96.82	96.82	96.82	2000.0
2014-07-25 04:30:00	QQQ	ETF	96.84	96.89	96.83	96.84	3600.0
2014-07-25 05:00:00	QQQ	ETF	96.77	96.79	96.75	96.79	22800.0
2014-07-25 06:00:00	QQQ	ETF	96.71	96.75	96.65	96.75	3300.0
2014-07-25 06:30:00	QQQ	ETF	96.72	96.75	96.72	96.75	1800.0
2014-07-25 07:00:00	QQQ	ETF	96.75	96.77	96.74	96.75	12000.0
2014-07-25 07:30:00	QQQ	ETF	96.79	96.82	96.78	96.8	11800.0
2014-07-25 08:00:00	QQQ	ETF	96.82	96.82	96.78	96.8	108808.0
2014-07-25 08:30:00	QQQ	ETF	96.81	96.81	96.7	96.72	69363.0
2014-07-25 09:00:00	QQQ	ETF	96.72	96.72	96.61	96.66	158894.0
2014-07-25 09:30:00	QQQ	ETF	96.65	96.78	96.44	96.72	4405659.0
2014-07-25 10:00:00	QQQ	ETF	96.73	96.87	96.65	96.825	1463254.0
2014-07-25 10:30:00	QQQ	ETF	96.83	96.85	96.41	96.46	1663508.0
2014-07-25 11:00:00	QQQ	ETF	96.46	96.48	96.23	96.345	2597438.0
2014-07-25 11:30:00	QQQ	ETF	96.34	96.5357	96.335	96.485	993752.0
2014-07-25 12:00:00	QQQ	ETF	96.495	96.66	96.495	96.57	907508.0
2014-07-25 12:30:00	QQQ	ETF	96.565	96.73	96.55	96.71	762546.0
2014-07-25 13:00:00	QQQ	ETF	96.71	96.71	96.6	96.67	758305.0

> showing 50 of 11,720 rows — these rows as CSV

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