PREVIEW / etf_30min / 2011-10-06

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-06.parquet
  size:    289 KB
  rows:    9,643

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-10-06 04:00:00	SPY	ETF	114.42	114.99	114.42	114.84	60541.0
2011-10-06 04:30:00	SPY	ETF	114.83	115.12	114.82	115.02	13806.0
2011-10-06 05:00:00	SPY	ETF	115.0	115.11	114.9	114.9	4979.0
2011-10-06 05:30:00	SPY	ETF	114.77	114.87	114.67	114.8	29440.0
2011-10-06 06:00:00	SPY	ETF	114.78	115.03	114.65	115.03	48500.0
2011-10-06 06:30:00	SPY	ETF	114.97	115.03	114.87	114.97	63516.0
2011-10-06 07:00:00	SPY	ETF	114.97	115.43	114.97	115.26	512941.0
2011-10-06 07:30:00	SPY	ETF	115.27	115.31	114.17	114.55	1934117.0
2011-10-06 08:00:00	SPY	ETF	114.55	115.25	114.18	114.7	1276165.0
2011-10-06 08:30:00	SPY	ETF	114.73	115.18	114.15	114.58	5272515.0
2011-10-06 09:00:00	SPY	ETF	114.56	114.56	113.75	114.35	4444081.0
2011-10-06 09:30:00	SPY	ETF	114.36	114.62	113.51	113.925	30073622.0
2011-10-06 10:00:00	SPY	ETF	113.92	115.01	113.64	114.89	24119380.0
2011-10-06 10:30:00	SPY	ETF	114.9	115.35	114.7	114.804	20524682.0
2011-10-06 11:00:00	SPY	ETF	114.8	115.45	114.73	115.34	16054438.0
2011-10-06 11:30:00	SPY	ETF	115.34	116.07	115.34	115.72	18562389.0
2011-10-06 12:00:00	SPY	ETF	115.71	116.04	115.53	115.86	11289838.0
2011-10-06 12:30:00	SPY	ETF	115.86	115.96	115.46	115.52	9709373.0
2011-10-06 13:00:00	SPY	ETF	115.52	115.83	115.34	115.45	11633264.0
2011-10-06 13:30:00	SPY	ETF	115.45	115.67	115.16	115.61	9989992.0
2011-10-06 14:00:00	SPY	ETF	115.61	116.22	115.45	116.05	13924790.0
2011-10-06 14:30:00	SPY	ETF	116.05	116.11	115.53	115.85	12054638.0
2011-10-06 15:00:00	SPY	ETF	115.84	116.11	115.39	115.4931	17196369.0
2011-10-06 15:30:00	SPY	ETF	115.49	116.66	115.45	116.517	35998462.0
2011-10-06 16:00:00	SPY	ETF	116.5	116.573	115.51	116.34	9375432.0
2011-10-06 16:30:00	SPY	ETF	116.35	116.42	116.31	116.37	373347.0
2011-10-06 17:00:00	SPY	ETF	116.37	116.41	116.31	116.4	173706.0
2011-10-06 17:30:00	SPY	ETF	116.38	116.42	116.34	116.34	66543.0
2011-10-06 18:00:00	SPY	ETF	116.34	116.51	116.31	116.34	238459.0
2011-10-06 18:30:00	SPY	ETF	116.35	116.51	116.35	116.4	111999.0
2011-10-06 19:00:00	SPY	ETF	116.38	116.4	116.3	116.34	57487.0
2011-10-06 19:30:00	SPY	ETF	116.35	116.39	116.29	116.36	44611.0
2011-10-06 04:00:00	QQQ	ETF	53.54	53.7	53.48	53.68	12700.0
2011-10-06 04:30:00	QQQ	ETF	53.8	53.8	53.8	53.8	400.0
2011-10-06 05:00:00	QQQ	ETF	53.6	53.73	53.51	53.51	2800.0
2011-10-06 05:30:00	QQQ	ETF	53.64	53.64	53.46	53.46	10700.0
2011-10-06 06:00:00	QQQ	ETF	53.48	53.65	53.48	53.65	6200.0
2011-10-06 06:30:00	QQQ	ETF	53.57	53.63	53.53	53.63	8525.0
2011-10-06 07:00:00	QQQ	ETF	53.63	53.76	53.63	53.72	90383.0
2011-10-06 07:30:00	QQQ	ETF	53.78	53.79	53.43	53.62	511354.0
2011-10-06 08:00:00	QQQ	ETF	53.58	53.65	53.42	53.61	603890.0
2011-10-06 08:30:00	QQQ	ETF	53.63	53.86	53.48	53.63	928940.0
2011-10-06 09:00:00	QQQ	ETF	53.62	53.62	53.31	53.46	649068.0
2011-10-06 09:30:00	QQQ	ETF	53.47	53.68	53.21	53.48	11738431.0
2011-10-06 10:00:00	QQQ	ETF	53.48	54.01	53.34	53.94	8200106.0
2011-10-06 10:30:00	QQQ	ETF	53.94	54.18	53.8437	53.87	5706369.0
2011-10-06 11:00:00	QQQ	ETF	53.86	54.14	53.74	54.01	5690321.0
2011-10-06 11:30:00	QQQ	ETF	54.01	54.2	54.0	54.0975	4697621.0
2011-10-06 12:00:00	QQQ	ETF	54.09	54.29	54.04	54.24	4299894.0
2011-10-06 12:30:00	QQQ	ETF	54.24	54.32	54.04	54.06	2995957.0

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

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