PREVIEW / etf_30min / 2011-04-18

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-18.parquet
  size:    293 KB
  rows:    9,675

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-18 04:00:00	SPY	ETF	132.3	132.3	131.73	131.73	102079.0
2011-04-18 04:30:00	SPY	ETF	131.65	131.65	131.48	131.48	2100.0
2011-04-18 05:00:00	SPY	ETF	131.57	131.66	131.47	131.47	3500.0
2011-04-18 05:30:00	SPY	ETF	131.5	131.55	131.47	131.54	26000.0
2011-04-18 06:00:00	SPY	ETF	131.5	131.5	131.37	131.4	11000.0
2011-04-18 06:30:00	SPY	ETF	131.4	131.43	131.3	131.42	134950.0
2011-04-18 07:00:00	SPY	ETF	131.42	131.55	131.39	131.51	184127.0
2011-04-18 07:30:00	SPY	ETF	131.5	131.5	131.35	131.41	268093.0
2011-04-18 08:00:00	SPY	ETF	131.42	132.08	131.37	131.53	778854.0
2011-04-18 08:30:00	SPY	ETF	131.53	131.57	131.37	131.4	849168.0
2011-04-18 09:00:00	SPY	ETF	131.39	131.45	130.33	130.58	12134396.0
2011-04-18 09:30:00	SPY	ETF	130.59	130.6	129.97	130.01	32336919.0
2011-04-18 10:00:00	SPY	ETF	130.01	130.24	129.6	130.0799	25754892.0
2011-04-18 10:30:00	SPY	ETF	130.07	130.25	129.63	129.69	15445037.0
2011-04-18 11:00:00	SPY	ETF	129.7	129.95	129.51	129.8901	17863489.0
2011-04-18 11:30:00	SPY	ETF	129.895	130.1	129.765	130.01	8131649.0
2011-04-18 12:00:00	SPY	ETF	130.02	130.12	129.85	129.94	5342367.0
2011-04-18 12:30:00	SPY	ETF	129.94	130.0	129.87	129.96	3724847.0
2011-04-18 13:00:00	SPY	ETF	129.96	130.17	129.76	129.87	3794918.0
2011-04-18 13:30:00	SPY	ETF	129.865	130.24	129.85	130.2	8514294.0
2011-04-18 14:00:00	SPY	ETF	130.2	132.0301	130.07	130.2	12205204.0
2011-04-18 14:30:00	SPY	ETF	130.2	132.0301	130.18	130.53	14516531.0
2011-04-18 15:00:00	SPY	ETF	130.53	130.81	130.29	130.63	13576698.0
2011-04-18 15:30:00	SPY	ETF	130.64	130.8	130.36	130.55	22807416.0
2011-04-18 16:00:00	SPY	ETF	130.56	130.68	130.04	130.57	8383060.0
2011-04-18 16:30:00	SPY	ETF	130.59	132.0301	130.34	130.41	2846510.0
2011-04-18 17:00:00	SPY	ETF	130.4	130.43	130.36	130.43	108294.0
2011-04-18 17:30:00	SPY	ETF	130.42	130.47	130.39	130.41	38276.0
2011-04-18 18:00:00	SPY	ETF	130.43	130.53	130.36	130.42	229131.0
2011-04-18 18:30:00	SPY	ETF	130.41	130.41	130.25	130.3	56446.0
2011-04-18 19:00:00	SPY	ETF	130.28	130.29	130.21	130.27	37337.0
2011-04-18 19:30:00	SPY	ETF	130.23	130.32	130.2	130.3	56665.0
2011-04-18 04:00:00	QQQ	ETF	56.59	56.6	56.55	56.55	600.0
2011-04-18 05:00:00	QQQ	ETF	56.51	56.51	56.51	56.51	1500.0
2011-04-18 05:30:00	QQQ	ETF	56.52	56.53	56.48	56.53	40100.0
2011-04-18 06:00:00	QQQ	ETF	56.5	56.5	56.44	56.44	1400.0
2011-04-18 06:30:00	QQQ	ETF	56.44	56.44	56.4	56.44	12026.0
2011-04-18 07:00:00	QQQ	ETF	56.45	56.49	56.41	56.47	72149.0
2011-04-18 07:30:00	QQQ	ETF	56.46	56.46	56.41	56.41	38507.0
2011-04-18 08:00:00	QQQ	ETF	56.47	56.51	56.44	56.5	109733.0
2011-04-18 08:30:00	QQQ	ETF	56.48	56.51	56.44	56.46	195945.0
2011-04-18 09:00:00	QQQ	ETF	56.45	56.47	55.86	56.08	3025829.0
2011-04-18 09:30:00	QQQ	ETF	56.09	56.1	55.55	55.6	10538285.0
2011-04-18 10:00:00	QQQ	ETF	55.59	55.62	55.32	55.53	8232871.0
2011-04-18 10:30:00	QQQ	ETF	55.53	55.62	55.37	55.425	3112198.0
2011-04-18 11:00:00	QQQ	ETF	55.41	55.57	55.37	55.535	3201881.0
2011-04-18 11:30:00	QQQ	ETF	55.54	55.67	55.51	55.63	2223464.0
2011-04-18 12:00:00	QQQ	ETF	55.6384	55.71	55.59	55.64	1618504.0
2011-04-18 12:30:00	QQQ	ETF	55.6392	55.68	55.61	55.66	1127500.0
2011-04-18 13:00:00	QQQ	ETF	55.67	55.675	55.53	55.6	1191968.0

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

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