PREVIEW / etf_30min / 2011-10-26

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-26.parquet
  size:    289 KB
  rows:    9,569

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-10-26 04:00:00	SPY	ETF	123.56	123.95	123.56	123.67	18521.0
2011-10-26 04:30:00	SPY	ETF	123.62	123.75	123.56	123.56	1450.0
2011-10-26 05:00:00	SPY	ETF	123.47	123.74	123.47	123.65	7700.0
2011-10-26 05:30:00	SPY	ETF	123.72	123.72	123.72	123.72	300.0
2011-10-26 06:00:00	SPY	ETF	123.7	123.71	123.45	123.54	15040.0
2011-10-26 06:30:00	SPY	ETF	123.51	123.9	123.5	123.67	249450.0
2011-10-26 07:00:00	SPY	ETF	123.69	123.87	123.5	123.85	186589.0
2011-10-26 07:30:00	SPY	ETF	123.85	123.93	123.62	123.62	168754.0
2011-10-26 08:00:00	SPY	ETF	123.64	123.9	123.6	123.85	869254.0
2011-10-26 08:30:00	SPY	ETF	123.86	124.4	123.65	124.08	2758258.0
2011-10-26 09:00:00	SPY	ETF	124.08	124.52	124.07	124.33	2923175.0
2011-10-26 09:30:00	SPY	ETF	124.35	124.53	123.89	124.05	32759286.0
2011-10-26 10:00:00	SPY	ETF	124.06	124.12	123.14	123.47	23132833.0
2011-10-26 10:30:00	SPY	ETF	123.5	123.5	122.21	122.48	25651670.0
2011-10-26 11:00:00	SPY	ETF	122.48	122.97	122.45	122.86	16059307.0
2011-10-26 11:30:00	SPY	ETF	122.86	123.36	122.84	123.14	14377951.0
2011-10-26 12:00:00	SPY	ETF	123.14	123.33	122.94	123.09	7468577.0
2011-10-26 12:30:00	SPY	ETF	123.09	123.24	122.88	122.95	6083773.0
2011-10-26 13:00:00	SPY	ETF	122.95	123.01	122.62	122.99	8827228.0
2011-10-26 13:30:00	SPY	ETF	123.0	124.0	122.98	123.79	33043155.0
2011-10-26 14:00:00	SPY	ETF	123.8	124.22	123.69	123.901	20549448.0
2011-10-26 14:30:00	SPY	ETF	123.9	124.44	123.81	123.97	17934943.0
2011-10-26 15:00:00	SPY	ETF	123.97	124.45	123.88	124.4	23434687.0
2011-10-26 15:30:00	SPY	ETF	124.4	124.77	124.05	124.31	34246580.0
2011-10-26 16:00:00	SPY	ETF	124.31	124.46	123.0195	124.35	11423502.0
2011-10-26 16:30:00	SPY	ETF	124.34	124.85	124.31	124.76	2375627.0
2011-10-26 17:00:00	SPY	ETF	124.74	124.96	124.7	124.86	272840.0
2011-10-26 17:30:00	SPY	ETF	124.84	124.88	124.58	124.64	207544.0
2011-10-26 18:00:00	SPY	ETF	124.7	124.75	124.33	124.55	1262993.0
2011-10-26 18:30:00	SPY	ETF	124.57	124.57	124.4	124.41	123776.0
2011-10-26 19:00:00	SPY	ETF	124.47	124.61	124.35	124.56	64164.0
2011-10-26 19:30:00	SPY	ETF	124.57	124.58	124.45	124.57	45332.0
2011-10-26 05:30:00	QQQ	ETF	57.43	57.43	57.34	57.34	866.0
2011-10-26 06:00:00	QQQ	ETF	57.34	57.34	57.34	57.34	487.0
2011-10-26 06:30:00	QQQ	ETF	57.32	57.44	57.3	57.42	33450.0
2011-10-26 07:00:00	QQQ	ETF	57.39	57.45	57.32	57.42	74690.0
2011-10-26 07:30:00	QQQ	ETF	57.42	57.45	57.32	57.32	52624.0
2011-10-26 08:00:00	QQQ	ETF	57.34	57.47	57.31	57.43	135122.0
2011-10-26 08:30:00	QQQ	ETF	57.44	57.63	57.38	57.51	476468.0
2011-10-26 09:00:00	QQQ	ETF	57.51	57.68	57.51	57.65	646685.0
2011-10-26 09:30:00	QQQ	ETF	57.65	57.78	57.44	57.5174	7178986.0
2011-10-26 10:00:00	QQQ	ETF	57.52	57.54	57.05	57.15	5438449.0
2011-10-26 10:30:00	QQQ	ETF	57.14	57.14	56.2126	56.3	14186382.0
2011-10-26 11:00:00	QQQ	ETF	56.3	56.56	56.29	56.47	5925373.0
2011-10-26 11:30:00	QQQ	ETF	56.48	56.9785	56.47	56.79	6920261.0
2011-10-26 12:00:00	QQQ	ETF	56.8	56.89	56.73	56.79	1645077.0
2011-10-26 12:30:00	QQQ	ETF	56.78	56.84	56.63	56.65	1094298.0
2011-10-26 13:00:00	QQQ	ETF	56.65	56.7	56.48	56.7	1821456.0
2011-10-26 13:30:00	QQQ	ETF	56.7	57.24	56.695	57.16	9111295.0
2011-10-26 14:00:00	QQQ	ETF	57.16	57.38	57.09	57.17	4965272.0

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

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