PREVIEW / etf_30min / 2011-01-13

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-13.parquet
  size:    274 KB
  rows:    9,294

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-01-13 04:00:00	SPY	ETF	128.54	128.58	128.54	128.58	400.0
2011-01-13 04:30:00	SPY	ETF	128.72	128.72	128.21	128.21	4350.0
2011-01-13 05:00:00	SPY	ETF	128.62	128.65	128.53	128.53	10500.0
2011-01-13 05:30:00	SPY	ETF	128.51	128.52	128.51	128.51	10200.0
2011-01-13 06:00:00	SPY	ETF	128.55	128.55	128.55	128.55	1000.0
2011-01-13 06:30:00	SPY	ETF	128.65	128.7	128.65	128.7	2300.0
2011-01-13 07:00:00	SPY	ETF	128.65	128.74	128.61	128.7	58850.0
2011-01-13 07:30:00	SPY	ETF	128.69	128.83	128.68	128.76	57440.0
2011-01-13 08:00:00	SPY	ETF	128.75	128.84	128.65	128.71	247761.0
2011-01-13 08:30:00	SPY	ETF	128.7	128.7	128.31	128.43	1552692.0
2011-01-13 09:00:00	SPY	ETF	128.435	128.63	128.43	128.63	653707.0
2011-01-13 09:30:00	SPY	ETF	128.63	128.66	128.38	128.53	11753454.0
2011-01-13 10:00:00	SPY	ETF	128.53	128.55	128.17	128.34	11216880.0
2011-01-13 10:30:00	SPY	ETF	128.34	128.51	128.27	128.46	8460054.0
2011-01-13 11:00:00	SPY	ETF	128.47	128.61	128.42	128.55	5399968.0
2011-01-13 11:30:00	SPY	ETF	128.55	128.69	128.51	128.55	4401516.0
2011-01-13 12:00:00	SPY	ETF	128.55	128.69	128.53	128.58	3728865.0
2011-01-13 12:30:00	SPY	ETF	128.58	128.6	128.48	128.53	4148888.0
2011-01-13 13:00:00	SPY	ETF	128.525	128.62	128.38	128.55	6667603.0
2011-01-13 13:30:00	SPY	ETF	128.55	128.6	128.46	128.48	3651060.0
2011-01-13 14:00:00	SPY	ETF	128.48	128.5101	128.25	128.36	10347747.0
2011-01-13 14:30:00	SPY	ETF	128.36	128.42	128.13	128.18	9478499.0
2011-01-13 15:00:00	SPY	ETF	128.18	128.38	128.13	128.16	8990883.0
2011-01-13 15:30:00	SPY	ETF	128.16	128.47	128.05	128.42	16859133.0
2011-01-13 16:00:00	SPY	ETF	128.42	128.74	128.1926	128.53	10439082.0
2011-01-13 16:30:00	SPY	ETF	128.53	128.65	128.5	128.64	8507454.0
2011-01-13 17:00:00	SPY	ETF	128.66	128.83	128.6077	128.8	804787.0
2011-01-13 17:30:00	SPY	ETF	128.79	128.83	128.74	128.74	37885.0
2011-01-13 18:00:00	SPY	ETF	128.76	128.78	128.45	128.73	85764.0
2011-01-13 18:30:00	SPY	ETF	128.73	128.8	128.67	128.7	90326.0
2011-01-13 19:00:00	SPY	ETF	128.68	128.68	128.62	128.66	54300.0
2011-01-13 19:30:00	SPY	ETF	128.66	128.66	128.61	128.63	24380.0
2011-01-13 06:30:00	QQQ	ETF	56.59	56.59	56.59	56.59	100.0
2011-01-13 07:00:00	QQQ	ETF	56.62	56.63	56.61	56.61	12200.0
2011-01-13 07:30:00	QQQ	ETF	56.61	56.68	56.61	56.66	11900.0
2011-01-13 08:00:00	QQQ	ETF	56.66	56.67	56.6	56.61	53697.0
2011-01-13 08:30:00	QQQ	ETF	56.6	56.61	56.48	56.52	464165.0
2011-01-13 09:00:00	QQQ	ETF	56.52	56.59	56.52	56.59	167386.0
2011-01-13 09:30:00	QQQ	ETF	56.59	56.6	56.44	56.545	7543462.0
2011-01-13 10:00:00	QQQ	ETF	56.55	56.63	56.48	56.62	5358858.0
2011-01-13 10:30:00	QQQ	ETF	56.615	56.71	56.58	56.68	4112934.0
2011-01-13 11:00:00	QQQ	ETF	56.685	56.7	56.65	56.68	2040587.0
2011-01-13 11:30:00	QQQ	ETF	56.685	56.73	56.61	56.62	2887433.0
2011-01-13 12:00:00	QQQ	ETF	56.61	56.7	56.61	56.6581	1086457.0
2011-01-13 12:30:00	QQQ	ETF	56.65	56.67	56.61	56.64	1323837.0
2011-01-13 13:00:00	QQQ	ETF	56.64	56.7	56.58	56.649	2646260.0
2011-01-13 13:30:00	QQQ	ETF	56.65	56.67	56.62	56.62	1113345.0
2011-01-13 14:00:00	QQQ	ETF	56.63	56.65	56.56	56.6011	1523259.0
2011-01-13 14:30:00	QQQ	ETF	56.62	56.62	56.46	56.4896	2147448.0
2011-01-13 15:00:00	QQQ	ETF	56.4819	56.58	56.47	56.48	2790241.0

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

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