PREVIEW / etf_30min / 2013-10-18

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-18.parquet
  size:    329 KB
  rows:    11,212

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-10-18 04:00:00	SPY	ETF	173.47	173.6	173.46	173.49	15906.0
2013-10-18 04:30:00	SPY	ETF	173.47	173.53	173.47	173.47	6500.0
2013-10-18 05:00:00	SPY	ETF	173.49	173.53	173.45	173.53	7037.0
2013-10-18 05:30:00	SPY	ETF	173.51	173.51	173.37	173.49	28067.0
2013-10-18 06:00:00	SPY	ETF	173.49	173.49	173.39	173.49	5256.0
2013-10-18 06:30:00	SPY	ETF	173.51	173.55	173.39	173.39	105621.0
2013-10-18 07:00:00	SPY	ETF	173.41	173.54	173.39	173.52	82518.0
2013-10-18 07:30:00	SPY	ETF	173.52	173.69	173.5	173.69	259151.0
2013-10-18 08:00:00	SPY	ETF	173.44	173.85	173.44	173.75	532199.0
2013-10-18 08:30:00	SPY	ETF	173.73	173.78	173.65	173.75	297912.0
2013-10-18 09:00:00	SPY	ETF	173.75	173.96	173.61	173.85	1436202.0
2013-10-18 09:30:00	SPY	ETF	173.86	174.06	173.52	174.001	22934380.0
2013-10-18 10:00:00	SPY	ETF	174.0	174.12	173.69	173.71	13714891.0
2013-10-18 10:30:00	SPY	ETF	173.72	173.86	173.51	173.75	9046667.0
2013-10-18 11:00:00	SPY	ETF	173.751	173.93	173.67	173.899	5859594.0
2013-10-18 11:30:00	SPY	ETF	173.89	174.04	173.8	173.82	5903062.0
2013-10-18 12:00:00	SPY	ETF	173.81	174.02	173.74	173.9233	6904926.0
2013-10-18 12:30:00	SPY	ETF	173.93	174.1	173.93	173.99	4596222.0
2013-10-18 13:00:00	SPY	ETF	174.0	174.26	173.993	174.221	6253754.0
2013-10-18 13:30:00	SPY	ETF	174.23	174.44	174.13	174.42	5531689.0
2013-10-18 14:00:00	SPY	ETF	174.425	174.46	174.23	174.38	8045646.0
2013-10-18 14:30:00	SPY	ETF	174.37	174.51	174.31	174.3401	8698001.0
2013-10-18 15:00:00	SPY	ETF	174.34	174.37	174.16	174.259	7932376.0
2013-10-18 15:30:00	SPY	ETF	174.25	174.4	174.14	174.37	17839429.0
2013-10-18 16:00:00	SPY	ETF	174.37	174.411	174.12	174.2	4807533.0
2013-10-18 16:30:00	SPY	ETF	174.17	174.388	173.2764	174.26	4784811.0
2013-10-18 17:00:00	SPY	ETF	174.38	174.38	174.2	174.27	129036.0
2013-10-18 17:30:00	SPY	ETF	174.27	174.27	174.17	174.24	83829.0
2013-10-18 18:00:00	SPY	ETF	174.21	174.21	174.1	174.19	11824.0
2013-10-18 18:30:00	SPY	ETF	174.2	174.22	174.2	174.22	2283.0
2013-10-18 19:00:00	SPY	ETF	174.21	174.28	174.21	174.28	9336.0
2013-10-18 19:30:00	SPY	ETF	174.28	174.33	174.23	174.3	22252.0
2013-10-18 04:00:00	QQQ	ETF	81.34	81.4	81.31	81.35	24292.0
2013-10-18 04:30:00	QQQ	ETF	81.36	81.4	81.36	81.37	3200.0
2013-10-18 05:00:00	QQQ	ETF	81.38	81.41	81.36	81.41	3800.0
2013-10-18 05:30:00	QQQ	ETF	81.4	81.4	81.33	81.39	10800.0
2013-10-18 06:00:00	QQQ	ETF	81.38	81.38	81.33	81.37	6400.0
2013-10-18 06:30:00	QQQ	ETF	81.38	81.41	81.34	81.34	15100.0
2013-10-18 07:00:00	QQQ	ETF	81.35	81.41	81.35	81.41	15090.0
2013-10-18 07:30:00	QQQ	ETF	81.41	81.45	81.4	81.45	26540.0
2013-10-18 08:00:00	QQQ	ETF	81.44	81.53	81.38	81.49	283775.0
2013-10-18 08:30:00	QQQ	ETF	81.48	81.48	81.41	81.44	153275.0
2013-10-18 09:00:00	QQQ	ETF	81.45	81.58	81.41	81.56	351662.0
2013-10-18 09:30:00	QQQ	ETF	81.56	81.74	81.35	81.72	5262157.0
2013-10-18 10:00:00	QQQ	ETF	81.71	81.86	81.67	81.689	3149304.0
2013-10-18 10:30:00	QQQ	ETF	81.6823	81.78	81.6	81.72	3482042.0
2013-10-18 11:00:00	QQQ	ETF	81.7201	81.81	81.67	81.745	1420164.0
2013-10-18 11:30:00	QQQ	ETF	81.745	81.79	81.64	81.68	1180186.0
2013-10-18 12:00:00	QQQ	ETF	81.67	81.8	81.65	81.77	1018198.0
2013-10-18 12:30:00	QQQ	ETF	81.78	81.8899	81.77	81.85	1011620.0

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

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