PREVIEW / etf_30min / 2011-10-05

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-05.parquet
  size:    293 KB
  rows:    9,783

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-10-05 04:00:00	SPY	ETF	111.53	111.8	111.53	111.8	2619.0
2011-10-05 04:30:00	SPY	ETF	111.99	112.09	111.91	112.09	5270.0
2011-10-05 05:00:00	SPY	ETF	111.93	111.93	111.78	111.93	525.0
2011-10-05 05:30:00	SPY	ETF	111.71	111.86	111.56	111.86	4380.0
2011-10-05 06:00:00	SPY	ETF	111.83	112.56	111.8	112.52	10145.0
2011-10-05 06:30:00	SPY	ETF	112.51	113.11	112.37	112.87	242075.0
2011-10-05 07:00:00	SPY	ETF	112.89	112.97	112.63	112.68	528821.0
2011-10-05 07:30:00	SPY	ETF	112.64	112.72	112.4	112.44	581406.0
2011-10-05 08:00:00	SPY	ETF	112.43	112.89	111.38	112.35	2484251.0
2011-10-05 08:30:00	SPY	ETF	112.34	112.44	111.95	112.01	2679563.0
2011-10-05 09:00:00	SPY	ETF	112.04	112.69	112.0	112.62	2477095.0
2011-10-05 09:30:00	SPY	ETF	112.62	112.62	111.58	112.06	34476871.0
2011-10-05 10:00:00	SPY	ETF	112.05	112.95	111.94	112.37	32085374.0
2011-10-05 10:30:00	SPY	ETF	112.375	113.5	112.36	113.42	30242872.0
2011-10-05 11:00:00	SPY	ETF	113.41	113.46	112.77	112.98	13391468.0
2011-10-05 11:30:00	SPY	ETF	112.98	113.42	112.92	113.28	10344468.0
2011-10-05 12:00:00	SPY	ETF	113.28	113.4	112.61	112.64	12140221.0
2011-10-05 12:30:00	SPY	ETF	112.645	112.88	112.38	112.8	10868991.0
2011-10-05 13:00:00	SPY	ETF	112.81	113.46	112.8	113.39	11971770.0
2011-10-05 13:30:00	SPY	ETF	113.4	113.94	113.16	113.83	12172289.0
2011-10-05 14:00:00	SPY	ETF	113.83	113.96	113.54	113.785	11956894.0
2011-10-05 14:30:00	SPY	ETF	113.79	114.0	113.25	113.77	16285177.0
2011-10-05 15:00:00	SPY	ETF	113.77	114.02	113.33	113.83	21339167.0
2011-10-05 15:30:00	SPY	ETF	113.84	114.72	113.81	114.46	41737090.0
2011-10-05 16:00:00	SPY	ETF	114.47	114.56	112.4548	114.14	10769038.0
2011-10-05 16:30:00	SPY	ETF	114.13	114.4611	114.08	114.19	804449.0
2011-10-05 17:00:00	SPY	ETF	114.19	114.55	114.08	114.23	238791.0
2011-10-05 17:30:00	SPY	ETF	114.24	114.31	114.19	114.2	144857.0
2011-10-05 18:00:00	SPY	ETF	114.17	114.5	114.0	114.09	239106.0
2011-10-05 18:30:00	SPY	ETF	114.1	114.11	113.95	113.95	98863.0
2011-10-05 19:00:00	SPY	ETF	113.95	114.12	113.93	114.08	124732.0
2011-10-05 19:30:00	SPY	ETF	114.11	114.19	113.8	113.94	130053.0
2011-10-05 04:00:00	QQQ	ETF	51.88	51.98	51.77	51.77	11920.0
2011-10-05 05:30:00	QQQ	ETF	51.85	51.93	51.8	51.93	2200.0
2011-10-05 06:00:00	QQQ	ETF	51.9	52.16	51.9	52.16	1829.0
2011-10-05 06:30:00	QQQ	ETF	52.2	52.37	52.2	52.3	29900.0
2011-10-05 07:00:00	QQQ	ETF	52.31	52.37	52.23	52.32	326700.0
2011-10-05 07:30:00	QQQ	ETF	52.32	52.32	52.13	52.14	162450.0
2011-10-05 08:00:00	QQQ	ETF	52.17	52.34	52.0	52.09	979701.0
2011-10-05 08:30:00	QQQ	ETF	52.08	52.16	51.9	51.93	801227.0
2011-10-05 09:00:00	QQQ	ETF	51.94	52.2	51.92	52.08	382102.0
2011-10-05 09:30:00	QQQ	ETF	52.08	52.08	51.66	51.92	11652238.0
2011-10-05 10:00:00	QQQ	ETF	51.93	52.44	51.88	52.14	13069444.0
2011-10-05 10:30:00	QQQ	ETF	52.14	52.96	52.13	52.92	10842454.0
2011-10-05 11:00:00	QQQ	ETF	52.92	52.95	52.62	52.76	6838394.0
2011-10-05 11:30:00	QQQ	ETF	52.76	53.12	52.75	53.04	4114027.0
2011-10-05 12:00:00	QQQ	ETF	53.05	53.11	52.6303	52.6505	5034166.0
2011-10-05 12:30:00	QQQ	ETF	52.65	52.89	52.57	52.88	4838132.0
2011-10-05 13:00:00	QQQ	ETF	52.88	53.15	52.85	53.11	6186949.0
2011-10-05 13:30:00	QQQ	ETF	53.11	53.48	52.98	53.42	4569842.0

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

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