PREVIEW / etf_30min / 2013-03-14

all etf 30-min files

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

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-14 04:00:00	SPY	ETF	156.33	156.38	156.33	156.33	18354.0
2013-03-14 04:30:00	SPY	ETF	156.33	156.33	156.33	156.33	1000.0
2013-03-14 05:00:00	SPY	ETF	156.33	156.33	156.3	156.3	1300.0
2013-03-14 05:30:00	SPY	ETF	156.28	156.28	156.25	156.25	500.0
2013-03-14 06:00:00	SPY	ETF	156.28	156.3	156.2	156.25	44141.0
2013-03-14 06:30:00	SPY	ETF	156.26	156.26	156.21	156.22	2200.0
2013-03-14 07:00:00	SPY	ETF	156.23	156.33	156.23	156.3	83030.0
2013-03-14 07:30:00	SPY	ETF	156.3	156.39	156.28	156.38	129903.0
2013-03-14 08:00:00	SPY	ETF	156.39	156.48	156.26	156.43	384430.0
2013-03-14 08:30:00	SPY	ETF	156.44	156.49	156.4	156.45	614390.0
2013-03-14 09:00:00	SPY	ETF	156.45	156.46	156.3	156.3	585638.0
2013-03-14 09:30:00	SPY	ETF	156.31	156.59	156.25	156.56	12623118.0
2013-03-14 10:00:00	SPY	ETF	156.56	156.6	156.22	156.39	9189509.0
2013-03-14 10:30:00	SPY	ETF	156.38	156.5	156.35	156.44	5368134.0
2013-03-14 11:00:00	SPY	ETF	156.43	156.47	156.34	156.365	7905536.0
2013-03-14 11:30:00	SPY	ETF	156.35	156.55	156.32	156.49	4505726.0
2013-03-14 12:00:00	SPY	ETF	156.48	156.64	156.48	156.56	7922922.0
2013-03-14 12:30:00	SPY	ETF	156.5699	156.69	156.52	156.53	4775391.0
2013-03-14 13:00:00	SPY	ETF	156.53	156.63	156.46	156.46	5663591.0
2013-03-14 13:30:00	SPY	ETF	156.46	156.5	156.37	156.38	4788203.0
2013-03-14 14:00:00	SPY	ETF	156.38	156.52	156.38	156.46	4768484.0
2013-03-14 14:30:00	SPY	ETF	156.46	156.57	156.425	156.56	6200125.0
2013-03-14 15:00:00	SPY	ETF	156.57	156.64	156.53	156.551	7419665.0
2013-03-14 15:30:00	SPY	ETF	156.555	156.8	156.55	156.73	20423778.0
2013-03-14 16:00:00	SPY	ETF	156.73	156.78	155.9086	156.68	9211578.0
2013-03-14 16:30:00	SPY	ETF	156.67	156.775	155.9087	156.62	3964689.0
2013-03-14 17:00:00	SPY	ETF	156.6	156.7692	156.51	156.55	2273356.0
2013-03-14 17:30:00	SPY	ETF	156.57	156.73	156.55	156.56	1370639.0
2013-03-14 18:00:00	SPY	ETF	156.56	156.62	156.53	156.54	1108889.0
2013-03-14 18:30:00	SPY	ETF	156.54	156.64	156.54	156.62	32860.0
2013-03-14 19:00:00	SPY	ETF	156.64	156.68	156.61	156.66	33460.0
2013-03-14 19:30:00	SPY	ETF	156.65	156.67	156.65	156.67	11168.0
2013-03-14 05:00:00	QQQ	ETF	68.83	68.83	68.83	68.83	8000.0
2013-03-14 06:00:00	QQQ	ETF	68.77	68.77	68.77	68.77	1000.0
2013-03-14 07:00:00	QQQ	ETF	68.78	68.79	68.78	68.79	9786.0
2013-03-14 07:30:00	QQQ	ETF	68.82	68.88	68.82	68.88	29500.0
2013-03-14 08:00:00	QQQ	ETF	68.89	68.97	68.86	68.93	260725.0
2013-03-14 08:30:00	QQQ	ETF	68.92	68.96	68.92	68.93	43906.0
2013-03-14 09:00:00	QQQ	ETF	68.93	68.93	68.87	68.87	33466.0
2013-03-14 09:30:00	QQQ	ETF	68.87	69.01	68.845	68.92	2879742.0
2013-03-14 10:00:00	QQQ	ETF	68.92	68.97	68.718	68.86	2406832.0
2013-03-14 10:30:00	QQQ	ETF	68.85	68.88	68.805	68.83	917025.0
2013-03-14 11:00:00	QQQ	ETF	68.83	68.86	68.79	68.7999	393060.0
2013-03-14 11:30:00	QQQ	ETF	68.8	68.87	68.751	68.84	598149.0
2013-03-14 12:00:00	QQQ	ETF	68.84	68.91	68.835	68.8869	677518.0
2013-03-14 12:30:00	QQQ	ETF	68.89	68.95	68.855	68.8799	741728.0
2013-03-14 13:00:00	QQQ	ETF	68.88	68.92	68.81	68.81	930270.0
2013-03-14 13:30:00	QQQ	ETF	68.81	68.8299	68.76	68.781	904771.0
2013-03-14 14:00:00	QQQ	ETF	68.78	68.82	68.76	68.7901	1014675.0
2013-03-14 14:30:00	QQQ	ETF	68.7945	68.84	68.78	68.84	926994.0

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

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