PREVIEW / etf_30min / 2011-07-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-07.parquet
  size:    285 KB
  rows:    9,670

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-07-07 04:00:00	SPY	ETF	134.38	134.48	134.38	134.48	1400.0
2011-07-07 04:30:00	SPY	ETF	134.41	134.41	134.41	134.41	100.0
2011-07-07 05:00:00	SPY	ETF	134.45	134.57	134.45	134.52	300.0
2011-07-07 05:30:00	SPY	ETF	134.54	134.54	134.45	134.45	300.0
2011-07-07 06:00:00	SPY	ETF	134.4	134.4	134.32	134.32	2500.0
2011-07-07 06:30:00	SPY	ETF	134.3	134.42	134.3	134.35	3100.0
2011-07-07 07:00:00	SPY	ETF	134.42	134.52	134.39	134.52	47796.0
2011-07-07 07:30:00	SPY	ETF	134.47	134.6	134.43	134.49	387950.0
2011-07-07 08:00:00	SPY	ETF	134.47	135.2	134.3802	135.01	3242520.0
2011-07-07 08:30:00	SPY	ETF	135.04	135.4	133.95	135.25	2946588.0
2011-07-07 09:00:00	SPY	ETF	135.25	135.31	135.11	135.15	1628984.0
2011-07-07 09:30:00	SPY	ETF	135.16	135.17	134.88	135.05	18995775.0
2011-07-07 10:00:00	SPY	ETF	135.06	135.19	134.94	135.11	10342333.0
2011-07-07 10:30:00	SPY	ETF	135.11	135.29	135.06	135.24	10005956.0
2011-07-07 11:00:00	SPY	ETF	135.23	135.23	135.05	135.11	12993550.0
2011-07-07 11:30:00	SPY	ETF	135.105	135.15	135.0	135.1	7578177.0
2011-07-07 12:00:00	SPY	ETF	135.11	135.3	135.06	135.23	6574160.0
2011-07-07 12:30:00	SPY	ETF	135.23	135.32	135.19	135.24	7068933.0
2011-07-07 13:00:00	SPY	ETF	135.24	135.47	135.19	135.44	6932519.0
2011-07-07 13:30:00	SPY	ETF	135.44	135.48	135.36	135.38	5473668.0
2011-07-07 14:00:00	SPY	ETF	135.37	135.69	135.37	135.64	8482399.0
2011-07-07 14:30:00	SPY	ETF	135.65	135.7	135.57	135.61	6667963.0
2011-07-07 15:00:00	SPY	ETF	135.6	135.69	135.51	135.52	7889389.0
2011-07-07 15:30:00	SPY	ETF	135.5101	135.57	135.33	135.4	26641936.0
2011-07-07 16:00:00	SPY	ETF	135.42	135.64	135.2858	135.57	15200498.0
2011-07-07 16:30:00	SPY	ETF	135.58	135.65	133.9589	135.57	5919761.0
2011-07-07 17:00:00	SPY	ETF	135.57	135.64	133.9589	135.61	920356.0
2011-07-07 17:30:00	SPY	ETF	135.61	135.64	135.55	135.59	160429.0
2011-07-07 18:00:00	SPY	ETF	135.58	135.59	135.36	135.55	386339.0
2011-07-07 18:30:00	SPY	ETF	135.55	135.59	135.5	135.56	63737.0
2011-07-07 19:00:00	SPY	ETF	135.53	135.55	135.49	135.5	22150.0
2011-07-07 19:30:00	SPY	ETF	135.51	135.58	135.51	135.54	38219.0
2011-07-07 04:00:00	QQQ	ETF	58.48	58.48	58.48	58.48	100.0
2011-07-07 05:00:00	QQQ	ETF	58.58	58.58	58.58	58.58	100.0
2011-07-07 07:00:00	QQQ	ETF	58.55	58.58	58.5	58.58	4000.0
2011-07-07 07:30:00	QQQ	ETF	58.51	58.58	58.51	58.54	109682.0
2011-07-07 08:00:00	QQQ	ETF	58.52	58.82	58.5	58.76	867940.0
2011-07-07 08:30:00	QQQ	ETF	58.76	58.94	58.69	58.85	547276.0
2011-07-07 09:00:00	QQQ	ETF	58.85	58.85	58.76	58.83	435854.0
2011-07-07 09:30:00	QQQ	ETF	58.82	58.91	58.75	58.86	5762983.0
2011-07-07 10:00:00	QQQ	ETF	58.86	58.96	58.74	58.935	4570163.0
2011-07-07 10:30:00	QQQ	ETF	58.935	59.05	58.92	59.03	2503972.0
2011-07-07 11:00:00	QQQ	ETF	59.03	59.04	58.98	59.01	3296104.0
2011-07-07 11:30:00	QQQ	ETF	59.0198	59.08	58.98	59.06	2395099.0
2011-07-07 12:00:00	QQQ	ETF	59.07	59.14	59.03	59.12	1900772.0
2011-07-07 12:30:00	QQQ	ETF	59.12	59.15	59.07	59.14	2123814.0
2011-07-07 13:00:00	QQQ	ETF	59.14	59.23	59.11	59.18	2094528.0
2011-07-07 13:30:00	QQQ	ETF	59.19	59.22	59.15	59.17	1510820.0
2011-07-07 14:00:00	QQQ	ETF	59.165	59.34	59.165	59.32	3276476.0
2011-07-07 14:30:00	QQQ	ETF	59.32	59.36	59.29	59.31	3140428.0

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

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