PREVIEW / etf_30min / 2011-04-06

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-06.parquet
  size:    281 KB
  rows:    9,391

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-04-06 04:00:00	SPY	ETF	133.29	133.44	133.29	133.44	3215.0
2011-04-06 04:30:00	SPY	ETF	133.39	133.4	133.38	133.4	2300.0
2011-04-06 05:00:00	SPY	ETF	133.42	133.5	133.42	133.49	455.0
2011-04-06 05:30:00	SPY	ETF	133.51	133.65	133.51	133.65	3600.0
2011-04-06 06:00:00	SPY	ETF	133.71	133.8	133.7	133.71	26100.0
2011-04-06 06:30:00	SPY	ETF	133.76	134.04	133.76	134.03	215407.0
2011-04-06 07:00:00	SPY	ETF	134.0	134.05	133.87	133.9	181649.0
2011-04-06 07:30:00	SPY	ETF	133.89	133.96	133.84	133.95	243979.0
2011-04-06 08:00:00	SPY	ETF	133.92	134.08	133.89	133.92	790588.0
2011-04-06 08:30:00	SPY	ETF	133.92	133.93	133.82	133.84	491969.0
2011-04-06 09:00:00	SPY	ETF	133.85	133.89	133.79	133.88	353405.0
2011-04-06 09:30:00	SPY	ETF	133.88	134.0	133.71	133.79	13575324.0
2011-04-06 10:00:00	SPY	ETF	133.79	133.88	133.51	133.71	9101165.0
2011-04-06 10:30:00	SPY	ETF	133.71	133.85	133.6	133.77	9306380.0
2011-04-06 11:00:00	SPY	ETF	133.77	133.78	133.33	133.47	13868712.0
2011-04-06 11:30:00	SPY	ETF	133.46	133.53	133.18	133.19	8836957.0
2011-04-06 12:00:00	SPY	ETF	133.19	133.36	133.12	133.32	7145628.0
2011-04-06 12:30:00	SPY	ETF	133.31	133.38	133.19	133.29	4079386.0
2011-04-06 13:00:00	SPY	ETF	133.29	133.45	133.25	133.41	3735301.0
2011-04-06 13:30:00	SPY	ETF	133.41	133.46	133.33	133.45	3706196.0
2011-04-06 14:00:00	SPY	ETF	133.46	133.56	133.39	133.41	4556692.0
2011-04-06 14:30:00	SPY	ETF	133.41	133.65	133.4	133.58	5010717.0
2011-04-06 15:00:00	SPY	ETF	133.58	133.71	133.53	133.55	6224474.0
2011-04-06 15:30:00	SPY	ETF	133.55	133.7	133.55	133.62	16678931.0
2011-04-06 16:00:00	SPY	ETF	133.62	133.6802	133.03	133.36	7078412.0
2011-04-06 16:30:00	SPY	ETF	133.34	133.59	133.19	133.26	3745340.0
2011-04-06 17:00:00	SPY	ETF	133.25	133.37	133.25	133.36	95667.0
2011-04-06 17:30:00	SPY	ETF	133.37	133.37	133.3	133.35	22595.0
2011-04-06 18:00:00	SPY	ETF	133.37	133.66	133.37	133.37	84507.0
2011-04-06 18:30:00	SPY	ETF	133.37	133.39	133.35	133.39	86686.0
2011-04-06 19:00:00	SPY	ETF	133.38	133.39	133.33	133.36	16264.0
2011-04-06 19:30:00	SPY	ETF	133.35	133.36	133.32	133.33	39657.0
2011-04-06 05:00:00	QQQ	ETF	57.29	57.29	57.29	57.29	3400.0
2011-04-06 05:30:00	QQQ	ETF	57.37	57.37	57.37	57.37	200.0
2011-04-06 06:00:00	QQQ	ETF	57.39	57.39	57.38	57.39	3252.0
2011-04-06 06:30:00	QQQ	ETF	57.46	57.59	57.46	57.58	70560.0
2011-04-06 07:00:00	QQQ	ETF	57.57	57.63	57.53	57.56	124195.0
2011-04-06 07:30:00	QQQ	ETF	57.57	57.58	57.53	57.58	67752.0
2011-04-06 08:00:00	QQQ	ETF	57.55	57.58	57.53	57.55	349555.0
2011-04-06 08:30:00	QQQ	ETF	57.53	57.54	57.46	57.48	146423.0
2011-04-06 09:00:00	QQQ	ETF	57.48	57.55	57.47	57.54	235734.0
2011-04-06 09:30:00	QQQ	ETF	57.54	57.73	57.46	57.59	7027560.0
2011-04-06 10:00:00	QQQ	ETF	57.5901	57.66	57.34	57.44	5003436.0
2011-04-06 10:30:00	QQQ	ETF	57.4375	57.51	57.37	57.45	3787255.0
2011-04-06 11:00:00	QQQ	ETF	57.45	57.459	57.08	57.19	4923118.0
2011-04-06 11:30:00	QQQ	ETF	57.2	57.23	56.98	56.985	2600751.0
2011-04-06 12:00:00	QQQ	ETF	56.99	57.12	56.93	57.071	2720537.0
2011-04-06 12:30:00	QQQ	ETF	57.08	57.1	56.98	57.03	2902847.0
2011-04-06 13:00:00	QQQ	ETF	57.03	57.18	57.02	57.16	1402728.0
2011-04-06 13:30:00	QQQ	ETF	57.16	57.19	57.12	57.1808	693472.0

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

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