PREVIEW / etf_30min / 2011-05-03

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-03.parquet
  size:    290 KB
  rows:    9,618

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-03 04:00:00	SPY	ETF	135.96	136.08	135.91	135.95	2200.0
2011-05-03 04:30:00	SPY	ETF	135.99	135.99	135.87	135.94	2100.0
2011-05-03 05:00:00	SPY	ETF	135.88	135.88	135.86	135.86	200.0
2011-05-03 05:30:00	SPY	ETF	135.78	135.95	135.64	135.66	4300.0
2011-05-03 06:00:00	SPY	ETF	135.72	135.72	135.66	135.72	4120.0
2011-05-03 06:30:00	SPY	ETF	135.64	135.66	135.49	135.49	135200.0
2011-05-03 07:00:00	SPY	ETF	135.52	135.72	135.46	135.65	200941.0
2011-05-03 07:30:00	SPY	ETF	135.65	135.67	135.54	135.54	182588.0
2011-05-03 08:00:00	SPY	ETF	135.55	135.81	135.47	135.75	528684.0
2011-05-03 08:30:00	SPY	ETF	135.76	135.88	135.74	135.85	625212.0
2011-05-03 09:00:00	SPY	ETF	135.85	136.25	135.79	135.95	1796016.0
2011-05-03 09:30:00	SPY	ETF	135.96	136.15	135.67	136.06	16313708.0
2011-05-03 10:00:00	SPY	ETF	136.07	136.19	135.87	135.95	11117679.0
2011-05-03 10:30:00	SPY	ETF	135.955	136.0	135.6	135.7	11875475.0
2011-05-03 11:00:00	SPY	ETF	135.695	136.035	135.66	135.94	6843374.0
2011-05-03 11:30:00	SPY	ETF	135.94	136.16	135.92	136.04	4431438.0
2011-05-03 12:00:00	SPY	ETF	136.05	136.14	135.95	135.95	3118285.0
2011-05-03 12:30:00	SPY	ETF	135.96	135.985	135.71	135.73	4245692.0
2011-05-03 13:00:00	SPY	ETF	135.73	135.82	135.54	135.545	6231868.0
2011-05-03 13:30:00	SPY	ETF	135.54	135.66	135.32	135.47	10374120.0
2011-05-03 14:00:00	SPY	ETF	135.47	135.48	135.13	135.37	9885777.0
2011-05-03 14:30:00	SPY	ETF	135.37	135.43	135.045	135.16	8434374.0
2011-05-03 15:00:00	SPY	ETF	135.16	135.59	135.15	135.5301	8901171.0
2011-05-03 15:30:00	SPY	ETF	135.53	135.81	135.43	135.72	21942074.0
2011-05-03 16:00:00	SPY	ETF	135.72	135.78	135.53	135.6	8757287.0
2011-05-03 16:30:00	SPY	ETF	135.6	135.64	135.46	135.51	1446498.0
2011-05-03 17:00:00	SPY	ETF	135.53	135.56	135.45	135.45	186264.0
2011-05-03 17:30:00	SPY	ETF	135.46	135.54	135.45	135.51	55497.0
2011-05-03 18:00:00	SPY	ETF	135.51	135.71	135.33	135.4	147438.0
2011-05-03 18:30:00	SPY	ETF	135.42	135.43	135.39	135.39	22800.0
2011-05-03 19:00:00	SPY	ETF	135.39	135.39	135.3	135.34	26370.0
2011-05-03 19:30:00	SPY	ETF	135.34	135.63	135.32	135.63	96059.0
2011-05-03 04:00:00	QQQ	ETF	58.9	58.9	58.9	58.9	200.0
2011-05-03 05:30:00	QQQ	ETF	58.8	58.83	58.8	58.83	30000.0
2011-05-03 06:00:00	QQQ	ETF	58.8	58.82	58.8	58.82	1400.0
2011-05-03 06:30:00	QQQ	ETF	58.8	58.8	58.76	58.76	1500.0
2011-05-03 07:00:00	QQQ	ETF	58.76	58.82	58.75	58.8	11050.0
2011-05-03 07:30:00	QQQ	ETF	58.8	58.82	58.76	58.77	24700.0
2011-05-03 08:00:00	QQQ	ETF	58.78	58.89	58.77	58.88	51920.0
2011-05-03 08:30:00	QQQ	ETF	58.89	58.92	58.87	58.91	124767.0
2011-05-03 09:00:00	QQQ	ETF	58.91	58.97	58.88	58.95	197042.0
2011-05-03 09:30:00	QQQ	ETF	58.95	59.0	58.75	58.93	3550879.0
2011-05-03 10:00:00	QQQ	ETF	58.93	58.98	58.78	58.81	2595114.0
2011-05-03 10:30:00	QQQ	ETF	58.8	58.82	58.68	58.758	2705311.0
2011-05-03 11:00:00	QQQ	ETF	58.75	58.88	58.72	58.83	1477183.0
2011-05-03 11:30:00	QQQ	ETF	58.831	58.89	58.81	58.8388	972334.0
2011-05-03 12:00:00	QQQ	ETF	58.83	58.85	58.71	58.71	1742792.0
2011-05-03 12:30:00	QQQ	ETF	58.71	58.7299	58.541	58.56	1657203.0
2011-05-03 13:00:00	QQQ	ETF	58.5599	58.64	58.45	58.46	1632863.0
2011-05-03 13:30:00	QQQ	ETF	58.46	58.51	58.35	58.48	2523765.0

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

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