PREVIEW / etf_30min / 2011-06-09

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-09.parquet
  size:    276 KB
  rows:    9,109

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-06-09 04:00:00	SPY	ETF	128.87	128.87	128.74	128.74	7788.0
2011-06-09 04:30:00	SPY	ETF	128.89	128.89	128.89	128.89	150.0
2011-06-09 05:00:00	SPY	ETF	128.6	128.6	128.4	128.45	1300.0
2011-06-09 05:30:00	SPY	ETF	128.54	128.66	128.54	128.66	800.0
2011-06-09 06:00:00	SPY	ETF	128.6	128.65	128.6	128.65	200.0
2011-06-09 06:30:00	SPY	ETF	128.66	128.73	128.6	128.73	5750.0
2011-06-09 07:00:00	SPY	ETF	128.67	128.81	128.59	128.8	286500.0
2011-06-09 07:30:00	SPY	ETF	128.77	128.81	128.69	128.77	130900.0
2011-06-09 08:00:00	SPY	ETF	128.77	128.77	128.61	128.62	1229426.0
2011-06-09 08:30:00	SPY	ETF	128.62	128.95	128.46	128.67	3880260.0
2011-06-09 09:00:00	SPY	ETF	128.68	128.86	128.67	128.77	2349332.0
2011-06-09 09:30:00	SPY	ETF	128.77	129.06	128.46	129.035	20503020.0
2011-06-09 10:00:00	SPY	ETF	129.04	129.33	129.03	129.2	14057115.0
2011-06-09 10:30:00	SPY	ETF	129.19	129.54	129.15	129.41	10992143.0
2011-06-09 11:00:00	SPY	ETF	129.39	129.48	129.2	129.3	7954788.0
2011-06-09 11:30:00	SPY	ETF	129.3	129.72	129.28	129.6167	7728009.0
2011-06-09 12:00:00	SPY	ETF	129.61	129.81	129.57	129.61	8079939.0
2011-06-09 12:30:00	SPY	ETF	129.605	129.72	129.51	129.62	4713510.0
2011-06-09 13:00:00	SPY	ETF	129.61	129.75	129.61	129.64	3859610.0
2011-06-09 13:30:00	SPY	ETF	129.64	129.79	129.57	129.7	5826974.0
2011-06-09 14:00:00	SPY	ETF	129.695	129.83	129.65	129.75	4107106.0
2011-06-09 14:30:00	SPY	ETF	129.75	129.93	129.63	129.91	5484359.0
2011-06-09 15:00:00	SPY	ETF	129.92	129.93	129.65	129.71	7604945.0
2011-06-09 15:30:00	SPY	ETF	129.7	129.74	129.34	129.37	26075751.0
2011-06-09 16:00:00	SPY	ETF	129.37	129.5286	129.22	129.3	18335098.0
2011-06-09 16:30:00	SPY	ETF	129.33	129.3825	129.23	129.27	948146.0
2011-06-09 17:00:00	SPY	ETF	129.28	129.34	129.25	129.29	58711.0
2011-06-09 17:30:00	SPY	ETF	129.3	129.35	129.3	129.32	12893.0
2011-06-09 18:00:00	SPY	ETF	129.3	129.4	129.26	129.38	187683.0
2011-06-09 18:30:00	SPY	ETF	129.37	129.41	129.36	129.36	29646.0
2011-06-09 19:00:00	SPY	ETF	129.36	129.37	129.35	129.37	13452.0
2011-06-09 19:30:00	SPY	ETF	129.35	129.37	129.25	129.29	59169.0
2011-06-09 04:00:00	QQQ	ETF	55.35	55.46	55.35	55.46	900.0
2011-06-09 05:00:00	QQQ	ETF	55.37	55.37	55.37	55.37	800.0
2011-06-09 06:00:00	QQQ	ETF	55.35	55.37	55.3	55.37	6040.0
2011-06-09 06:30:00	QQQ	ETF	55.37	55.46	55.37	55.44	3400.0
2011-06-09 07:00:00	QQQ	ETF	55.38	55.46	55.38	55.46	7230.0
2011-06-09 07:30:00	QQQ	ETF	55.44	55.46	55.44	55.45	5200.0
2011-06-09 08:00:00	QQQ	ETF	55.45	55.46	55.38	55.43	110499.0
2011-06-09 08:30:00	QQQ	ETF	55.41	55.5	55.32	55.4	483695.0
2011-06-09 09:00:00	QQQ	ETF	55.41	55.46	55.36	55.37	446634.0
2011-06-09 09:30:00	QQQ	ETF	55.38	55.42	55.23	55.42	5070001.0
2011-06-09 10:00:00	QQQ	ETF	55.41	55.52	55.38	55.45	4282573.0
2011-06-09 10:30:00	QQQ	ETF	55.44	55.57	55.4311	55.52	4732860.0
2011-06-09 11:00:00	QQQ	ETF	55.52	55.57	55.41	55.45	3140555.0
2011-06-09 11:30:00	QQQ	ETF	55.45	55.575	55.45	55.53	1121621.0
2011-06-09 12:00:00	QQQ	ETF	55.53	55.63	55.51	55.555	1323674.0
2011-06-09 12:30:00	QQQ	ETF	55.55	55.66	55.53	55.61	1369264.0
2011-06-09 13:00:00	QQQ	ETF	55.605	55.66	55.59	55.6	1419034.0
2011-06-09 13:30:00	QQQ	ETF	55.61	55.66	55.57	55.6105	880617.0

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

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