PREVIEW / etf_30min / 2011-07-27

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-27.parquet
  size:    296 KB
  rows:    9,758

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-27 04:30:00	SPY	ETF	133.09	133.09	133.09	133.09	900.0
2011-07-27 05:00:00	SPY	ETF	133.19	133.19	133.19	133.19	100.0
2011-07-27 05:30:00	SPY	ETF	133.14	133.14	133.14	133.14	10000.0
2011-07-27 06:00:00	SPY	ETF	133.0	133.0	133.0	133.0	700.0
2011-07-27 06:30:00	SPY	ETF	133.09	133.09	132.92	132.96	42900.0
2011-07-27 07:00:00	SPY	ETF	132.97	133.08	132.83	132.87	681550.0
2011-07-27 07:30:00	SPY	ETF	132.93	133.0	132.82	132.84	235660.0
2011-07-27 08:00:00	SPY	ETF	132.91	132.91	132.63	132.7	2057680.0
2011-07-27 08:30:00	SPY	ETF	132.65	132.7	132.35	132.47	2416564.0
2011-07-27 09:00:00	SPY	ETF	132.47	132.72	132.47	132.59	2142997.0
2011-07-27 09:30:00	SPY	ETF	132.59	132.63	132.02	132.07	21412438.0
2011-07-27 10:00:00	SPY	ETF	132.07	132.15	131.3	131.36	27441966.0
2011-07-27 10:30:00	SPY	ETF	131.35	131.81	131.21	131.7401	25781727.0
2011-07-27 11:00:00	SPY	ETF	131.75	132.0	131.61	131.99	13873929.0
2011-07-27 11:30:00	SPY	ETF	131.99	132.12	131.56	131.63	16211830.0
2011-07-27 12:00:00	SPY	ETF	131.62	131.75	131.46	131.62	12199159.0
2011-07-27 12:30:00	SPY	ETF	131.62	131.7	131.45	131.47	6950073.0
2011-07-27 13:00:00	SPY	ETF	131.46	131.625	131.31	131.35	8821561.0
2011-07-27 13:30:00	SPY	ETF	131.35	131.63	131.31	131.55	7785388.0
2011-07-27 14:00:00	SPY	ETF	131.55	131.57	131.11	131.13	9234378.0
2011-07-27 14:30:00	SPY	ETF	131.14	131.14	130.75	130.94	19898106.0
2011-07-27 15:00:00	SPY	ETF	130.94	131.07	130.46	130.76	18761758.0
2011-07-27 15:30:00	SPY	ETF	130.76	130.96	130.43	130.61	38318543.0
2011-07-27 16:00:00	SPY	ETF	130.61	131.74	130.29	130.45	6721117.0
2011-07-27 16:30:00	SPY	ETF	130.45	130.55	130.41	130.53	2673079.0
2011-07-27 17:00:00	SPY	ETF	130.52	131.3833	130.4	130.4	429760.0
2011-07-27 17:30:00	SPY	ETF	130.41	130.53	130.41	130.48	28317.0
2011-07-27 18:00:00	SPY	ETF	130.43	130.6	130.35	130.52	720898.0
2011-07-27 18:30:00	SPY	ETF	130.53	130.61	130.48	130.59	186128.0
2011-07-27 19:00:00	SPY	ETF	130.59	130.61	130.51	130.53	121888.0
2011-07-27 19:30:00	SPY	ETF	130.51	130.53	130.3	130.37	164939.0
2011-07-27 07:00:00	QQQ	ETF	59.49	59.53	59.49	59.53	1300.0
2011-07-27 07:30:00	QQQ	ETF	59.47	59.49	59.4	59.4	225438.0
2011-07-27 08:00:00	QQQ	ETF	59.43	59.43	59.32	59.36	1159028.0
2011-07-27 08:30:00	QQQ	ETF	59.36	59.36	59.14	59.16	609035.0
2011-07-27 09:00:00	QQQ	ETF	59.17	59.27	59.17	59.26	203433.0
2011-07-27 09:30:00	QQQ	ETF	59.25	59.29	58.89	58.93	7062120.0
2011-07-27 10:00:00	QQQ	ETF	58.93	58.94	58.37	58.4	7121886.0
2011-07-27 10:30:00	QQQ	ETF	58.4	58.699	58.29	58.66	6215151.0
2011-07-27 11:00:00	QQQ	ETF	58.67	58.83	58.59	58.81	3945513.0
2011-07-27 11:30:00	QQQ	ETF	58.815	58.88	58.56	58.62	5367871.0
2011-07-27 12:00:00	QQQ	ETF	58.615	58.67	58.5	58.6	5248063.0
2011-07-27 12:30:00	QQQ	ETF	58.6	58.66	58.51	58.53	1444806.0
2011-07-27 13:00:00	QQQ	ETF	58.53	58.64	58.44	58.4681	2480203.0
2011-07-27 13:30:00	QQQ	ETF	58.47	58.59	58.43	58.5406	1708541.0
2011-07-27 14:00:00	QQQ	ETF	58.54	58.565	58.27	58.28	4286094.0
2011-07-27 14:30:00	QQQ	ETF	58.28	58.29	58.12	58.28	7007802.0
2011-07-27 15:00:00	QQQ	ETF	58.2771	58.33	57.94	58.091	8272589.0
2011-07-27 15:30:00	QQQ	ETF	58.09	58.2	57.99	58.09	12101721.0
2011-07-27 16:00:00	QQQ	ETF	58.1	58.125	57.96	58.04	3471399.0

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

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