PREVIEW / etf_30min / 2011-02-16

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-16.parquet
  size:    270 KB
  rows:    9,216

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-02-16 04:00:00	SPY	ETF	132.9	133.65	132.9	133.63	6238.0
2011-02-16 04:30:00	SPY	ETF	133.59	133.61	133.58	133.58	700.0
2011-02-16 05:00:00	SPY	ETF	133.56	133.56	133.56	133.56	200.0
2011-02-16 05:30:00	SPY	ETF	133.57	133.59	133.55	133.55	700.0
2011-02-16 06:30:00	SPY	ETF	133.5	133.53	133.5	133.52	2200.0
2011-02-16 07:00:00	SPY	ETF	133.5	133.51	133.44	133.51	56800.0
2011-02-16 07:30:00	SPY	ETF	133.48	133.52	133.44	133.52	264260.0
2011-02-16 08:00:00	SPY	ETF	133.52	133.79	133.47	133.54	468948.0
2011-02-16 08:30:00	SPY	ETF	133.55	133.63	133.46	133.47	767033.0
2011-02-16 09:00:00	SPY	ETF	133.47	133.5	133.38	133.46	815371.0
2011-02-16 09:30:00	SPY	ETF	133.46	133.65	133.41	133.6362	12492669.0
2011-02-16 10:00:00	SPY	ETF	133.64	133.82	133.44	133.721	9462442.0
2011-02-16 10:30:00	SPY	ETF	133.73	134.01	133.72	133.99	11326801.0
2011-02-16 11:00:00	SPY	ETF	133.98	134.01	133.725	133.74	8446691.0
2011-02-16 11:30:00	SPY	ETF	133.74	133.82	133.59	133.75	9168197.0
2011-02-16 12:00:00	SPY	ETF	133.75	133.77	133.19	133.465	15049567.0
2011-02-16 12:30:00	SPY	ETF	133.46	133.61	133.43	133.6	7204294.0
2011-02-16 13:00:00	SPY	ETF	133.6	133.66	133.49	133.54	5564948.0
2011-02-16 13:30:00	SPY	ETF	133.5401	133.79	133.54	133.78	5845563.0
2011-02-16 14:00:00	SPY	ETF	133.79	133.8	133.5	133.54	6974775.0
2011-02-16 14:30:00	SPY	ETF	133.55	133.89	133.54	133.78	8369842.0
2011-02-16 15:00:00	SPY	ETF	133.78	133.92	133.75	133.785	5585293.0
2011-02-16 15:30:00	SPY	ETF	133.79	133.96	133.76	133.83	13647711.0
2011-02-16 16:00:00	SPY	ETF	133.82	133.91	133.68	133.7	7490432.0
2011-02-16 16:30:00	SPY	ETF	133.72	133.91	133.63	133.76	462046.0
2011-02-16 17:00:00	SPY	ETF	133.74	133.76	133.65	133.7	98516.0
2011-02-16 17:30:00	SPY	ETF	133.69	133.72	133.6	133.69	59788.0
2011-02-16 18:00:00	SPY	ETF	133.68	133.82	133.66	133.68	98508.0
2011-02-16 18:30:00	SPY	ETF	133.67	133.72	133.67	133.7	20312.0
2011-02-16 19:00:00	SPY	ETF	133.71	133.71	133.66	133.68	17901.0
2011-02-16 19:30:00	SPY	ETF	133.69	133.7	133.66	133.67	17833.0
2011-02-16 04:00:00	QQQ	ETF	58.69	58.69	58.67	58.67	400.0
2011-02-16 04:30:00	QQQ	ETF	58.7	58.71	58.67	58.68	6088.0
2011-02-16 05:00:00	QQQ	ETF	58.69	58.69	58.65	58.68	4000.0
2011-02-16 05:30:00	QQQ	ETF	58.68	58.68	58.68	58.68	200.0
2011-02-16 06:00:00	QQQ	ETF	58.62	58.62	58.62	58.62	100.0
2011-02-16 07:00:00	QQQ	ETF	58.66	58.66	58.64	58.64	14480.0
2011-02-16 07:30:00	QQQ	ETF	58.65	58.66	58.63	58.63	75382.0
2011-02-16 08:00:00	QQQ	ETF	58.65	58.79	58.65	58.69	131579.0
2011-02-16 08:30:00	QQQ	ETF	58.7	58.71	58.65	58.67	247886.0
2011-02-16 09:00:00	QQQ	ETF	58.67	58.69	58.62	58.65	565129.0
2011-02-16 09:30:00	QQQ	ETF	58.64	58.78	58.64	58.75	6177943.0
2011-02-16 10:00:00	QQQ	ETF	58.74	58.91	58.68	58.8638	5035983.0
2011-02-16 10:30:00	QQQ	ETF	58.87	59.03	58.86	59.025	4977327.0
2011-02-16 11:00:00	QQQ	ETF	59.03	59.04	58.88	58.9	3751772.0
2011-02-16 11:30:00	QQQ	ETF	58.9	58.96	58.845	58.92	4654090.0
2011-02-16 12:00:00	QQQ	ETF	58.92	58.93	58.63	58.74	4875846.0
2011-02-16 12:30:00	QQQ	ETF	58.74	58.83	58.72	58.82	1324712.0
2011-02-16 13:00:00	QQQ	ETF	58.82	58.845	58.76	58.775	1281023.0
2011-02-16 13:30:00	QQQ	ETF	58.78	58.93	58.775	58.92	1137171.0

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

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