PREVIEW / etf_30min / 2011-10-31

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-31.parquet
  size:    294 KB
  rows:    9,785

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-31 04:00:00	SPY	ETF	128.1	128.1	127.5	127.53	4653.0
2011-10-31 04:30:00	SPY	ETF	127.46	127.46	127.4	127.46	10200.0
2011-10-31 05:00:00	SPY	ETF	127.4	127.48	127.25	127.28	11418.0
2011-10-31 05:30:00	SPY	ETF	127.4	127.4	127.21	127.3	22840.0
2011-10-31 06:00:00	SPY	ETF	127.39	127.51	127.3	127.51	22100.0
2011-10-31 06:30:00	SPY	ETF	127.46	127.56	127.42	127.53	82490.0
2011-10-31 07:00:00	SPY	ETF	127.55	127.61	127.24	127.35	575961.0
2011-10-31 07:30:00	SPY	ETF	127.31	127.38	127.14	127.37	435729.0
2011-10-31 08:00:00	SPY	ETF	127.38	127.45	127.18	127.24	533866.0
2011-10-31 08:30:00	SPY	ETF	127.24	127.25	126.98	127.1	903586.0
2011-10-31 09:00:00	SPY	ETF	127.1	127.32	127.01	127.15	2939738.0
2011-10-31 09:30:00	SPY	ETF	127.16	127.255	126.7	126.87	28138027.0
2011-10-31 10:00:00	SPY	ETF	126.85	127.2	126.72	126.9	14080696.0
2011-10-31 10:30:00	SPY	ETF	126.9	127.26	126.88	126.98	10707900.0
2011-10-31 11:00:00	SPY	ETF	126.99	127.2	126.69	126.83	11676088.0
2011-10-31 11:30:00	SPY	ETF	126.82	127.07	126.78	126.9	9066399.0
2011-10-31 12:00:00	SPY	ETF	126.91	127.02	126.47	126.47	10000190.0
2011-10-31 12:30:00	SPY	ETF	126.47	126.9	126.42	126.679	9610256.0
2011-10-31 13:00:00	SPY	ETF	126.67	128.6239	126.62	126.73	9434568.0
2011-10-31 13:30:00	SPY	ETF	126.73	127.25	126.73	127.1	8943257.0
2011-10-31 14:00:00	SPY	ETF	127.1	127.15	126.79	126.96	8479654.0
2011-10-31 14:30:00	SPY	ETF	126.96	127.01	126.66	126.901	10154516.0
2011-10-31 15:00:00	SPY	ETF	126.9	126.91	126.03	126.04	21870703.0
2011-10-31 15:30:00	SPY	ETF	126.05	126.38	125.36	125.37	43235047.0
2011-10-31 16:00:00	SPY	ETF	125.37	128.6239	125.08	125.25	16032553.0
2011-10-31 16:30:00	SPY	ETF	125.27	125.3	124.77	124.84	6068037.0
2011-10-31 17:00:00	SPY	ETF	124.84	125.465	124.73	124.74	375971.0
2011-10-31 17:30:00	SPY	ETF	124.77	124.79	124.68	124.74	393688.0
2011-10-31 18:00:00	SPY	ETF	124.75	125.45	124.74	124.84	397014.0
2011-10-31 18:30:00	SPY	ETF	124.85	124.94	124.77	124.9	54134.0
2011-10-31 19:00:00	SPY	ETF	124.87	124.96	124.82	124.84	86235.0
2011-10-31 19:30:00	SPY	ETF	124.86	125.04	124.84	124.87	145026.0
2011-10-31 05:00:00	QQQ	ETF	58.38	58.38	58.38	58.38	500.0
2011-10-31 06:00:00	QQQ	ETF	58.45	58.45	58.45	58.45	200.0
2011-10-31 06:30:00	QQQ	ETF	58.4	58.48	58.4	58.48	500.0
2011-10-31 07:00:00	QQQ	ETF	58.56	58.56	58.4	58.43	11616.0
2011-10-31 07:30:00	QQQ	ETF	58.42	58.42	58.33	58.38	88462.0
2011-10-31 08:00:00	QQQ	ETF	58.41	58.45	58.38	58.38	66360.0
2011-10-31 08:30:00	QQQ	ETF	58.37	58.37	58.29	58.33	309989.0
2011-10-31 09:00:00	QQQ	ETF	58.33	58.44	58.28	58.41	460442.0
2011-10-31 09:30:00	QQQ	ETF	58.41	58.43	58.11	58.24	4592789.0
2011-10-31 10:00:00	QQQ	ETF	58.24	58.46	58.17	58.39	3666701.0
2011-10-31 10:30:00	QQQ	ETF	58.38	58.64	58.375	58.42	3677386.0
2011-10-31 11:00:00	QQQ	ETF	58.43	58.51	58.28	58.3374	2596534.0
2011-10-31 11:30:00	QQQ	ETF	58.33	58.52	58.3171	58.38	3611766.0
2011-10-31 12:00:00	QQQ	ETF	58.36	58.38	58.14	58.17	2333668.0
2011-10-31 12:30:00	QQQ	ETF	58.17	58.31	58.15	58.28	3630754.0
2011-10-31 13:00:00	QQQ	ETF	58.28	58.38	58.26	58.28	1032780.0
2011-10-31 13:30:00	QQQ	ETF	58.28	58.54	58.27	58.495	2745789.0
2011-10-31 14:00:00	QQQ	ETF	58.49	58.51	58.3	58.39	2277058.0

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

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