PREVIEW / etf_30min / 2012-07-19

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-19.parquet
  size:    280 KB
  rows:    9,514

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
2012-07-19 04:00:00	SPY	ETF	137.85	137.85	137.68	137.68	735.0
2012-07-19 04:30:00	SPY	ETF	137.7	137.7	137.46	137.48	7000.0
2012-07-19 05:00:00	SPY	ETF	137.51	137.63	137.51	137.63	1600.0
2012-07-19 05:30:00	SPY	ETF	137.61	137.72	137.6	137.68	52100.0
2012-07-19 06:00:00	SPY	ETF	137.7	137.9	137.7	137.88	28602.0
2012-07-19 06:30:00	SPY	ETF	137.9	138.1	137.84	137.85	59201.0
2012-07-19 07:00:00	SPY	ETF	137.87	137.92	137.7	137.76	110534.0
2012-07-19 07:30:00	SPY	ETF	137.78	137.98	137.78	137.91	199065.0
2012-07-19 08:00:00	SPY	ETF	137.91	138.15	137.78	138.1	696673.0
2012-07-19 08:30:00	SPY	ETF	138.04	138.04	137.75	137.82	2122539.0
2012-07-19 09:00:00	SPY	ETF	137.82	137.87	137.61	137.66	1047070.0
2012-07-19 09:30:00	SPY	ETF	137.65	137.96	137.54	137.92	17616744.0
2012-07-19 10:00:00	SPY	ETF	137.92	137.92	137.21	137.51	17299658.0
2012-07-19 10:30:00	SPY	ETF	137.51	137.74	137.31	137.635	7665438.0
2012-07-19 11:00:00	SPY	ETF	137.65	137.831	137.645	137.76	5819328.0
2012-07-19 11:30:00	SPY	ETF	137.7591	137.88	137.615	137.77	5848537.0
2012-07-19 12:00:00	SPY	ETF	137.77	138.18	137.77	138.06	7731233.0
2012-07-19 12:30:00	SPY	ETF	138.0699	138.1	137.67	137.7099	5325610.0
2012-07-19 13:00:00	SPY	ETF	137.7	137.95	137.7	137.79	5511493.0
2012-07-19 13:30:00	SPY	ETF	137.8	137.82	137.32	137.48	9101724.0
2012-07-19 14:00:00	SPY	ETF	137.47	137.69	137.45	137.57	6130150.0
2012-07-19 14:30:00	SPY	ETF	137.56	137.83	137.48	137.73	5523506.0
2012-07-19 15:00:00	SPY	ETF	137.73	137.82	137.55	137.685	8071871.0
2012-07-19 15:30:00	SPY	ETF	137.69	137.925	137.62	137.71	15309951.0
2012-07-19 16:00:00	SPY	ETF	137.71	137.84	137.392	137.76	7161861.0
2012-07-19 16:30:00	SPY	ETF	137.75	137.8	137.65	137.75	1257902.0
2012-07-19 17:00:00	SPY	ETF	137.74	137.78	137.72	137.73	45084.0
2012-07-19 17:30:00	SPY	ETF	137.75	137.75	137.68	137.72	54390.0
2012-07-19 18:00:00	SPY	ETF	137.73	137.78	137.72	137.76	14754.0
2012-07-19 18:30:00	SPY	ETF	137.76	137.76	137.71	137.72	8900.0
2012-07-19 19:00:00	SPY	ETF	137.71	137.75	137.67	137.67	39615.0
2012-07-19 19:30:00	SPY	ETF	137.71	137.73	137.68	137.68	37500.0
2012-07-19 06:00:00	QQQ	ETF	64.7	64.75	64.7	64.74	3200.0
2012-07-19 06:30:00	QQQ	ETF	64.77	64.8	64.77	64.8	1600.0
2012-07-19 07:00:00	QQQ	ETF	64.73	64.77	64.67	64.71	31215.0
2012-07-19 07:30:00	QQQ	ETF	64.71	64.79	64.71	64.77	14285.0
2012-07-19 08:00:00	QQQ	ETF	64.78	64.87	64.75	64.85	180101.0
2012-07-19 08:30:00	QQQ	ETF	64.82	64.85	64.75	64.8	236229.0
2012-07-19 09:00:00	QQQ	ETF	64.8	64.9	64.78	64.84	380877.0
2012-07-19 09:30:00	QQQ	ETF	64.84	65.06	64.77	64.99	8224529.0
2012-07-19 10:00:00	QQQ	ETF	64.99	65.0	64.72	64.863	4742757.0
2012-07-19 10:30:00	QQQ	ETF	64.865	65.03	64.75	64.96	1960716.0
2012-07-19 11:00:00	QQQ	ETF	64.97	65.12	64.97	65.09	2006103.0
2012-07-19 11:30:00	QQQ	ETF	65.08	65.14	64.99	65.08	1649103.0
2012-07-19 12:00:00	QQQ	ETF	65.09	65.31	65.08	65.27	3850367.0
2012-07-19 12:30:00	QQQ	ETF	65.27	65.3	65.12	65.14	1816375.0
2012-07-19 13:00:00	QQQ	ETF	65.13	65.26	65.13	65.2	1091027.0
2012-07-19 13:30:00	QQQ	ETF	65.2	65.2	64.88	64.98	3401180.0
2012-07-19 14:00:00	QQQ	ETF	64.99	65.15	64.99	65.08	1021956.0
2012-07-19 14:30:00	QQQ	ETF	65.07	65.19	65.01	65.13	2072133.0

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

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