PREVIEW / etf_30min / 2011-08-16

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-16.parquet
  size:    295 KB
  rows:    9,860

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-16 04:00:00	SPY	ETF	119.76	119.76	118.8	118.8	13035.0
2011-08-16 04:30:00	SPY	ETF	118.8	119.02	118.78	118.85	14600.0
2011-08-16 05:00:00	SPY	ETF	118.95	119.16	118.95	119.04	5100.0
2011-08-16 05:30:00	SPY	ETF	119.06	119.26	118.92	119.17	38365.0
2011-08-16 06:00:00	SPY	ETF	119.16	119.16	119.07	119.12	26750.0
2011-08-16 06:30:00	SPY	ETF	119.12	119.16	118.61	118.64	238660.0
2011-08-16 07:00:00	SPY	ETF	118.72	119.06	118.66	118.88	410684.0
2011-08-16 07:30:00	SPY	ETF	118.88	118.92	118.66	118.78	261285.0
2011-08-16 08:00:00	SPY	ETF	118.82	120.24	118.5	118.75	1737877.0
2011-08-16 08:30:00	SPY	ETF	118.75	119.03	118.66	118.98	2706862.0
2011-08-16 09:00:00	SPY	ETF	118.96	119.7	118.94	119.48	5621500.0
2011-08-16 09:30:00	SPY	ETF	119.47	119.84	118.97	119.23	26767196.0
2011-08-16 10:00:00	SPY	ETF	119.23	119.94	119.14	119.89	18123364.0
2011-08-16 10:30:00	SPY	ETF	119.9	120.13	119.58	120.111	15952845.0
2011-08-16 11:00:00	SPY	ETF	120.115	120.12	119.64	119.98	9360307.0
2011-08-16 11:30:00	SPY	ETF	119.975	120.33	119.78	120.2	10626451.0
2011-08-16 12:00:00	SPY	ETF	120.21	120.69	119.27	119.41	35030257.0
2011-08-16 12:30:00	SPY	ETF	119.41	119.72	119.02	119.14	22387272.0
2011-08-16 13:00:00	SPY	ETF	119.14	119.14	118.31	118.8	22642910.0
2011-08-16 13:30:00	SPY	ETF	118.8	119.4	118.68	119.26	13783363.0
2011-08-16 14:00:00	SPY	ETF	119.26	119.82	119.23	119.42	21171495.0
2011-08-16 14:30:00	SPY	ETF	119.41	119.5	118.93	119.005	13417875.0
2011-08-16 15:00:00	SPY	ETF	119.005	120.09	118.95	120.09	14338722.0
2011-08-16 15:30:00	SPY	ETF	120.07	120.15	119.45	119.57	30932257.0
2011-08-16 16:00:00	SPY	ETF	119.57	119.86	119.0	119.7	12949792.0
2011-08-16 16:30:00	SPY	ETF	119.7	120.732	118.54	119.71	13860070.0
2011-08-16 17:00:00	SPY	ETF	119.7	119.75	119.56	119.61	222834.0
2011-08-16 17:30:00	SPY	ETF	119.57	119.62	119.5	119.53	87902.0
2011-08-16 18:00:00	SPY	ETF	119.54	119.6	119.47	119.47	309437.0
2011-08-16 18:30:00	SPY	ETF	119.46	119.48	119.16	119.16	267667.0
2011-08-16 19:00:00	SPY	ETF	119.18	119.28	119.16	119.28	37040.0
2011-08-16 19:30:00	SPY	ETF	119.28	119.33	119.18	119.32	30699.0
2011-08-16 04:00:00	QQQ	ETF	53.96	53.96	53.51	53.51	49943.0
2011-08-16 05:00:00	QQQ	ETF	53.57	53.59	53.57	53.59	400.0
2011-08-16 05:30:00	QQQ	ETF	53.6	53.6	53.58	53.6	700.0
2011-08-16 06:00:00	QQQ	ETF	53.6	53.6	53.6	53.6	400.0
2011-08-16 06:30:00	QQQ	ETF	53.6	53.6	53.5	53.55	4389.0
2011-08-16 07:00:00	QQQ	ETF	53.54	53.66	53.54	53.64	49050.0
2011-08-16 07:30:00	QQQ	ETF	53.65	53.65	53.52	53.57	15100.0
2011-08-16 08:00:00	QQQ	ETF	53.6	53.61	53.48	53.58	713582.0
2011-08-16 08:30:00	QQQ	ETF	53.58	53.68	53.55	53.66	733609.0
2011-08-16 09:00:00	QQQ	ETF	53.66	53.92	53.66	53.82	1228155.0
2011-08-16 09:30:00	QQQ	ETF	53.82	53.97	53.65	53.73	8727555.0
2011-08-16 10:00:00	QQQ	ETF	53.72	54.04	53.68	54.04	4958847.0
2011-08-16 10:30:00	QQQ	ETF	54.04	54.22	53.95	54.21	4249311.0
2011-08-16 11:00:00	QQQ	ETF	54.21	54.211	53.96	54.07	2710164.0
2011-08-16 11:30:00	QQQ	ETF	54.07	54.19	53.98	54.125	1950553.0
2011-08-16 12:00:00	QQQ	ETF	54.123	54.35	53.7	53.77	14626502.0
2011-08-16 12:30:00	QQQ	ETF	53.75	53.87	53.53	53.57	7769981.0
2011-08-16 13:00:00	QQQ	ETF	53.58	53.58	53.18	53.43	8339739.0

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

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