PREVIEW / etf_30min / 2011-03-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-07.parquet
  size:    278 KB
  rows:    9,155

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-03-07 07:00:00	SPY	ETF	132.94	133.05	132.81	132.84	535446.0
2011-03-07 07:30:00	SPY	ETF	132.83	132.83	132.33	132.36	636031.0
2011-03-07 08:00:00	SPY	ETF	132.36	132.86	132.25	132.53	859540.0
2011-03-07 08:30:00	SPY	ETF	132.56	132.69	132.51	132.68	537891.0
2011-03-07 09:00:00	SPY	ETF	132.68	132.95	132.67	132.86	1699861.0
2011-03-07 09:30:00	SPY	ETF	132.86	133.1594	132.75	133.03	20707792.0
2011-03-07 10:00:00	SPY	ETF	133.03	133.14	132.51	132.76	11379836.0
2011-03-07 10:30:00	SPY	ETF	132.765	132.81	131.94	132.04	20026183.0
2011-03-07 11:00:00	SPY	ETF	132.04	132.05	131.62	131.66	19133683.0
2011-03-07 11:30:00	SPY	ETF	131.65	131.71	131.17	131.3	19496790.0
2011-03-07 12:00:00	SPY	ETF	131.31	131.55	131.18	131.24	10831969.0
2011-03-07 12:30:00	SPY	ETF	131.25	131.4	130.91	130.96	10201868.0
2011-03-07 13:00:00	SPY	ETF	130.96	131.09	130.735	130.97	10814748.0
2011-03-07 13:30:00	SPY	ETF	130.96	131.19	130.89	131.03	11712892.0
2011-03-07 14:00:00	SPY	ETF	131.02	131.42	130.9	131.2	10392883.0
2011-03-07 14:30:00	SPY	ETF	131.2	131.34	131.07	131.26	8422611.0
2011-03-07 15:00:00	SPY	ETF	131.26	131.67	131.12	131.581	11666726.0
2011-03-07 15:30:00	SPY	ETF	131.57	131.83	131.31	131.41	25355378.0
2011-03-07 16:00:00	SPY	ETF	131.41	131.5637	131.28	131.32	9554778.0
2011-03-07 16:30:00	SPY	ETF	131.32	132.4854	131.27	131.4	11446845.0
2011-03-07 17:00:00	SPY	ETF	131.42	131.47	131.4	131.41	138514.0
2011-03-07 17:30:00	SPY	ETF	131.44	131.44	131.37	131.39	11179.0
2011-03-07 18:00:00	SPY	ETF	131.42	131.49	131.37	131.45	212501.0
2011-03-07 18:30:00	SPY	ETF	131.44	131.64	131.43	131.61	23553.0
2011-03-07 19:00:00	SPY	ETF	131.64	131.7	131.6	131.64	47913.0
2011-03-07 19:30:00	SPY	ETF	131.62	131.62	131.46	131.5	65813.0
2011-03-07 07:00:00	QQQ	ETF	58.3	58.3	58.23	58.23	27325.0
2011-03-07 07:30:00	QQQ	ETF	58.2	58.2	58.0	58.0	120800.0
2011-03-07 08:00:00	QQQ	ETF	58.0	58.11	57.96	58.07	112314.0
2011-03-07 08:30:00	QQQ	ETF	58.09	58.17	58.05	58.17	197899.0
2011-03-07 09:00:00	QQQ	ETF	58.17	58.24	58.15	58.19	330442.0
2011-03-07 09:30:00	QQQ	ETF	58.2	58.2599	57.95	58.06	6402940.0
2011-03-07 10:00:00	QQQ	ETF	58.05	58.09	57.86	57.93	4145473.0
2011-03-07 10:30:00	QQQ	ETF	57.94	57.95	57.39	57.45	7983167.0
2011-03-07 11:00:00	QQQ	ETF	57.45	57.4514	57.18	57.27	10259257.0
2011-03-07 11:30:00	QQQ	ETF	57.27	57.28	56.88	56.98	9790120.0
2011-03-07 12:00:00	QQQ	ETF	56.9825	57.13	56.92	56.92	3664482.0
2011-03-07 12:30:00	QQQ	ETF	56.9206	57.0	56.81	56.84	4174386.0
2011-03-07 13:00:00	QQQ	ETF	56.83	56.87	56.67	56.7899	6023217.0
2011-03-07 13:30:00	QQQ	ETF	56.79	56.915	56.74	56.81	2879930.0
2011-03-07 14:00:00	QQQ	ETF	56.815	57.06	56.79	56.98	4584585.0
2011-03-07 14:30:00	QQQ	ETF	56.9825	57.09	56.92	57.05	4216983.0
2011-03-07 15:00:00	QQQ	ETF	57.045	57.27	56.9801	57.23	3898939.0
2011-03-07 15:30:00	QQQ	ETF	57.2225	57.37	57.17	57.1905	8065144.0
2011-03-07 16:00:00	QQQ	ETF	57.19	57.2441	57.07	57.07	1817353.0
2011-03-07 16:30:00	QQQ	ETF	57.09	57.21	57.08	57.15	2058972.0
2011-03-07 17:00:00	QQQ	ETF	57.13	57.15	57.13	57.13	23200.0
2011-03-07 17:30:00	QQQ	ETF	57.13	57.13	57.09	57.1	51950.0
2011-03-07 18:00:00	QQQ	ETF	57.11	57.19	57.11	57.16	49428.0
2011-03-07 18:30:00	QQQ	ETF	57.15	57.23	57.15	57.23	8422.0

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

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