PREVIEW / etf_30min / 2013-03-06

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-06.parquet
  size:    308 KB
  rows:    10,546

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-06 04:00:00	SPY	ETF	154.55	154.86	154.55	154.76	20025.0
2013-03-06 04:30:00	SPY	ETF	154.76	154.78	154.69	154.69	3260.0
2013-03-06 05:00:00	SPY	ETF	154.78	154.78	154.71	154.72	16500.0
2013-03-06 05:30:00	SPY	ETF	154.74	154.74	154.65	154.65	11400.0
2013-03-06 06:00:00	SPY	ETF	154.62	154.64	154.59	154.64	17100.0
2013-03-06 06:30:00	SPY	ETF	154.64	154.75	154.64	154.72	42250.0
2013-03-06 07:00:00	SPY	ETF	154.72	154.74	154.65	154.7	253399.0
2013-03-06 07:30:00	SPY	ETF	154.71	154.76	154.67	154.72	215766.0
2013-03-06 08:00:00	SPY	ETF	154.72	154.93	154.67	154.83	762383.0
2013-03-06 08:30:00	SPY	ETF	154.82	154.88	154.74	154.87	395318.0
2013-03-06 09:00:00	SPY	ETF	154.86	154.87	154.8	154.85	443862.0
2013-03-06 09:30:00	SPY	ETF	154.84	154.92	154.52	154.83	16104345.0
2013-03-06 10:00:00	SPY	ETF	154.82	154.829	154.54	154.65	8352629.0
2013-03-06 10:30:00	SPY	ETF	154.64	154.655	154.35	154.36	8551226.0
2013-03-06 11:00:00	SPY	ETF	154.35	154.54	154.33	154.375	6294603.0
2013-03-06 11:30:00	SPY	ETF	154.37	154.52	154.35	154.36	4627454.0
2013-03-06 12:00:00	SPY	ETF	154.37	154.385	154.16	154.27	5474310.0
2013-03-06 12:30:00	SPY	ETF	154.28	154.52	154.255	154.318	3101018.0
2013-03-06 13:00:00	SPY	ETF	154.32	154.5	154.25	154.452	2790360.0
2013-03-06 13:30:00	SPY	ETF	154.45	154.6	154.395	154.51	2905151.0
2013-03-06 14:00:00	SPY	ETF	154.519	154.59	154.38	154.56	5033566.0
2013-03-06 14:30:00	SPY	ETF	154.555	154.86	154.54	154.765	5899827.0
2013-03-06 15:00:00	SPY	ETF	154.76	154.79	154.51	154.56	4587666.0
2013-03-06 15:30:00	SPY	ETF	154.56	154.56	154.33	154.51	9742083.0
2013-03-06 16:00:00	SPY	ETF	154.51	154.691	154.31	154.38	7531352.0
2013-03-06 16:30:00	SPY	ETF	154.36	154.5303	154.33	154.39	513548.0
2013-03-06 17:00:00	SPY	ETF	154.4	154.43	154.39	154.42	30929.0
2013-03-06 17:30:00	SPY	ETF	154.42	154.44	154.38	154.41	42699.0
2013-03-06 18:00:00	SPY	ETF	154.41	154.41	154.35	154.35	35100.0
2013-03-06 18:30:00	SPY	ETF	154.39	154.39	154.33	154.38	10034.0
2013-03-06 19:00:00	SPY	ETF	154.37	154.38	154.34	154.34	11700.0
2013-03-06 19:30:00	SPY	ETF	154.33	154.36	154.29	154.31	57040.0
2013-03-06 04:00:00	QQQ	ETF	68.8	68.9	68.8	68.9	700.0
2013-03-06 04:30:00	QQQ	ETF	68.89	68.89	68.87	68.87	400.0
2013-03-06 05:00:00	QQQ	ETF	68.86	68.86	68.86	68.86	1000.0
2013-03-06 05:30:00	QQQ	ETF	68.83	68.83	68.83	68.83	400.0
2013-03-06 06:30:00	QQQ	ETF	68.82	68.82	68.8	68.8	6600.0
2013-03-06 07:00:00	QQQ	ETF	68.77	68.79	68.75	68.79	700.0
2013-03-06 07:30:00	QQQ	ETF	68.78	68.8	68.76	68.77	2072.0
2013-03-06 08:00:00	QQQ	ETF	68.77	68.85	68.74	68.83	356109.0
2013-03-06 08:30:00	QQQ	ETF	68.81	68.83	68.8	68.83	78139.0
2013-03-06 09:00:00	QQQ	ETF	68.82	68.89	68.81	68.89	360552.0
2013-03-06 09:30:00	QQQ	ETF	68.88	68.908	68.57	68.65	4099949.0
2013-03-06 10:00:00	QQQ	ETF	68.66	68.7	68.53	68.61	2092879.0
2013-03-06 10:30:00	QQQ	ETF	68.61	68.66	68.44	68.45	4899477.0
2013-03-06 11:00:00	QQQ	ETF	68.4599	68.57	68.4401	68.51	2553362.0
2013-03-06 11:30:00	QQQ	ETF	68.51	68.61	68.5	68.51	1544930.0
2013-03-06 12:00:00	QQQ	ETF	68.509	68.51	68.42	68.451	813145.0
2013-03-06 12:30:00	QQQ	ETF	68.46	68.55	68.43	68.43	564990.0
2013-03-06 13:00:00	QQQ	ETF	68.45	68.52	68.42	68.48	587902.0

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

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