PREVIEW / etf_30min / 2013-11-26

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-26.parquet
  size:    319 KB
  rows:    10,854

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-11-26 04:00:00	SPY	ETF	180.87	180.87	180.77	180.8	6150.0
2013-11-26 04:30:00	SPY	ETF	180.78	180.78	180.66	180.66	912.0
2013-11-26 05:00:00	SPY	ETF	180.69	180.7	180.67	180.68	5600.0
2013-11-26 05:30:00	SPY	ETF	180.66	180.68	180.63	180.65	6000.0
2013-11-26 06:00:00	SPY	ETF	180.69	180.69	180.63	180.65	6300.0
2013-11-26 06:30:00	SPY	ETF	180.62	180.71	180.62	180.67	15734.0
2013-11-26 07:00:00	SPY	ETF	180.71	180.9	180.67	180.87	110204.0
2013-11-26 07:30:00	SPY	ETF	180.85	180.9	180.83	180.83	14005.0
2013-11-26 08:00:00	SPY	ETF	180.91	180.91	180.79	180.82	104138.0
2013-11-26 08:30:00	SPY	ETF	180.81	180.87	180.7	180.7	415171.0
2013-11-26 09:00:00	SPY	ETF	180.7	180.77	180.65	180.73	1613073.0
2013-11-26 09:30:00	SPY	ETF	180.72	180.94	180.65	180.72	8636675.0
2013-11-26 10:00:00	SPY	ETF	180.73	180.86	180.405	180.82	7445496.0
2013-11-26 10:30:00	SPY	ETF	180.81	180.86	180.65	180.76	2658033.0
2013-11-26 11:00:00	SPY	ETF	180.765	180.9	180.72	180.75	3176586.0
2013-11-26 11:30:00	SPY	ETF	180.74	180.8	180.68	180.68	3449978.0
2013-11-26 12:00:00	SPY	ETF	180.68	181.05	180.67	181.0	5754967.0
2013-11-26 12:30:00	SPY	ETF	180.9901	181.06	180.89	180.95	2665119.0
2013-11-26 13:00:00	SPY	ETF	180.95	181.0	180.9	180.9699	1522941.0
2013-11-26 13:30:00	SPY	ETF	180.965	181.15	180.96	181.115	5304378.0
2013-11-26 14:00:00	SPY	ETF	181.115	181.14	180.94	181.05	2942895.0
2013-11-26 14:30:00	SPY	ETF	181.0595	181.185	181.05	181.085	4924404.0
2013-11-26 15:00:00	SPY	ETF	181.0805	181.22	181.03	181.14	6239977.0
2013-11-26 15:30:00	SPY	ETF	181.15	181.2	180.63	180.69	19186133.0
2013-11-26 16:00:00	SPY	ETF	180.68	181.1138	180.627	180.73	5668353.0
2013-11-26 16:30:00	SPY	ETF	180.72	180.96	180.599	180.77	1601073.0
2013-11-26 17:00:00	SPY	ETF	180.77	180.77	180.73	180.74	175140.0
2013-11-26 17:30:00	SPY	ETF	180.74	180.74	180.64	180.71	114248.0
2013-11-26 18:00:00	SPY	ETF	180.7	180.71	180.64	180.68	77400.0
2013-11-26 18:30:00	SPY	ETF	180.68	180.68	180.66	180.67	3760.0
2013-11-26 19:00:00	SPY	ETF	180.67	180.68	180.66	180.67	32764.0
2013-11-26 19:30:00	SPY	ETF	180.67	180.77	180.67	180.74	55054.0
2013-11-26 04:30:00	QQQ	ETF	84.18	84.18	84.18	84.18	4200.0
2013-11-26 07:00:00	QQQ	ETF	84.17	84.23	84.17	84.23	3100.0
2013-11-26 07:30:00	QQQ	ETF	84.24	84.24	84.23	84.23	10800.0
2013-11-26 08:00:00	QQQ	ETF	84.23	84.25	84.22	84.24	12891.0
2013-11-26 08:30:00	QQQ	ETF	84.24	84.26	84.19	84.2	17318.0
2013-11-26 09:00:00	QQQ	ETF	84.21	84.24	84.17	84.21	28412.0
2013-11-26 09:30:00	QQQ	ETF	84.22	84.31	84.095	84.13	2718624.0
2013-11-26 10:00:00	QQQ	ETF	84.13	84.34	84.025	84.33	3299060.0
2013-11-26 10:30:00	QQQ	ETF	84.33	84.37	84.28	84.34	1056792.0
2013-11-26 11:00:00	QQQ	ETF	84.34	84.47	84.331	84.365	1571263.0
2013-11-26 11:30:00	QQQ	ETF	84.37	84.43	84.34	84.35	565035.0
2013-11-26 12:00:00	QQQ	ETF	84.35	84.59	84.34	84.56	1223456.0
2013-11-26 12:30:00	QQQ	ETF	84.57	84.65	84.53	84.6101	1233719.0
2013-11-26 13:00:00	QQQ	ETF	84.62	84.67	84.59	84.635	484266.0
2013-11-26 13:30:00	QQQ	ETF	84.635	84.74	84.63	84.69	964353.0
2013-11-26 14:00:00	QQQ	ETF	84.7	84.73	84.62	84.685	1692534.0
2013-11-26 14:30:00	QQQ	ETF	84.685	84.8	84.675	84.76	1060739.0
2013-11-26 15:00:00	QQQ	ETF	84.759	84.84	84.735	84.8	1245229.0

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

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