PREVIEW / etf_30min / 2013-08-07

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-07.parquet
  size:    316 KB
  rows:    10,748

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
2013-08-07 04:00:00	SPY	ETF	169.4	169.4	169.03	169.09	9251.0
2013-08-07 04:30:00	SPY	ETF	169.12	169.33	169.12	169.3	17500.0
2013-08-07 05:00:00	SPY	ETF	169.3	169.32	169.18	169.18	4600.0
2013-08-07 05:30:00	SPY	ETF	169.24	169.39	169.03	169.09	15100.0
2013-08-07 06:00:00	SPY	ETF	169.12	169.2	169.02	169.16	38264.0
2013-08-07 06:30:00	SPY	ETF	169.18	169.33	169.18	169.23	13800.0
2013-08-07 07:00:00	SPY	ETF	169.25	169.35	169.23	169.28	30530.0
2013-08-07 07:30:00	SPY	ETF	169.3	169.42	169.23	169.37	66750.0
2013-08-07 08:00:00	SPY	ETF	169.24	169.47	169.24	169.45	124735.0
2013-08-07 08:30:00	SPY	ETF	169.46	169.46	169.36	169.44	165388.0
2013-08-07 09:00:00	SPY	ETF	169.43	169.43	169.15	169.18	622183.0
2013-08-07 09:30:00	SPY	ETF	169.19	169.43	168.84	168.89	12719079.0
2013-08-07 10:00:00	SPY	ETF	168.89	168.9	168.6	168.651	9616621.0
2013-08-07 10:30:00	SPY	ETF	168.66	168.87	168.55	168.86	7589102.0
2013-08-07 11:00:00	SPY	ETF	168.86	168.95	168.76	168.7601	3520517.0
2013-08-07 11:30:00	SPY	ETF	168.77	168.85	168.64	168.82	4783771.0
2013-08-07 12:00:00	SPY	ETF	168.82	168.96	168.77	168.87	2274467.0
2013-08-07 12:30:00	SPY	ETF	168.87	169.19	168.85	169.17	3117985.0
2013-08-07 13:00:00	SPY	ETF	169.171	169.3	169.12	169.25	3679991.0
2013-08-07 13:30:00	SPY	ETF	169.25	169.3	169.07	169.21	3982500.0
2013-08-07 14:00:00	SPY	ETF	169.215	169.27	169.0	169.09	2956726.0
2013-08-07 14:30:00	SPY	ETF	169.1	169.23	169.03	169.199	2820424.0
2013-08-07 15:00:00	SPY	ETF	169.195	169.42	169.17	169.34	5586004.0
2013-08-07 15:30:00	SPY	ETF	169.34	169.39	169.12	169.2	11264421.0
2013-08-07 16:00:00	SPY	ETF	169.195	169.35	168.9	169.27	3629953.0
2013-08-07 16:30:00	SPY	ETF	169.26	169.38	169.26	169.37	3838871.0
2013-08-07 17:00:00	SPY	ETF	169.37	169.38	169.3	169.31	78961.0
2013-08-07 17:30:00	SPY	ETF	169.33	169.37	169.27	169.3	89630.0
2013-08-07 18:00:00	SPY	ETF	169.31	169.34	169.28	169.29	87646.0
2013-08-07 18:30:00	SPY	ETF	169.31	169.32	169.31	169.31	30650.0
2013-08-07 19:00:00	SPY	ETF	169.3	169.32	169.27	169.28	31000.0
2013-08-07 19:30:00	SPY	ETF	169.29	169.42	169.29	169.42	42008.0
2013-08-07 04:00:00	QQQ	ETF	76.26	76.45	76.25	76.26	23397.0
2013-08-07 04:30:00	QQQ	ETF	76.26	76.35	76.26	76.35	5400.0
2013-08-07 05:00:00	QQQ	ETF	76.37	76.37	76.33	76.33	6000.0
2013-08-07 05:30:00	QQQ	ETF	76.35	76.39	76.27	76.27	26500.0
2013-08-07 06:00:00	QQQ	ETF	76.25	76.29	76.25	76.29	6600.0
2013-08-07 06:30:00	QQQ	ETF	76.31	76.35	76.31	76.31	6368.0
2013-08-07 07:00:00	QQQ	ETF	76.3	76.35	76.3	76.33	6400.0
2013-08-07 07:30:00	QQQ	ETF	76.32	76.38	76.32	76.38	15210.0
2013-08-07 08:00:00	QQQ	ETF	76.36	76.41	76.36	76.41	10960.0
2013-08-07 08:30:00	QQQ	ETF	76.4	76.46	76.39	76.45	42980.0
2013-08-07 09:00:00	QQQ	ETF	76.44	76.44	76.34	76.34	163468.0
2013-08-07 09:30:00	QQQ	ETF	76.35	76.568	76.2	76.23	3379930.0
2013-08-07 10:00:00	QQQ	ETF	76.22	76.22	75.87	75.93	3379139.0
2013-08-07 10:30:00	QQQ	ETF	75.93	76.07	75.87	76.0606	1291385.0
2013-08-07 11:00:00	QQQ	ETF	76.07	76.128	76.02	76.0201	695203.0
2013-08-07 11:30:00	QQQ	ETF	76.02	76.07	75.94	76.01	1069262.0
2013-08-07 12:00:00	QQQ	ETF	76.0178	76.11	75.99	76.07	394455.0
2013-08-07 12:30:00	QQQ	ETF	76.06	76.3	76.06	76.29	1436007.0

> showing 50 of 10,748 rows — these rows as CSV

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