PREVIEW / etf_30min / 2011-11-14

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-14.parquet
  size:    273 KB
  rows:    9,076

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
2011-11-14 04:00:00	SPY	ETF	127.22	127.23	126.81	126.84	4357.0
2011-11-14 04:30:00	SPY	ETF	126.58	126.75	126.58	126.62	15089.0
2011-11-14 05:00:00	SPY	ETF	126.57	126.83	126.45	126.83	9200.0
2011-11-14 05:30:00	SPY	ETF	126.82	126.82	126.5	126.5	7800.0
2011-11-14 06:00:00	SPY	ETF	126.45	126.45	126.0	126.19	67466.0
2011-11-14 06:30:00	SPY	ETF	126.17	126.35	126.15	126.17	58042.0
2011-11-14 07:00:00	SPY	ETF	126.15	126.15	125.76	126.0	322903.0
2011-11-14 07:30:00	SPY	ETF	126.01	126.18	125.78	126.11	280519.0
2011-11-14 08:00:00	SPY	ETF	126.2	126.26	125.8916	126.2	2253862.0
2011-11-14 08:30:00	SPY	ETF	126.21	126.49	126.08	126.27	1068201.0
2011-11-14 09:00:00	SPY	ETF	126.24	126.28	126.03	126.18	2324054.0
2011-11-14 09:30:00	SPY	ETF	126.19	127.45	125.57	125.88	17474820.0
2011-11-14 10:00:00	SPY	ETF	125.89	126.22	125.69	126.03	10923250.0
2011-11-14 10:30:00	SPY	ETF	126.04	126.07	125.6	125.96	11417431.0
2011-11-14 11:00:00	SPY	ETF	125.96	126.27	125.88	126.01	10247693.0
2011-11-14 11:30:00	SPY	ETF	126.0	126.22	125.44	125.6	10337483.0
2011-11-14 12:00:00	SPY	ETF	125.59	125.66	125.08	125.24	13035710.0
2011-11-14 12:30:00	SPY	ETF	125.23	125.38	125.03	125.33	11183295.0
2011-11-14 13:00:00	SPY	ETF	125.32	125.49	125.17	125.465	4571011.0
2011-11-14 13:30:00	SPY	ETF	125.47	125.61	125.27	125.39	8071343.0
2011-11-14 14:00:00	SPY	ETF	125.39	125.6	125.22	125.22	4962462.0
2011-11-14 14:30:00	SPY	ETF	125.22	125.3	124.92	124.94	7602374.0
2011-11-14 15:00:00	SPY	ETF	124.941	125.4	124.92	125.3111	8415423.0
2011-11-14 15:30:00	SPY	ETF	125.32	125.67	125.32	125.48	18334383.0
2011-11-14 16:00:00	SPY	ETF	125.47	126.6705	125.1	125.67	12073505.0
2011-11-14 16:30:00	SPY	ETF	125.7	125.81	125.4644	125.78	2081630.0
2011-11-14 17:00:00	SPY	ETF	125.78	125.84	125.65	125.67	78389.0
2011-11-14 17:30:00	SPY	ETF	125.66	126.6705	125.55	125.62	1114836.0
2011-11-14 18:00:00	SPY	ETF	125.62	125.65	125.46	125.61	121558.0
2011-11-14 18:30:00	SPY	ETF	125.61	125.74	125.58	125.72	20004.0
2011-11-14 19:00:00	SPY	ETF	125.72	125.79	125.72	125.73	38656.0
2011-11-14 19:30:00	SPY	ETF	125.74	125.91	125.74	125.87	113738.0
2011-11-14 04:00:00	QQQ	ETF	57.96	57.96	57.84	57.84	1200.0
2011-11-14 04:30:00	QQQ	ETF	57.76	57.76	57.66	57.66	3800.0
2011-11-14 05:00:00	QQQ	ETF	57.62	57.62	57.62	57.62	1300.0
2011-11-14 05:30:00	QQQ	ETF	57.66	57.66	57.66	57.66	500.0
2011-11-14 06:00:00	QQQ	ETF	57.6	57.6	57.48	57.48	2700.0
2011-11-14 06:30:00	QQQ	ETF	57.52	57.6	57.52	57.6	200.0
2011-11-14 07:00:00	QQQ	ETF	57.58	57.61	57.5	57.57	25080.0
2011-11-14 07:30:00	QQQ	ETF	57.54	57.65	57.48	57.65	18680.0
2011-11-14 08:00:00	QQQ	ETF	57.62	57.74	57.58	57.7	53807.0
2011-11-14 08:30:00	QQQ	ETF	57.68	57.82	57.67	57.73	84346.0
2011-11-14 09:00:00	QQQ	ETF	57.71	57.73	57.6	57.68	103789.0
2011-11-14 09:30:00	QQQ	ETF	57.69	57.82	57.5	57.71	4818657.0
2011-11-14 10:00:00	QQQ	ETF	57.7172	58.01	57.65	57.8701	5913106.0
2011-11-14 10:30:00	QQQ	ETF	57.8793	57.88	57.63	57.73	4221905.0
2011-11-14 11:00:00	QQQ	ETF	57.73	57.91	57.7	57.76	2458082.0
2011-11-14 11:30:00	QQQ	ETF	57.753	57.88	57.57	57.615	2105806.0
2011-11-14 12:00:00	QQQ	ETF	57.6	57.65	57.37	57.44	3338576.0
2011-11-14 12:30:00	QQQ	ETF	57.43	57.49	57.29	57.48	1869074.0

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

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