PREVIEW / etf_30min / 2014-08-19

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-19.parquet
  size:    332 KB
  rows:    11,558

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-08-19 04:00:00	SPY	ETF	197.65	197.68	197.64	197.68	1890.0
2014-08-19 04:30:00	SPY	ETF	197.65	197.65	197.65	197.65	148.0
2014-08-19 05:00:00	SPY	ETF	197.68	197.75	197.68	197.75	2600.0
2014-08-19 05:30:00	SPY	ETF	197.66	197.67	197.61	197.67	4524.0
2014-08-19 06:00:00	SPY	ETF	197.65	197.65	197.62	197.62	634.0
2014-08-19 06:30:00	SPY	ETF	197.63	197.63	197.52	197.57	24159.0
2014-08-19 07:00:00	SPY	ETF	197.51	197.64	197.51	197.56	36229.0
2014-08-19 07:30:00	SPY	ETF	197.58	197.72	197.58	197.71	52374.0
2014-08-19 08:00:00	SPY	ETF	197.72	197.82	197.56	197.82	165721.0
2014-08-19 08:30:00	SPY	ETF	197.83	197.99	197.64	197.77	599839.0
2014-08-19 09:00:00	SPY	ETF	197.78	197.87	197.75	197.82	770984.0
2014-08-19 09:30:00	SPY	ETF	197.84	198.05	197.645	197.995	8865811.0
2014-08-19 10:00:00	SPY	ETF	198.0	198.11	197.8999	197.995	6119582.0
2014-08-19 10:30:00	SPY	ETF	197.99	198.25	197.88	198.185	4964968.0
2014-08-19 11:00:00	SPY	ETF	198.18	198.23	198.13	198.215	3026605.0
2014-08-19 11:30:00	SPY	ETF	198.21	198.23	198.08	198.175	2529334.0
2014-08-19 12:00:00	SPY	ETF	198.17	198.34	198.14	198.325	2074479.0
2014-08-19 12:30:00	SPY	ETF	198.325	198.35	198.25	198.285	1886043.0
2014-08-19 13:00:00	SPY	ETF	198.285	198.36	198.26	198.29	1753327.0
2014-08-19 13:30:00	SPY	ETF	198.295	198.34	198.2525	198.28	3434932.0
2014-08-19 14:00:00	SPY	ETF	198.285	198.52	198.28	198.47	2344580.0
2014-08-19 14:30:00	SPY	ETF	198.475	198.51	198.43	198.48	4273085.0
2014-08-19 15:00:00	SPY	ETF	198.475	198.54	198.43	198.4699	3667991.0
2014-08-19 15:30:00	SPY	ETF	198.46	198.48	198.37	198.39	7047411.0
2014-08-19 16:00:00	SPY	ETF	198.38	198.43	197.4041	198.31	3928570.0
2014-08-19 16:30:00	SPY	ETF	198.31	198.39	197.4427	198.28	815114.0
2014-08-19 17:00:00	SPY	ETF	198.3	198.33	198.3	198.31	7393.0
2014-08-19 17:30:00	SPY	ETF	198.32	198.33	198.28	198.31	33670.0
2014-08-19 18:00:00	SPY	ETF	198.32	198.32	198.29	198.31	3950.0
2014-08-19 18:30:00	SPY	ETF	198.31	198.31	198.25	198.285	49397.0
2014-08-19 19:00:00	SPY	ETF	198.3	198.32	198.27	198.27	70520.0
2014-08-19 19:30:00	SPY	ETF	198.28	198.29	198.23	198.23	45780.0
2014-08-19 04:00:00	QQQ	ETF	98.25	98.3	98.25	98.3	400.0
2014-08-19 05:00:00	QQQ	ETF	98.29	98.29	98.29	98.29	300.0
2014-08-19 06:00:00	QQQ	ETF	98.29	98.29	98.29	98.29	100.0
2014-08-19 06:30:00	QQQ	ETF	98.27	98.27	98.26	98.26	47300.0
2014-08-19 07:00:00	QQQ	ETF	98.28	98.28	98.25	98.25	3600.0
2014-08-19 07:30:00	QQQ	ETF	98.28	98.35	98.28	98.34	38350.0
2014-08-19 08:00:00	QQQ	ETF	98.33	98.35	98.28	98.33	53260.0
2014-08-19 08:30:00	QQQ	ETF	98.35	98.43	98.31	98.34	118614.0
2014-08-19 09:00:00	QQQ	ETF	98.34	98.43	98.33	98.37	170420.0
2014-08-19 09:30:00	QQQ	ETF	98.38	98.5	98.32	98.46	2836946.0
2014-08-19 10:00:00	QQQ	ETF	98.451	98.48	98.375	98.4	1841435.0
2014-08-19 10:30:00	QQQ	ETF	98.41	98.5	98.35	98.45	1808653.0
2014-08-19 11:00:00	QQQ	ETF	98.46	98.48	98.4	98.47	1133266.0
2014-08-19 11:30:00	QQQ	ETF	98.48	98.5	98.43	98.46	681347.0
2014-08-19 12:00:00	QQQ	ETF	98.455	98.57	98.41	98.54	1754656.0
2014-08-19 12:30:00	QQQ	ETF	98.55	98.57	98.51	98.52	574452.0
2014-08-19 13:00:00	QQQ	ETF	98.52	98.59	98.52	98.56	846440.0
2014-08-19 13:30:00	QQQ	ETF	98.57	98.63	98.55	98.63	951585.0

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

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