PREVIEW / etf_30min / 2014-07-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-03.parquet
  size:    224 KB
  rows:    7,449

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-03 04:00:00	SPY	ETF	197.38	197.38	197.38	197.38	183.0
2014-07-03 05:00:00	SPY	ETF	197.32	197.32	197.32	197.32	100.0
2014-07-03 05:30:00	SPY	ETF	197.32	197.45	197.24	197.4	2000.0
2014-07-03 06:00:00	SPY	ETF	197.46	197.46	197.42	197.46	1094.0
2014-07-03 06:30:00	SPY	ETF	197.44	197.46	197.43	197.43	900.0
2014-07-03 07:00:00	SPY	ETF	197.44	197.49	197.43	197.44	77376.0
2014-07-03 07:30:00	SPY	ETF	197.44	197.53	197.42	197.45	53174.0
2014-07-03 08:00:00	SPY	ETF	197.45	197.47	197.35	197.42	191391.0
2014-07-03 08:30:00	SPY	ETF	197.46	197.84	197.14	197.78	2010125.0
2014-07-03 09:00:00	SPY	ETF	197.78	197.86	197.71	197.78	1236052.0
2014-07-03 09:30:00	SPY	ETF	197.79	197.99	197.64	197.795	8355618.0
2014-07-03 10:00:00	SPY	ETF	197.79	197.97	197.665	197.79	4516896.0
2014-07-03 10:30:00	SPY	ETF	197.78	197.93	197.78	197.9	3107961.0
2014-07-03 11:00:00	SPY	ETF	197.9	198.05	197.85	198.01	3431636.0
2014-07-03 11:30:00	SPY	ETF	198.01	198.15	197.995	198.13	3083287.0
2014-07-03 12:00:00	SPY	ETF	198.129	198.29	198.12	198.24	4853527.0
2014-07-03 12:30:00	SPY	ETF	198.23	198.28	198.06	198.24	10725612.0
2014-07-03 13:00:00	SPY	ETF	198.24	198.27	197.226	198.14	3503443.0
2014-07-03 13:30:00	SPY	ETF	198.13	198.2	198.1	198.13	604709.0
2014-07-03 14:00:00	SPY	ETF	198.13	198.145	198.07	198.09	74830.0
2014-07-03 14:30:00	SPY	ETF	198.08	198.15	198.02	198.07	86934.0
2014-07-03 15:00:00	SPY	ETF	198.12	198.12	198.02	198.1	29087.0
2014-07-03 15:30:00	SPY	ETF	198.0401	198.08	198.0401	198.05	4100.0
2014-07-03 16:00:00	SPY	ETF	198.08	198.08	198.05	198.06	4099.0
2014-07-03 16:30:00	SPY	ETF	198.06	198.06	198.05	198.05	7949.0
2014-07-03 04:00:00	QQQ	ETF	95.11	95.11	95.11	95.11	350.0
2014-07-03 07:00:00	QQQ	ETF	95.22	95.22	95.2	95.2	1600.0
2014-07-03 08:00:00	QQQ	ETF	95.18	95.24	95.16	95.22	103920.0
2014-07-03 08:30:00	QQQ	ETF	95.24	95.41	95.11	95.38	246893.0
2014-07-03 09:00:00	QQQ	ETF	95.39	95.43	95.36	95.4	192999.0
2014-07-03 09:30:00	QQQ	ETF	95.4	95.415	95.15	95.271	3371559.0
2014-07-03 10:00:00	QQQ	ETF	95.27	95.43	95.23	95.34	2121295.0
2014-07-03 10:30:00	QQQ	ETF	95.34	95.42	95.33	95.41	911035.0
2014-07-03 11:00:00	QQQ	ETF	95.42	95.51	95.37	95.471	1626571.0
2014-07-03 11:30:00	QQQ	ETF	95.49	95.56	95.47	95.56	778523.0
2014-07-03 12:00:00	QQQ	ETF	95.56	95.66	95.54	95.6446	1248337.0
2014-07-03 12:30:00	QQQ	ETF	95.65	95.68	95.58	95.65	2601972.0
2014-07-03 13:00:00	QQQ	ETF	95.66	95.75	95.438	95.71	1304163.0
2014-07-03 13:30:00	QQQ	ETF	95.7	95.7	95.1141	95.6999	496234.0
2014-07-03 14:00:00	QQQ	ETF	95.7	95.7	95.7	95.7	1900.0
2014-07-03 14:30:00	QQQ	ETF	95.67	95.69	95.62	95.63	4747.0
2014-07-03 15:00:00	QQQ	ETF	95.62	95.7	95.62	95.7	3026.0
2014-07-03 15:30:00	QQQ	ETF	95.7	95.7	95.69	95.69	1000.0
2014-07-03 16:00:00	QQQ	ETF	95.64	95.64	95.64	95.64	358.0
2014-07-03 16:30:00	QQQ	ETF	95.7	95.7	95.66	95.66	700.0
2014-07-03 08:00:00	IWM	ETF	119.27	119.31	119.17	119.24	37738.0
2014-07-03 08:30:00	IWM	ETF	119.46	119.54	118.94	119.54	506768.0
2014-07-03 09:00:00	IWM	ETF	119.56	119.67	119.48	119.57	493520.0
2014-07-03 09:30:00	IWM	ETF	119.59	119.83	119.25	119.4	2965892.0
2014-07-03 10:00:00	IWM	ETF	119.42	119.69	119.32	119.58	2203894.0

> showing 50 of 7,449 rows — these rows as CSV

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