PREVIEW / etf_30min / 2011-07-06

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-06.parquet
  size:    276 KB
  rows:    9,291

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-07-06 04:00:00	SPY	ETF	133.73	133.75	133.62	133.67	1548.0
2011-07-06 05:00:00	SPY	ETF	133.7	133.78	133.65	133.78	1600.0
2011-07-06 05:30:00	SPY	ETF	133.6	133.6	133.59	133.59	4960.0
2011-07-06 06:00:00	SPY	ETF	133.85	133.85	133.69	133.69	7940.0
2011-07-06 06:30:00	SPY	ETF	133.69	133.7	133.45	133.65	59137.0
2011-07-06 07:00:00	SPY	ETF	133.56	133.59	133.3	133.48	262340.0
2011-07-06 07:30:00	SPY	ETF	133.49	133.55	133.41	133.48	221615.0
2011-07-06 08:00:00	SPY	ETF	133.49	133.55	133.3605	133.49	1104676.0
2011-07-06 08:30:00	SPY	ETF	133.48	133.58	133.33	133.48	2141766.0
2011-07-06 09:00:00	SPY	ETF	133.47	133.71	133.39	133.49	885467.0
2011-07-06 09:30:00	SPY	ETF	133.49	133.7	133.41	133.47	17169133.0
2011-07-06 10:00:00	SPY	ETF	133.47	133.63	133.11	133.3878	17582565.0
2011-07-06 10:30:00	SPY	ETF	133.38	133.63	133.32	133.57	10739657.0
2011-07-06 11:00:00	SPY	ETF	133.57	133.65	133.42	133.621	5328780.0
2011-07-06 11:30:00	SPY	ETF	133.625	133.99	133.57	133.9	10147559.0
2011-07-06 12:00:00	SPY	ETF	133.9	133.95	133.81	133.92	5145477.0
2011-07-06 12:30:00	SPY	ETF	133.92	134.14	133.88	134.11	5959139.0
2011-07-06 13:00:00	SPY	ETF	134.1199	134.12	133.77	133.805	7061075.0
2011-07-06 13:30:00	SPY	ETF	133.81	133.99	133.77	133.95	5735139.0
2011-07-06 14:00:00	SPY	ETF	133.95	133.97	133.65	133.78	8098926.0
2011-07-06 14:30:00	SPY	ETF	133.78	133.99	133.71	133.78	7177169.0
2011-07-06 15:00:00	SPY	ETF	133.78	133.9	133.64	133.84	9218776.0
2011-07-06 15:30:00	SPY	ETF	133.849	133.98	133.71	133.96	15404085.0
2011-07-06 16:00:00	SPY	ETF	133.96	134.09	133.6884	134.07	9197198.0
2011-07-06 16:30:00	SPY	ETF	134.07	134.33	134.07	134.25	1601527.0
2011-07-06 17:00:00	SPY	ETF	134.25	134.28	134.2	134.26	93662.0
2011-07-06 17:30:00	SPY	ETF	134.24	134.28	134.23	134.28	9833.0
2011-07-06 18:00:00	SPY	ETF	134.28	134.29	134.22	134.25	33991.0
2011-07-06 18:30:00	SPY	ETF	134.24	134.24	133.94	134.19	128263.0
2011-07-06 19:00:00	SPY	ETF	134.19	134.24	134.17	134.24	16371.0
2011-07-06 19:30:00	SPY	ETF	134.25	134.34	134.25	134.33	27650.0
2011-07-06 04:30:00	QQQ	ETF	58.11	58.11	58.11	58.11	100.0
2011-07-06 05:00:00	QQQ	ETF	58.09	58.09	58.09	58.09	400.0
2011-07-06 05:30:00	QQQ	ETF	58.07	58.12	58.06	58.12	11400.0
2011-07-06 06:00:00	QQQ	ETF	58.16	58.23	58.16	58.23	500.0
2011-07-06 06:30:00	QQQ	ETF	58.21	58.21	58.15	58.19	20300.0
2011-07-06 07:00:00	QQQ	ETF	58.12	58.12	58.05	58.1	45300.0
2011-07-06 07:30:00	QQQ	ETF	58.12	58.13	58.06	58.08	120600.0
2011-07-06 08:00:00	QQQ	ETF	58.09	58.12	58.06	58.12	273135.0
2011-07-06 08:30:00	QQQ	ETF	58.12	58.14	58.05	58.11	138113.0
2011-07-06 09:00:00	QQQ	ETF	58.12	58.15	58.06	58.15	252433.0
2011-07-06 09:30:00	QQQ	ETF	58.14	58.25	58.08	58.1838	6785927.0
2011-07-06 10:00:00	QQQ	ETF	58.18	58.22	57.94	58.025	4584295.0
2011-07-06 10:30:00	QQQ	ETF	58.025	58.195	58.0	58.18	2932513.0
2011-07-06 11:00:00	QQQ	ETF	58.18	58.22	58.095	58.19	2062242.0
2011-07-06 11:30:00	QQQ	ETF	58.19	58.39	58.16	58.35	2558110.0
2011-07-06 12:00:00	QQQ	ETF	58.35	58.3693	58.3	58.34	1107871.0
2011-07-06 12:30:00	QQQ	ETF	58.34	58.49	58.32	58.48	2526528.0
2011-07-06 13:00:00	QQQ	ETF	58.48	58.49	58.31	58.32	1322973.0
2011-07-06 13:30:00	QQQ	ETF	58.32	58.395	58.29	58.375	3219737.0

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

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