PREVIEW / etf_30min / 2012-11-12

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-12.parquet
  size:    277 KB
  rows:    9,375

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
2012-11-12 04:00:00	SPY	ETF	138.38	138.38	138.3	138.3	1170.0
2012-11-12 04:30:00	SPY	ETF	138.38	138.57	138.35	138.57	36006.0
2012-11-12 05:00:00	SPY	ETF	138.54	138.57	138.48	138.48	25100.0
2012-11-12 05:30:00	SPY	ETF	138.59	138.6	138.45	138.45	13700.0
2012-11-12 06:00:00	SPY	ETF	138.49	138.54	138.45	138.48	16668.0
2012-11-12 06:30:00	SPY	ETF	138.53	138.59	138.48	138.55	71599.0
2012-11-12 07:00:00	SPY	ETF	138.56	138.78	138.51	138.76	499355.0
2012-11-12 07:30:00	SPY	ETF	138.74	138.78	138.7	138.76	263807.0
2012-11-12 08:00:00	SPY	ETF	138.76	138.8	138.53	138.67	1139097.0
2012-11-12 08:30:00	SPY	ETF	138.67	138.76	138.64	138.72	186702.0
2012-11-12 09:00:00	SPY	ETF	138.71	138.76	138.58	138.58	452522.0
2012-11-12 09:30:00	SPY	ETF	138.59	138.77	138.42	138.6	11402972.0
2012-11-12 10:00:00	SPY	ETF	138.6	138.61	138.26	138.36	9305787.0
2012-11-12 10:30:00	SPY	ETF	138.37	138.48	138.04	138.08	6741011.0
2012-11-12 11:00:00	SPY	ETF	138.08	138.21	137.96	138.18	5619271.0
2012-11-12 11:30:00	SPY	ETF	138.17	138.19	138.02	138.04	4001631.0
2012-11-12 12:00:00	SPY	ETF	138.05	138.22	137.99	138.21	3266553.0
2012-11-12 12:30:00	SPY	ETF	138.21	138.49	138.19	138.48	3658749.0
2012-11-12 13:00:00	SPY	ETF	138.4799	138.81	138.47	138.73	7749031.0
2012-11-12 13:30:00	SPY	ETF	138.74	138.755	138.51	138.63	4674357.0
2012-11-12 14:00:00	SPY	ETF	138.63	138.73	138.45	138.57	4317204.0
2012-11-12 14:30:00	SPY	ETF	138.575	138.575	138.3	138.43	7745341.0
2012-11-12 15:00:00	SPY	ETF	138.43	138.54	138.2	138.33	5976392.0
2012-11-12 15:30:00	SPY	ETF	138.34	138.51	138.25	138.27	12436680.0
2012-11-12 16:00:00	SPY	ETF	138.28	138.5759	138.0732	138.48	5825579.0
2012-11-12 16:30:00	SPY	ETF	138.48	138.53	138.44	138.53	322702.0
2012-11-12 17:00:00	SPY	ETF	138.52	138.53	138.47	138.48	62417.0
2012-11-12 17:30:00	SPY	ETF	138.48	138.48	138.44	138.48	23930.0
2012-11-12 18:00:00	SPY	ETF	138.48	138.48	138.34	138.35	31525.0
2012-11-12 18:30:00	SPY	ETF	138.35	138.41	138.14	138.17	97244.0
2012-11-12 19:00:00	SPY	ETF	138.2	138.22	138.08	138.14	133390.0
2012-11-12 19:30:00	SPY	ETF	138.1	138.12	138.03	138.12	113297.0
2012-11-12 04:30:00	QQQ	ETF	63.6	63.61	63.6	63.61	400.0
2012-11-12 07:00:00	QQQ	ETF	63.66	63.79	63.66	63.79	18149.0
2012-11-12 07:30:00	QQQ	ETF	63.75	63.78	63.75	63.78	29736.0
2012-11-12 08:00:00	QQQ	ETF	63.81	63.81	63.73	63.8	40784.0
2012-11-12 08:30:00	QQQ	ETF	63.8	63.81	63.4641	63.79	71965.0
2012-11-12 09:00:00	QQQ	ETF	63.8	63.85	63.77	63.78	94271.0
2012-11-12 09:30:00	QQQ	ETF	63.79	63.87	63.7	63.78	3554748.0
2012-11-12 10:00:00	QQQ	ETF	63.78	63.78	63.51	63.56	2301488.0
2012-11-12 10:30:00	QQQ	ETF	63.56	63.63	63.32	63.33	1495327.0
2012-11-12 11:00:00	QQQ	ETF	63.32	63.38	63.25	63.38	2109791.0
2012-11-12 11:30:00	QQQ	ETF	63.37	63.3798	63.28	63.3101	912871.0
2012-11-12 12:00:00	QQQ	ETF	63.32	63.438	63.3	63.43	904965.0
2012-11-12 12:30:00	QQQ	ETF	63.4201	63.68	63.4201	63.68	1461858.0
2012-11-12 13:00:00	QQQ	ETF	63.675	63.81	63.67	63.73	1680904.0
2012-11-12 13:30:00	QQQ	ETF	63.73	63.74	63.5	63.592	1129383.0
2012-11-12 14:00:00	QQQ	ETF	63.59	63.65	63.47	63.555	1181409.0
2012-11-12 14:30:00	QQQ	ETF	63.55	63.568	63.39	63.48	1531571.0
2012-11-12 15:00:00	QQQ	ETF	63.47	63.54	63.35	63.47	1626469.0

> showing 50 of 9,375 rows — these rows as CSV

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