PREVIEW / etf_30min / 2011-09-09

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-09.parquet
  size:    287 KB
  rows:    9,567

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-09-09 04:00:00	SPY	ETF	119.2	119.2	118.74	118.74	2418.0
2011-09-09 04:30:00	SPY	ETF	118.8	118.82	118.7	118.82	1101.0
2011-09-09 05:00:00	SPY	ETF	118.95	119.07	118.71	118.81	60300.0
2011-09-09 05:30:00	SPY	ETF	118.73	118.73	118.59	118.65	1300.0
2011-09-09 06:00:00	SPY	ETF	118.59	118.97	118.54	118.97	9900.0
2011-09-09 06:30:00	SPY	ETF	118.84	118.85	118.4	118.5	116767.0
2011-09-09 07:00:00	SPY	ETF	118.51	118.75	118.32	118.58	241007.0
2011-09-09 07:30:00	SPY	ETF	118.56	118.6	118.4	118.6	298404.0
2011-09-09 08:00:00	SPY	ETF	118.6	119.5	118.5	119.02	904956.0
2011-09-09 08:30:00	SPY	ETF	119.03	119.05	118.57	118.6	1885159.0
2011-09-09 09:00:00	SPY	ETF	118.59	118.6	117.6	117.69	5564415.0
2011-09-09 09:30:00	SPY	ETF	117.68	117.89	116.98	117.36	39308541.0
2011-09-09 10:00:00	SPY	ETF	117.36	117.86	117.15	117.85	20570610.0
2011-09-09 10:30:00	SPY	ETF	117.85	118.07	117.5	117.645	16743126.0
2011-09-09 11:00:00	SPY	ETF	117.65	118.1	116.55	116.64	34124561.0
2011-09-09 11:30:00	SPY	ETF	116.64	116.94	115.85	116.09	31298426.0
2011-09-09 12:00:00	SPY	ETF	116.0895	116.24	115.72	115.98	20931779.0
2011-09-09 12:30:00	SPY	ETF	115.98	116.36	115.52	116.269	24049068.0
2011-09-09 13:00:00	SPY	ETF	116.28	116.66	115.92	116.24	19179171.0
2011-09-09 13:30:00	SPY	ETF	116.24	116.26	115.75	115.9	11218282.0
2011-09-09 14:00:00	SPY	ETF	115.8999	116.16	115.58	115.64	23775562.0
2011-09-09 14:30:00	SPY	ETF	115.64	115.99	115.35	115.489	19626566.0
2011-09-09 15:00:00	SPY	ETF	115.48	119.057	115.28	115.384	23266898.0
2011-09-09 15:30:00	SPY	ETF	115.39	116.32	115.38	115.89	50372666.0
2011-09-09 16:00:00	SPY	ETF	115.92	119.057	115.5	116.44	19555599.0
2011-09-09 16:30:00	SPY	ETF	116.44	116.52	115.6436	116.39	11099686.0
2011-09-09 17:00:00	SPY	ETF	116.37	116.39	116.32	116.35	2339171.0
2011-09-09 17:30:00	SPY	ETF	116.34	116.39	116.16	116.2	118392.0
2011-09-09 18:00:00	SPY	ETF	116.17	116.21	115.86	116.08	220857.0
2011-09-09 18:30:00	SPY	ETF	116.08	116.09	116.04	116.05	37358.0
2011-09-09 19:00:00	SPY	ETF	116.08	116.21	116.06	116.1	15832.0
2011-09-09 19:30:00	SPY	ETF	116.17	116.25	116.1	116.2	81290.0
2011-09-09 04:30:00	QQQ	ETF	54.2	54.2	54.2	54.2	100.0
2011-09-09 05:00:00	QQQ	ETF	54.3	54.3	54.3	54.3	500.0
2011-09-09 06:00:00	QQQ	ETF	54.18	54.23	54.18	54.23	5500.0
2011-09-09 07:00:00	QQQ	ETF	54.2	54.3	54.08	54.18	23415.0
2011-09-09 07:30:00	QQQ	ETF	54.2	54.26	54.16	54.26	5600.0
2011-09-09 08:00:00	QQQ	ETF	54.25	54.46	54.22	54.46	572591.0
2011-09-09 08:30:00	QQQ	ETF	54.44	54.44	54.3	54.3	207135.0
2011-09-09 09:00:00	QQQ	ETF	54.29	54.29	53.92	54.02	251077.0
2011-09-09 09:30:00	QQQ	ETF	54.01	54.09	53.69	53.83	7329783.0
2011-09-09 10:00:00	QQQ	ETF	53.83	54.16	53.77	54.1595	3860972.0
2011-09-09 10:30:00	QQQ	ETF	54.16	54.2399	53.99	54.0501	3849170.0
2011-09-09 11:00:00	QQQ	ETF	54.05	54.21	53.55	53.58	5453254.0
2011-09-09 11:30:00	QQQ	ETF	53.57	53.72	53.15	53.27	5524298.0
2011-09-09 12:00:00	QQQ	ETF	53.28	53.8367	53.11	53.22	4150822.0
2011-09-09 12:30:00	QQQ	ETF	53.2201	53.4	53.0	53.37	5118781.0
2011-09-09 13:00:00	QQQ	ETF	53.37	53.5	53.21	53.31	3091779.0
2011-09-09 13:30:00	QQQ	ETF	53.31	53.32	53.07	53.1	1917246.0
2011-09-09 14:00:00	QQQ	ETF	53.12	53.25	52.98	53.01	2504883.0

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

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