PREVIEW / etf_30min / 2014-07-23

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-23.parquet
  size:    331 KB
  rows:    11,721

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-23 04:00:00	SPY	ETF	198.14	198.23	198.12	198.2	11115.0
2014-07-23 04:30:00	SPY	ETF	198.19	198.21	198.19	198.2	5780.0
2014-07-23 05:00:00	SPY	ETF	198.21	198.21	198.21	198.21	762.0
2014-07-23 05:30:00	SPY	ETF	198.2	198.27	198.2	198.21	1000.0
2014-07-23 06:00:00	SPY	ETF	198.27	198.41	198.27	198.41	32854.0
2014-07-23 06:30:00	SPY	ETF	198.38	198.39	198.24	198.24	35004.0
2014-07-23 07:00:00	SPY	ETF	198.26	198.4	198.25	198.33	83416.0
2014-07-23 07:30:00	SPY	ETF	198.38	198.4	198.25	198.25	117506.0
2014-07-23 08:00:00	SPY	ETF	198.29	198.39	198.21	198.32	143474.0
2014-07-23 08:30:00	SPY	ETF	198.3	198.4	198.28	198.36	102745.0
2014-07-23 09:00:00	SPY	ETF	198.37	198.54	198.32	198.49	508801.0
2014-07-23 09:30:00	SPY	ETF	198.495	198.61	198.1	198.28	8490875.0
2014-07-23 10:00:00	SPY	ETF	198.29	198.58	198.19	198.56	3890481.0
2014-07-23 10:30:00	SPY	ETF	198.57	198.85	198.57	198.7	6068033.0
2014-07-23 11:00:00	SPY	ETF	198.7	198.8	198.65	198.68	3035496.0
2014-07-23 11:30:00	SPY	ETF	198.68	198.81	198.66	198.73	2716208.0
2014-07-23 12:00:00	SPY	ETF	198.73	198.76	198.57	198.58	3080546.0
2014-07-23 12:30:00	SPY	ETF	198.575	198.58	198.34	198.485	4352156.0
2014-07-23 13:00:00	SPY	ETF	198.49	198.56	198.42	198.55	2845388.0
2014-07-23 13:30:00	SPY	ETF	198.55	198.76	198.5	198.73	2636478.0
2014-07-23 14:00:00	SPY	ETF	198.725	198.78	198.64	198.67	1963775.0
2014-07-23 14:30:00	SPY	ETF	198.66	198.75	198.61	198.68	2353971.0
2014-07-23 15:00:00	SPY	ETF	198.69	198.76	198.62	198.75	2366311.0
2014-07-23 15:30:00	SPY	ETF	198.745	198.76	198.6	198.65	7131099.0
2014-07-23 16:00:00	SPY	ETF	198.64	198.69	198.2562	198.59	4305803.0
2014-07-23 16:30:00	SPY	ETF	198.59	198.65	198.57	198.63	207489.0
2014-07-23 17:00:00	SPY	ETF	198.63	198.67	198.6	198.63	187381.0
2014-07-23 17:30:00	SPY	ETF	198.63	198.64	198.6	198.64	3983325.0
2014-07-23 18:00:00	SPY	ETF	198.61	198.66	198.59	198.61	21786.0
2014-07-23 18:30:00	SPY	ETF	198.61	198.61	198.55	198.55	12940.0
2014-07-23 19:00:00	SPY	ETF	198.58	198.62	198.58	198.62	16300.0
2014-07-23 19:30:00	SPY	ETF	198.62	198.63	198.6	198.62	14184.0
2014-07-23 06:00:00	QQQ	ETF	96.7	96.76	96.7	96.76	4500.0
2014-07-23 06:30:00	QQQ	ETF	96.69	96.71	96.69	96.71	300.0
2014-07-23 07:00:00	QQQ	ETF	96.67	96.86	96.67	96.85	15450.0
2014-07-23 07:30:00	QQQ	ETF	96.88	96.97	96.84	96.85	158911.0
2014-07-23 08:00:00	QQQ	ETF	96.85	96.87	96.74	96.85	156163.0
2014-07-23 08:30:00	QQQ	ETF	96.83	96.91	96.82	96.89	160727.0
2014-07-23 09:00:00	QQQ	ETF	96.89	96.96	96.85	96.94	311401.0
2014-07-23 09:30:00	QQQ	ETF	96.94	97.1	96.77	96.95	5599127.0
2014-07-23 10:00:00	QQQ	ETF	96.96	97.14	96.87	97.11	2795222.0
2014-07-23 10:30:00	QQQ	ETF	97.12	97.34	97.12	97.2347	2872673.0
2014-07-23 11:00:00	QQQ	ETF	97.24	97.29	97.16	97.17	1602117.0
2014-07-23 11:30:00	QQQ	ETF	97.18	97.32	97.18	97.21	1481456.0
2014-07-23 12:00:00	QQQ	ETF	97.22	97.287	97.17	97.17	596904.0
2014-07-23 12:30:00	QQQ	ETF	97.17	97.17	97.04	97.14	1099990.0
2014-07-23 13:00:00	QQQ	ETF	97.1454	97.16	97.09	97.11	482841.0
2014-07-23 13:30:00	QQQ	ETF	97.11	97.2678	97.08	97.25	576447.0
2014-07-23 14:00:00	QQQ	ETF	97.25	97.32	97.22	97.26	724996.0
2014-07-23 14:30:00	QQQ	ETF	97.25	97.2999	97.2	97.25	927980.0

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

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