PREVIEW / etf_30min / 2011-08-30

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-30.parquet
  size:    283 KB
  rows:    9,521

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-08-30 04:00:00	SPY	ETF	121.32	121.32	120.86	120.88	5799.0
2011-08-30 04:30:00	SPY	ETF	120.88	120.88	120.79	120.85	2900.0
2011-08-30 05:00:00	SPY	ETF	120.85	120.89	120.46	120.49	28250.0
2011-08-30 05:30:00	SPY	ETF	120.53	120.73	120.53	120.73	2580.0
2011-08-30 06:00:00	SPY	ETF	120.68	120.68	120.5	120.65	43288.0
2011-08-30 06:30:00	SPY	ETF	120.69	120.88	120.46	120.88	46260.0
2011-08-30 07:00:00	SPY	ETF	120.85	120.93	120.69	120.81	219909.0
2011-08-30 07:30:00	SPY	ETF	120.81	120.85	120.61	120.65	279910.0
2011-08-30 08:00:00	SPY	ETF	120.67	120.69	120.38	120.55	1161503.0
2011-08-30 08:30:00	SPY	ETF	120.55	120.62	120.18	120.36	1360445.0
2011-08-30 09:00:00	SPY	ETF	120.36	120.84	120.34	120.83	1839226.0
2011-08-30 09:30:00	SPY	ETF	120.83	121.1918	120.6	120.78	21643271.0
2011-08-30 10:00:00	SPY	ETF	120.78	120.84	119.26	120.57	32333074.0
2011-08-30 10:30:00	SPY	ETF	120.57	120.86	120.27	120.59	16444964.0
2011-08-30 11:00:00	SPY	ETF	120.59	121.39	120.47	121.251	16042088.0
2011-08-30 11:30:00	SPY	ETF	121.23	121.87	121.14	121.64	15736695.0
2011-08-30 12:00:00	SPY	ETF	121.64	121.68	121.2616	121.33	9043810.0
2011-08-30 12:30:00	SPY	ETF	121.34	121.41	120.78	120.92	11696080.0
2011-08-30 13:00:00	SPY	ETF	120.93	121.32	120.75	121.16	12561119.0
2011-08-30 13:30:00	SPY	ETF	121.16	121.275	120.83	121.08	8067439.0
2011-08-30 14:00:00	SPY	ETF	121.08	121.78	120.85	121.78	18506864.0
2011-08-30 14:30:00	SPY	ETF	121.78	121.9	121.4	121.85	12890961.0
2011-08-30 15:00:00	SPY	ETF	121.84	121.94	121.63	121.935	11081240.0
2011-08-30 15:30:00	SPY	ETF	121.94	122.43	121.6	121.63	33691179.0
2011-08-30 16:00:00	SPY	ETF	121.62	122.2667	120.93	121.0	12778891.0
2011-08-30 16:30:00	SPY	ETF	120.98	121.07	120.89	120.94	816355.0
2011-08-30 17:00:00	SPY	ETF	120.96	120.97	120.8	120.84	189646.0
2011-08-30 17:30:00	SPY	ETF	120.84	121.6939	120.84	120.9	938813.0
2011-08-30 18:00:00	SPY	ETF	120.9	121.62	120.84	121.0	184909.0
2011-08-30 18:30:00	SPY	ETF	120.99	121.0	120.77	120.81	56607.0
2011-08-30 19:00:00	SPY	ETF	120.81	120.83	120.75	120.77	43923.0
2011-08-30 19:30:00	SPY	ETF	120.77	120.9	120.72	120.9	143852.0
2011-08-30 04:00:00	QQQ	ETF	54.47	54.47	54.42	54.42	1000.0
2011-08-30 05:00:00	QQQ	ETF	54.39	54.39	54.27	54.28	2769.0
2011-08-30 05:30:00	QQQ	ETF	54.26	54.26	54.26	54.26	307.0
2011-08-30 06:00:00	QQQ	ETF	54.4	54.4	54.39	54.39	8908.0
2011-08-30 07:00:00	QQQ	ETF	54.47	54.48	54.38	54.38	26800.0
2011-08-30 07:30:00	QQQ	ETF	54.44	54.45	54.37	54.37	20249.0
2011-08-30 08:00:00	QQQ	ETF	54.37	54.39	54.26	54.3	199570.0
2011-08-30 08:30:00	QQQ	ETF	54.28	54.29	54.17	54.21	379506.0
2011-08-30 09:00:00	QQQ	ETF	54.19	54.4	54.19	54.4	356732.0
2011-08-30 09:30:00	QQQ	ETF	54.39	54.68	54.3	54.52	7601006.0
2011-08-30 10:00:00	QQQ	ETF	54.49	54.52	54.11	54.439	9814963.0
2011-08-30 10:30:00	QQQ	ETF	54.44	54.59	54.349	54.5	3375614.0
2011-08-30 11:00:00	QQQ	ETF	54.49	54.87	54.44	54.801	3099489.0
2011-08-30 11:30:00	QQQ	ETF	54.79	55.06	54.75	55.04	4141154.0
2011-08-30 12:00:00	QQQ	ETF	55.04	55.05	54.81	54.874	3162198.0
2011-08-30 12:30:00	QQQ	ETF	54.879	54.911	54.58	54.66	3863394.0
2011-08-30 13:00:00	QQQ	ETF	54.6563	54.8517	54.57	54.781	2176647.0
2011-08-30 13:30:00	QQQ	ETF	54.787	54.83	54.6	54.74	2083291.0

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

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