PREVIEW / etf_30min / 2011-11-29

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-29.parquet
  size:    283 KB
  rows:    9,547

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-11-29 04:00:00	SPY	ETF	119.5	120.01	119.5	120.01	46450.0
2011-11-29 04:30:00	SPY	ETF	120.14	120.2	120.04	120.2	51850.0
2011-11-29 05:00:00	SPY	ETF	120.24	121.18	120.24	120.82	14452.0
2011-11-29 05:30:00	SPY	ETF	120.9	121.09	120.76	120.92	31981.0
2011-11-29 06:00:00	SPY	ETF	120.88	120.99	120.7	120.91	144273.0
2011-11-29 06:30:00	SPY	ETF	120.83	120.98	120.73	120.75	57927.0
2011-11-29 07:00:00	SPY	ETF	120.73	120.73	120.29	120.47	1194091.0
2011-11-29 07:30:00	SPY	ETF	120.43	120.59	120.2	120.28	973930.0
2011-11-29 08:00:00	SPY	ETF	120.25	120.69	120.18	120.28	2566736.0
2011-11-29 08:30:00	SPY	ETF	120.28	120.28	119.83	120.1	1759454.0
2011-11-29 09:00:00	SPY	ETF	120.1	120.23	119.85	120.06	2922325.0
2011-11-29 09:30:00	SPY	ETF	120.05	120.31	119.61	120.21	21197322.0
2011-11-29 10:00:00	SPY	ETF	120.21	120.86	119.99	120.65	32291356.0
2011-11-29 10:30:00	SPY	ETF	120.66	120.82	120.38	120.485	14953304.0
2011-11-29 11:00:00	SPY	ETF	120.48	120.595	120.17	120.509	11981564.0
2011-11-29 11:30:00	SPY	ETF	120.5	120.8	120.3	120.43	12733494.0
2011-11-29 12:00:00	SPY	ETF	120.4304	121.0	120.37	120.689	7227403.0
2011-11-29 12:30:00	SPY	ETF	120.68	120.685	120.21	120.39	9933967.0
2011-11-29 13:00:00	SPY	ETF	120.4	120.49	120.05	120.37	7565128.0
2011-11-29 13:30:00	SPY	ETF	120.38	120.39	119.83	119.9206	10704287.0
2011-11-29 14:00:00	SPY	ETF	119.92	120.12	119.77	120.06	8153112.0
2011-11-29 14:30:00	SPY	ETF	120.07	120.33	120.0	120.17	8468537.0
2011-11-29 15:00:00	SPY	ETF	120.18	120.63	120.085	120.34	10993981.0
2011-11-29 15:30:00	SPY	ETF	120.34	120.59	119.95	120.03	19467101.0
2011-11-29 16:00:00	SPY	ETF	120.03	120.3	119.95	120.0	7730666.0
2011-11-29 16:30:00	SPY	ETF	120.05	120.05	119.48	119.63	2013314.0
2011-11-29 17:00:00	SPY	ETF	119.61	119.75	119.47	119.65	2774274.0
2011-11-29 17:30:00	SPY	ETF	119.65	119.85	119.61	119.73	142817.0
2011-11-29 18:00:00	SPY	ETF	119.74	120.08	119.49	119.51	243334.0
2011-11-29 18:30:00	SPY	ETF	119.5	119.64	119.47	119.55	61418.0
2011-11-29 19:00:00	SPY	ETF	119.58	119.75	119.5	119.75	88870.0
2011-11-29 19:30:00	SPY	ETF	119.69	119.83	119.65	119.77	119859.0
2011-11-29 04:30:00	QQQ	ETF	54.77	54.77	54.77	54.77	600.0
2011-11-29 05:00:00	QQQ	ETF	54.88	55.11	54.88	55.03	6550.0
2011-11-29 05:30:00	QQQ	ETF	55.06	55.19	55.06	55.09	9408.0
2011-11-29 06:00:00	QQQ	ETF	55.14	55.14	55.06	55.06	8554.0
2011-11-29 06:30:00	QQQ	ETF	55.09	55.14	55.0	55.0	2284.0
2011-11-29 07:00:00	QQQ	ETF	55.0	55.0	54.76	54.83	594366.0
2011-11-29 07:30:00	QQQ	ETF	54.82	54.87	54.7	54.71	266613.0
2011-11-29 08:00:00	QQQ	ETF	54.71	54.83	54.68	54.78	2268113.0
2011-11-29 08:30:00	QQQ	ETF	54.76	54.76	54.59	54.69	716874.0
2011-11-29 09:00:00	QQQ	ETF	54.67	54.74	54.58	54.66	239275.0
2011-11-29 09:30:00	QQQ	ETF	54.66	54.91	54.5	54.89	3791784.0
2011-11-29 10:00:00	QQQ	ETF	54.88	55.1	54.71	54.95	6998874.0
2011-11-29 10:30:00	QQQ	ETF	54.95	55.0	54.73	54.81	2298996.0
2011-11-29 11:00:00	QQQ	ETF	54.8	54.83	54.62	54.7	2358637.0
2011-11-29 11:30:00	QQQ	ETF	54.71	54.879	54.51	54.59	4164283.0
2011-11-29 12:00:00	QQQ	ETF	54.595	54.74	54.56	54.65	1619241.0
2011-11-29 12:30:00	QQQ	ETF	54.65	54.65	54.4	54.5	3611160.0
2011-11-29 13:00:00	QQQ	ETF	54.49	54.57	54.31	54.52	2052367.0

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

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