PREVIEW / etf_30min / 2013-03-20

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-20.parquet
  size:    302 KB
  rows:    10,429

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
2013-03-20 04:00:00	SPY	ETF	154.7	155.24	154.7	155.24	17100.0
2013-03-20 04:30:00	SPY	ETF	155.14	155.14	155.05	155.14	8244.0
2013-03-20 05:00:00	SPY	ETF	155.18	155.2	155.06	155.06	3400.0
2013-03-20 05:30:00	SPY	ETF	155.11	155.24	155.11	155.14	12600.0
2013-03-20 06:00:00	SPY	ETF	155.11	155.32	155.11	155.32	13300.0
2013-03-20 06:30:00	SPY	ETF	155.33	155.34	155.06	155.14	58975.0
2013-03-20 07:00:00	SPY	ETF	155.09	155.19	155.08	155.16	171323.0
2013-03-20 07:30:00	SPY	ETF	155.16	155.16	154.93	154.97	438381.0
2013-03-20 08:00:00	SPY	ETF	154.95	155.66	154.65	155.35	2561111.0
2013-03-20 08:30:00	SPY	ETF	155.35	155.55	155.25	155.45	1102377.0
2013-03-20 09:00:00	SPY	ETF	155.45	155.53	155.38	155.53	1043415.0
2013-03-20 09:30:00	SPY	ETF	155.52	155.72	155.37	155.42	14461847.0
2013-03-20 10:00:00	SPY	ETF	155.42	155.64	155.34	155.5	8028221.0
2013-03-20 10:30:00	SPY	ETF	155.51	155.58	155.26	155.55	8232611.0
2013-03-20 11:00:00	SPY	ETF	155.55	155.58	155.34	155.47	5248089.0
2013-03-20 11:30:00	SPY	ETF	155.48	155.5299	155.32	155.35	4899684.0
2013-03-20 12:00:00	SPY	ETF	155.36	155.485	155.32	155.48	4060748.0
2013-03-20 12:30:00	SPY	ETF	155.475	155.55	155.38	155.47	3431632.0
2013-03-20 13:00:00	SPY	ETF	155.47	155.53	155.43	155.47	2657237.0
2013-03-20 13:30:00	SPY	ETF	155.46	155.465	155.32	155.37	3781887.0
2013-03-20 14:00:00	SPY	ETF	155.37	155.94	155.3	155.85	13534774.0
2013-03-20 14:30:00	SPY	ETF	155.83	155.89	155.65	155.685	7385471.0
2013-03-20 15:00:00	SPY	ETF	155.685	155.77	155.55	155.65	6211296.0
2013-03-20 15:30:00	SPY	ETF	155.65	155.95	155.47	155.65	14737578.0
2013-03-20 16:00:00	SPY	ETF	155.64	155.65	154.6015	155.38	9736760.0
2013-03-20 16:30:00	SPY	ETF	155.38	155.69	155.35	155.42	532442.0
2013-03-20 17:00:00	SPY	ETF	155.42	155.47	155.42	155.44	61281.0
2013-03-20 17:30:00	SPY	ETF	155.43	155.45	155.38	155.38	27720.0
2013-03-20 18:00:00	SPY	ETF	155.38	155.39	155.29	155.39	80829.0
2013-03-20 18:30:00	SPY	ETF	155.39	155.43	155.24	155.4	19750.0
2013-03-20 19:00:00	SPY	ETF	155.4	155.41	155.32	155.32	16300.0
2013-03-20 19:30:00	SPY	ETF	155.36	155.41	155.32	155.37	13750.0
2013-03-20 04:00:00	QQQ	ETF	68.5	68.55	68.5	68.55	500.0
2013-03-20 05:00:00	QQQ	ETF	68.56	68.56	68.56	68.56	100.0
2013-03-20 05:30:00	QQQ	ETF	68.58	68.61	68.58	68.6	700.0
2013-03-20 06:00:00	QQQ	ETF	68.6	68.65	68.6	68.65	3120.0
2013-03-20 06:30:00	QQQ	ETF	68.65	68.65	68.54	68.55	4200.0
2013-03-20 07:00:00	QQQ	ETF	68.56	68.57	68.55	68.57	9000.0
2013-03-20 07:30:00	QQQ	ETF	68.57	68.57	68.5	68.52	47890.0
2013-03-20 08:00:00	QQQ	ETF	68.5	68.78	68.5	68.65	139878.0
2013-03-20 08:30:00	QQQ	ETF	68.65	68.76	68.63	68.72	96210.0
2013-03-20 09:00:00	QQQ	ETF	68.74	68.74	68.67	68.74	226803.0
2013-03-20 09:30:00	QQQ	ETF	68.74	68.86	68.54	68.58	3856794.0
2013-03-20 10:00:00	QQQ	ETF	68.58	68.715	68.56	68.635	1925072.0
2013-03-20 10:30:00	QQQ	ETF	68.64	68.67	68.44	68.57	2882747.0
2013-03-20 11:00:00	QQQ	ETF	68.575	68.59	68.48	68.54	1290645.0
2013-03-20 11:30:00	QQQ	ETF	68.535	68.59	68.39	68.4	611835.0
2013-03-20 12:00:00	QQQ	ETF	68.405	68.54	68.39	68.535	865202.0
2013-03-20 12:30:00	QQQ	ETF	68.54	68.6178	68.49	68.584	1245834.0
2013-03-20 13:00:00	QQQ	ETF	68.58	68.62	68.555	68.59	297226.0

> showing 50 of 10,429 rows — these rows as CSV

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