PREVIEW / etf_30min / 2011-05-09

all etf 30-min files

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

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-05-09 04:00:00	SPY	ETF	134.54	134.96	134.54	134.8	5200.0
2011-05-09 04:30:00	SPY	ETF	134.83	134.83	134.43	134.58	22315.0
2011-05-09 05:00:00	SPY	ETF	134.53	134.58	134.41	134.58	300.0
2011-05-09 05:30:00	SPY	ETF	134.54	134.54	134.54	134.54	200.0
2011-05-09 06:00:00	SPY	ETF	134.51	134.6	134.5	134.5	7700.0
2011-05-09 06:30:00	SPY	ETF	134.47	134.6	134.38	134.51	71639.0
2011-05-09 07:00:00	SPY	ETF	134.5	134.64	134.47	134.5	131700.0
2011-05-09 07:30:00	SPY	ETF	134.51	134.51	134.34	134.35	239625.0
2011-05-09 08:00:00	SPY	ETF	134.28	134.47	134.09	134.18	1123337.0
2011-05-09 08:30:00	SPY	ETF	134.18	134.3	133.94	134.06	1236241.0
2011-05-09 09:00:00	SPY	ETF	134.06	134.22	134.02	134.19	831741.0
2011-05-09 09:30:00	SPY	ETF	134.19	134.45	134.08	134.13	13631465.0
2011-05-09 10:00:00	SPY	ETF	134.14	134.49	134.01	134.16	13042155.0
2011-05-09 10:30:00	SPY	ETF	134.16	134.37	133.98	134.28	9317464.0
2011-05-09 11:00:00	SPY	ETF	134.28	134.38	134.19	134.29	6000311.0
2011-05-09 11:30:00	SPY	ETF	134.29	134.61	134.17	134.555	5369920.0
2011-05-09 12:00:00	SPY	ETF	134.56	135.09	134.53	134.85	14687077.0
2011-05-09 12:30:00	SPY	ETF	134.85	134.97	134.76	134.78	4421774.0
2011-05-09 13:00:00	SPY	ETF	134.77	134.91	134.73	134.76	4901942.0
2011-05-09 13:30:00	SPY	ETF	134.76	134.98	134.76	134.93	2774642.0
2011-05-09 14:00:00	SPY	ETF	134.94	134.97	134.8	134.85	4432577.0
2011-05-09 14:30:00	SPY	ETF	134.855	135.11	134.78	134.82	6712150.0
2011-05-09 15:00:00	SPY	ETF	134.81	134.975	134.81	134.86	3944735.0
2011-05-09 15:30:00	SPY	ETF	134.86	134.97	134.73	134.73	14275797.0
2011-05-09 16:00:00	SPY	ETF	134.73	134.847	134.5855	134.74	5692656.0
2011-05-09 16:30:00	SPY	ETF	134.74	134.89	134.71	134.85	246490.0
2011-05-09 17:00:00	SPY	ETF	134.86	134.86	134.79	134.81	14600.0
2011-05-09 17:30:00	SPY	ETF	134.77	134.79	134.73	134.73	35133.0
2011-05-09 18:00:00	SPY	ETF	134.75	134.8	134.72	134.75	111985.0
2011-05-09 18:30:00	SPY	ETF	134.75	134.84	134.75	134.8	29652.0
2011-05-09 19:00:00	SPY	ETF	134.77	134.81	134.77	134.79	15718.0
2011-05-09 19:30:00	SPY	ETF	134.79	134.87	134.79	134.86	76609.0
2011-05-09 04:00:00	QQQ	ETF	58.82	58.85	58.8	58.8	929.0
2011-05-09 04:30:00	QQQ	ETF	58.77	58.78	58.68	58.71	800.0
2011-05-09 05:30:00	QQQ	ETF	58.6	58.6	58.6	58.6	100.0
2011-05-09 06:30:00	QQQ	ETF	58.69	58.69	58.69	58.69	1000.0
2011-05-09 07:00:00	QQQ	ETF	58.68	58.71	58.68	58.69	15400.0
2011-05-09 07:30:00	QQQ	ETF	58.66	58.66	58.62	58.62	5200.0
2011-05-09 08:00:00	QQQ	ETF	58.62	58.65	58.5	58.53	93419.0
2011-05-09 08:30:00	QQQ	ETF	58.53	58.59	58.47	58.49	182639.0
2011-05-09 09:00:00	QQQ	ETF	58.5	58.83	58.47	58.56	146003.0
2011-05-09 09:30:00	QQQ	ETF	58.56	58.57	58.38	58.46	5098203.0
2011-05-09 10:00:00	QQQ	ETF	58.46	58.64	58.36	58.42	3888879.0
2011-05-09 10:30:00	QQQ	ETF	58.42	58.57	58.34	58.523	3646910.0
2011-05-09 11:00:00	QQQ	ETF	58.53	58.58	58.481	58.525	3251041.0
2011-05-09 11:30:00	QQQ	ETF	58.53	58.74	58.47	58.725	2422468.0
2011-05-09 12:00:00	QQQ	ETF	58.73	58.91	58.72	58.81	4387626.0
2011-05-09 12:30:00	QQQ	ETF	58.81	58.89	58.73	58.74	3076603.0
2011-05-09 13:00:00	QQQ	ETF	58.74	58.82	58.73	58.77	1532488.0
2011-05-09 13:30:00	QQQ	ETF	58.77	58.88	58.767	58.847	607156.0

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

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