PREVIEW / etf_30min / 2013-03-07

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-07.parquet
  size:    299 KB
  rows:    10,541

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-07 04:30:00	SPY	ETF	154.54	154.6	154.54	154.58	450.0
2013-03-07 05:00:00	SPY	ETF	154.66	154.66	154.66	154.66	300.0
2013-03-07 05:30:00	SPY	ETF	154.6	154.61	154.57	154.57	3300.0
2013-03-07 06:00:00	SPY	ETF	154.55	154.65	154.55	154.56	1800.0
2013-03-07 06:30:00	SPY	ETF	154.52	154.62	154.52	154.62	1000.0
2013-03-07 07:00:00	SPY	ETF	154.59	154.6	154.38	154.39	469592.0
2013-03-07 07:30:00	SPY	ETF	154.43	154.5	154.34	154.5	298718.0
2013-03-07 08:00:00	SPY	ETF	154.5	154.62	154.4	154.57	1249500.0
2013-03-07 08:30:00	SPY	ETF	154.54	154.88	154.53	154.74	1156263.0
2013-03-07 09:00:00	SPY	ETF	154.74	154.83	154.49	154.71	621565.0
2013-03-07 09:30:00	SPY	ETF	154.7	154.91	154.54	154.77	9732908.0
2013-03-07 10:00:00	SPY	ETF	154.77	154.83	154.59	154.765	5371123.0
2013-03-07 10:30:00	SPY	ETF	154.76	154.87	154.66	154.71	5090035.0
2013-03-07 11:00:00	SPY	ETF	154.7	154.91	154.68	154.8	3792946.0
2013-03-07 11:30:00	SPY	ETF	154.8	154.98	154.765	154.85	4522110.0
2013-03-07 12:00:00	SPY	ETF	154.845	154.89	154.75	154.865	2980158.0
2013-03-07 12:30:00	SPY	ETF	154.86	154.91	154.755	154.88	2450738.0
2013-03-07 13:00:00	SPY	ETF	154.88	154.91	154.78	154.81	1998115.0
2013-03-07 13:30:00	SPY	ETF	154.8087	154.81	154.66	154.77	2865915.0
2013-03-07 14:00:00	SPY	ETF	154.77	154.78	154.52	154.69	3580207.0
2013-03-07 14:30:00	SPY	ETF	154.69	154.84	154.625	154.77	3727320.0
2013-03-07 15:00:00	SPY	ETF	154.775	154.94	154.75	154.85	6536862.0
2013-03-07 15:30:00	SPY	ETF	154.85	154.95	154.77	154.79	10913881.0
2013-03-07 16:00:00	SPY	ETF	154.8	154.8959	154.5194	154.79	12131572.0
2013-03-07 16:30:00	SPY	ETF	154.81	154.88	154.79	154.85	445866.0
2013-03-07 17:00:00	SPY	ETF	154.85	154.89	154.8	154.81	191273.0
2013-03-07 17:30:00	SPY	ETF	154.81	154.83	154.77	154.77	81667.0
2013-03-07 18:00:00	SPY	ETF	154.76	154.76	154.61	154.65	318514.0
2013-03-07 18:30:00	SPY	ETF	154.64	154.68	154.64	154.65	15909.0
2013-03-07 19:00:00	SPY	ETF	154.63	154.63	154.57	154.58	20086.0
2013-03-07 19:30:00	SPY	ETF	154.6	154.6	154.49	154.58	63268.0
2013-03-07 05:00:00	QQQ	ETF	68.6	68.6	68.6	68.6	200.0
2013-03-07 06:30:00	QQQ	ETF	68.55	68.55	68.55	68.55	200.0
2013-03-07 07:00:00	QQQ	ETF	68.55	68.55	68.48	68.48	6200.0
2013-03-07 07:30:00	QQQ	ETF	68.5	68.5	68.48	68.5	11400.0
2013-03-07 08:00:00	QQQ	ETF	68.5	68.51	68.48	68.51	713470.0
2013-03-07 08:30:00	QQQ	ETF	68.53	68.64	68.49	68.58	44491.0
2013-03-07 09:00:00	QQQ	ETF	68.59	68.61	68.51	68.59	68373.0
2013-03-07 09:30:00	QQQ	ETF	68.59	68.65	68.51	68.59	2498535.0
2013-03-07 10:00:00	QQQ	ETF	68.59	68.62	68.45	68.53	1189876.0
2013-03-07 10:30:00	QQQ	ETF	68.53	68.6	68.51	68.534	906465.0
2013-03-07 11:00:00	QQQ	ETF	68.5315	68.67	68.52	68.66	1452504.0
2013-03-07 11:30:00	QQQ	ETF	68.66	68.8	68.64	68.69	2732106.0
2013-03-07 12:00:00	QQQ	ETF	68.6899	68.7	68.59	68.69	1098827.0
2013-03-07 12:30:00	QQQ	ETF	68.6825	68.72	68.61	68.7	796538.0
2013-03-07 13:00:00	QQQ	ETF	68.7	68.7224	68.61	68.62	336460.0
2013-03-07 13:30:00	QQQ	ETF	68.62	68.63	68.52	68.61	530137.0
2013-03-07 14:00:00	QQQ	ETF	68.62	68.62	68.468	68.558	1004820.0
2013-03-07 14:30:00	QQQ	ETF	68.55	68.68	68.54	68.67	654950.0
2013-03-07 15:00:00	QQQ	ETF	68.67	68.7301	68.63	68.694	1975140.0

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

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