PREVIEW / etf_30min / 2011-05-25

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-25.parquet
  size:    275 KB
  rows:    9,136

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-25 04:00:00	SPY	ETF	131.42	131.42	131.32	131.34	1100.0
2011-05-25 04:30:00	SPY	ETF	131.46	131.58	131.46	131.5	700.0
2011-05-25 05:00:00	SPY	ETF	131.6	131.73	131.59	131.59	1100.0
2011-05-25 05:30:00	SPY	ETF	131.72	131.76	131.72	131.72	3416.0
2011-05-25 06:00:00	SPY	ETF	131.74	131.74	131.53	131.7	29908.0
2011-05-25 06:30:00	SPY	ETF	131.69	131.81	131.24	131.55	54730.0
2011-05-25 07:00:00	SPY	ETF	131.62	131.77	131.56	131.69	111135.0
2011-05-25 07:30:00	SPY	ETF	131.66	131.81	131.58	131.81	312270.0
2011-05-25 08:00:00	SPY	ETF	131.78	131.88	131.5	131.51	889427.0
2011-05-25 08:30:00	SPY	ETF	131.51	131.7	131.28	131.51	1568339.0
2011-05-25 09:00:00	SPY	ETF	131.51	131.95	131.19	131.42	2382795.0
2011-05-25 09:30:00	SPY	ETF	131.42	132.02	131.38	131.805	20157524.0
2011-05-25 10:00:00	SPY	ETF	131.8	131.97	131.56	131.93	10948375.0
2011-05-25 10:30:00	SPY	ETF	131.92	132.27	131.83	132.08	14104576.0
2011-05-25 11:00:00	SPY	ETF	132.08	132.42	132.06	132.26	9962308.0
2011-05-25 11:30:00	SPY	ETF	132.26	132.61	132.25	132.4	9192243.0
2011-05-25 12:00:00	SPY	ETF	132.4	132.47	132.31	132.36	4259358.0
2011-05-25 12:30:00	SPY	ETF	132.36	132.45	132.24	132.42	3825389.0
2011-05-25 13:00:00	SPY	ETF	132.42	132.46	132.17	132.18	5103306.0
2011-05-25 13:30:00	SPY	ETF	132.175	132.37	132.16	132.25	5204576.0
2011-05-25 14:00:00	SPY	ETF	132.24	132.52	132.2	132.4965	4747500.0
2011-05-25 14:30:00	SPY	ETF	132.5	132.52	132.33	132.45	5836396.0
2011-05-25 15:00:00	SPY	ETF	132.46	132.94	132.405	132.82	18967005.0
2011-05-25 15:30:00	SPY	ETF	132.82	132.82	132.36	132.38	17621356.0
2011-05-25 16:00:00	SPY	ETF	132.37	132.5811	132.14	132.16	9397084.0
2011-05-25 16:30:00	SPY	ETF	132.16	132.78	132.09	132.14	4512512.0
2011-05-25 17:00:00	SPY	ETF	132.13	132.17	132.12	132.15	338747.0
2011-05-25 17:30:00	SPY	ETF	132.15	132.18	132.12	132.15	45176.0
2011-05-25 18:00:00	SPY	ETF	132.17	132.37	132.17	132.17	93774.0
2011-05-25 18:30:00	SPY	ETF	132.18	132.25	132.18	132.25	48223.0
2011-05-25 19:00:00	SPY	ETF	132.27	132.28	132.24	132.28	14750.0
2011-05-25 19:30:00	SPY	ETF	132.23	132.23	132.09	132.09	49231.0
2011-05-25 05:30:00	QQQ	ETF	56.6	56.61	56.6	56.61	25000.0
2011-05-25 06:30:00	QQQ	ETF	56.43	56.55	56.43	56.53	40000.0
2011-05-25 07:00:00	QQQ	ETF	56.52	56.58	56.49	56.53	22000.0
2011-05-25 07:30:00	QQQ	ETF	56.51	56.59	56.5	56.59	243795.0
2011-05-25 08:00:00	QQQ	ETF	56.57	56.59	56.47	56.48	415468.0
2011-05-25 08:30:00	QQQ	ETF	56.42	56.55	56.41	56.49	177370.0
2011-05-25 09:00:00	QQQ	ETF	56.49	56.51	56.37	56.48	393592.0
2011-05-25 09:30:00	QQQ	ETF	56.49	56.74	56.47	56.66	5802108.0
2011-05-25 10:00:00	QQQ	ETF	56.665	56.76	56.59	56.74	3909210.0
2011-05-25 10:30:00	QQQ	ETF	56.74	56.84	56.67	56.679	3825674.0
2011-05-25 11:00:00	QQQ	ETF	56.679	56.79	56.679	56.74	1373278.0
2011-05-25 11:30:00	QQQ	ETF	56.74	56.905	56.74	56.8329	1956803.0
2011-05-25 12:00:00	QQQ	ETF	56.84	56.88	56.82	56.84	1016306.0
2011-05-25 12:30:00	QQQ	ETF	56.84	56.865	56.8	56.85	828653.0
2011-05-25 13:00:00	QQQ	ETF	56.84	56.85	56.75	56.76	1609207.0
2011-05-25 13:30:00	QQQ	ETF	56.7536	56.8	56.73	56.77	1071059.0
2011-05-25 14:00:00	QQQ	ETF	56.77	56.9	56.75	56.89	1427183.0
2011-05-25 14:30:00	QQQ	ETF	56.89	56.9	56.81	56.87	946248.0

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

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