PREVIEW / etf_30min / 2011-04-04

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-04.parquet
  size:    272 KB
  rows:    9,325

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
2011-04-04 05:00:00	SPY	ETF	133.35	133.41	133.31	133.31	3200.0
2011-04-04 05:30:00	SPY	ETF	133.27	133.3	133.27	133.3	700.0
2011-04-04 06:00:00	SPY	ETF	133.32	133.44	133.32	133.44	12880.0
2011-04-04 06:30:00	SPY	ETF	133.41	133.49	133.41	133.47	15000.0
2011-04-04 07:00:00	SPY	ETF	133.46	133.55	133.37	133.38	120480.0
2011-04-04 07:30:00	SPY	ETF	133.37	133.43	133.37	133.41	75601.0
2011-04-04 08:00:00	SPY	ETF	133.41	133.52	133.4	133.52	157805.0
2011-04-04 08:30:00	SPY	ETF	133.53	133.53	133.43	133.44	222507.0
2011-04-04 09:00:00	SPY	ETF	133.45	133.48	133.15	133.43	521841.0
2011-04-04 09:30:00	SPY	ETF	133.43	133.67	133.25	133.34	14905474.0
2011-04-04 10:00:00	SPY	ETF	133.34	133.44	133.16	133.261	7915282.0
2011-04-04 10:30:00	SPY	ETF	133.26	133.44	133.18	133.23	9189052.0
2011-04-04 11:00:00	SPY	ETF	133.22	133.34	133.11	133.34	6442269.0
2011-04-04 11:30:00	SPY	ETF	133.33	133.38	133.26	133.31	3273538.0
2011-04-04 12:00:00	SPY	ETF	133.315	133.37	133.29	133.29	2749066.0
2011-04-04 12:30:00	SPY	ETF	133.29	133.33	133.1	133.19	5626579.0
2011-04-04 13:00:00	SPY	ETF	133.18	133.27	133.18	133.24	2400307.0
2011-04-04 13:30:00	SPY	ETF	133.24	133.24	132.88	132.99	8034345.0
2011-04-04 14:00:00	SPY	ETF	132.99	133.13	132.88	133.06	6312556.0
2011-04-04 14:30:00	SPY	ETF	133.06	133.14	133.04	133.08	2799544.0
2011-04-04 15:00:00	SPY	ETF	133.08	133.25	132.95	133.21	7046154.0
2011-04-04 15:30:00	SPY	ETF	133.205	133.26	133.07	133.24	11778747.0
2011-04-04 16:00:00	SPY	ETF	133.25	133.48	133.2245	133.38	6585785.0
2011-04-04 16:30:00	SPY	ETF	133.39	133.45	133.26	133.4	1190334.0
2011-04-04 17:00:00	SPY	ETF	133.4	133.44	133.38	133.42	60867.0
2011-04-04 17:30:00	SPY	ETF	133.45	133.45	133.38	133.44	26481.0
2011-04-04 18:00:00	SPY	ETF	133.44	133.44	133.24	133.4	37858.0
2011-04-04 18:30:00	SPY	ETF	133.4	133.41	133.36	133.4	18475.0
2011-04-04 19:00:00	SPY	ETF	133.43	133.49	133.41	133.48	13342.0
2011-04-04 19:30:00	SPY	ETF	133.48	133.5	133.37	133.37	54818.0
2011-04-04 05:30:00	QQQ	ETF	57.59	57.59	57.59	57.59	800.0
2011-04-04 06:30:00	QQQ	ETF	57.66	57.66	57.66	57.66	200.0
2011-04-04 07:00:00	QQQ	ETF	57.66	57.68	57.66	57.67	3500.0
2011-04-04 07:30:00	QQQ	ETF	57.64	57.66	57.63	57.65	22113.0
2011-04-04 08:00:00	QQQ	ETF	57.63	57.66	57.63	57.66	52087.0
2011-04-04 08:30:00	QQQ	ETF	57.67	57.68	57.64	57.64	40700.0
2011-04-04 09:00:00	QQQ	ETF	57.65	57.66	57.46	57.61	161821.0
2011-04-04 09:30:00	QQQ	ETF	57.62	57.68	57.34	57.39	7765522.0
2011-04-04 10:00:00	QQQ	ETF	57.39	57.41	57.22	57.265	4586948.0
2011-04-04 10:30:00	QQQ	ETF	57.26	57.38	57.22	57.2494	3001669.0
2011-04-04 11:00:00	QQQ	ETF	57.24	57.38	57.21	57.37	2135124.0
2011-04-04 11:30:00	QQQ	ETF	57.37	57.38	57.32	57.3575	1281921.0
2011-04-04 12:00:00	QQQ	ETF	57.36	57.4	57.34	57.35	940460.0
2011-04-04 12:30:00	QQQ	ETF	57.34	57.35	57.19	57.2325	1582454.0
2011-04-04 13:00:00	QQQ	ETF	57.239	57.26	57.2	57.23	1039719.0
2011-04-04 13:30:00	QQQ	ETF	57.22	57.2281	57.02	57.06	3937037.0
2011-04-04 14:00:00	QQQ	ETF	57.06	57.15	57.03	57.12	2648542.0
2011-04-04 14:30:00	QQQ	ETF	57.115	57.15	57.11	57.12	1506540.0
2011-04-04 15:00:00	QQQ	ETF	57.1162	57.23	57.02	57.21	3243245.0
2011-04-04 15:30:00	QQQ	ETF	57.2	57.28	57.16	57.28	4326674.0

> showing 50 of 9,325 rows — these rows as CSV

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