PREVIEW / etf_30min / 2011-02-25

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-25.parquet
  size:    278 KB
  rows:    9,311

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-02-25 04:00:00	SPY	ETF	131.25	131.42	131.2	131.42	3125.0
2011-02-25 04:30:00	SPY	ETF	131.41	131.44	131.39	131.41	21442.0
2011-02-25 05:30:00	SPY	ETF	131.45	131.5	131.39	131.39	15900.0
2011-02-25 06:00:00	SPY	ETF	131.44	131.58	131.36	131.56	10600.0
2011-02-25 06:30:00	SPY	ETF	131.54	131.61	131.5	131.5	6312.0
2011-02-25 07:00:00	SPY	ETF	131.53	131.72	131.53	131.67	259036.0
2011-02-25 07:30:00	SPY	ETF	131.67	131.7	131.42	131.44	293228.0
2011-02-25 08:00:00	SPY	ETF	131.46	131.65	131.39	131.57	1120258.0
2011-02-25 08:30:00	SPY	ETF	131.57	131.6	131.34	131.58	1014016.0
2011-02-25 09:00:00	SPY	ETF	131.58	131.58	131.39	131.49	1218297.0
2011-02-25 09:30:00	SPY	ETF	131.48	131.93	131.4	131.92	19062162.0
2011-02-25 10:00:00	SPY	ETF	131.91	132.18	131.89	131.96	13502662.0
2011-02-25 10:30:00	SPY	ETF	131.96	132.22	131.9	132.12	8680140.0
2011-02-25 11:00:00	SPY	ETF	132.11	132.18	131.83	131.85	10289490.0
2011-02-25 11:30:00	SPY	ETF	131.85	131.96	131.66	131.86	9711841.0
2011-02-25 12:00:00	SPY	ETF	131.85	132.11	131.815	132.06	6121087.0
2011-02-25 12:30:00	SPY	ETF	132.06	132.17	132.0	132.14	4000729.0
2011-02-25 13:00:00	SPY	ETF	132.13	132.37	132.09	132.3133	6954065.0
2011-02-25 13:30:00	SPY	ETF	132.32	132.38	132.18	132.25	6527858.0
2011-02-25 14:00:00	SPY	ETF	132.25	132.41	132.15	132.29	7391461.0
2011-02-25 14:30:00	SPY	ETF	132.29	132.39	132.21	132.32	5452572.0
2011-02-25 15:00:00	SPY	ETF	132.32	132.37	132.17	132.26	7839591.0
2011-02-25 15:30:00	SPY	ETF	132.26	132.37	132.14	132.32	19269258.0
2011-02-25 16:00:00	SPY	ETF	132.32	132.33	131.8543	132.26	7159032.0
2011-02-25 16:30:00	SPY	ETF	132.25	132.3	130.9435	132.12	4747870.0
2011-02-25 17:00:00	SPY	ETF	132.13	132.32	132.09	132.31	199516.0
2011-02-25 17:30:00	SPY	ETF	132.31	132.34	132.28	132.29	49356.0
2011-02-25 18:00:00	SPY	ETF	132.29	132.32	132.07	132.19	171071.0
2011-02-25 18:30:00	SPY	ETF	132.18	132.18	132.15	132.15	5497.0
2011-02-25 19:00:00	SPY	ETF	132.16	132.2	132.16	132.19	12950.0
2011-02-25 19:30:00	SPY	ETF	132.19	132.28	132.18	132.28	16444.0
2011-02-25 04:00:00	QQQ	ETF	57.02	57.08	57.01	57.08	20485.0
2011-02-25 04:30:00	QQQ	ETF	57.07	57.11	57.07	57.1	21564.0
2011-02-25 05:00:00	QQQ	ETF	57.08	57.08	57.08	57.08	700.0
2011-02-25 05:30:00	QQQ	ETF	57.1	57.12	57.1	57.12	300.0
2011-02-25 06:00:00	QQQ	ETF	57.1	57.16	57.1	57.15	6000.0
2011-02-25 06:30:00	QQQ	ETF	57.15	57.15	57.15	57.15	200.0
2011-02-25 07:00:00	QQQ	ETF	57.12	57.2	57.12	57.18	152702.0
2011-02-25 07:30:00	QQQ	ETF	57.19	57.19	57.12	57.13	16631.0
2011-02-25 08:00:00	QQQ	ETF	57.13	57.2	57.09	57.14	323700.0
2011-02-25 08:30:00	QQQ	ETF	57.15	57.21	57.06	57.2	347280.0
2011-02-25 09:00:00	QQQ	ETF	57.2	57.23	57.13	57.16	367823.0
2011-02-25 09:30:00	QQQ	ETF	57.15	57.44	57.12	57.41	9061486.0
2011-02-25 10:00:00	QQQ	ETF	57.42	57.6	57.38	57.51	5452914.0
2011-02-25 10:30:00	QQQ	ETF	57.51	57.69	57.45	57.65	4721497.0
2011-02-25 11:00:00	QQQ	ETF	57.6582	57.72	57.51	57.52	4153728.0
2011-02-25 11:30:00	QQQ	ETF	57.525	57.58	57.363	57.4698	6965612.0
2011-02-25 12:00:00	QQQ	ETF	57.46	57.61	57.4375	57.58	2305505.0
2011-02-25 12:30:00	QQQ	ETF	57.57	57.64	57.55	57.61	1353351.0
2011-02-25 13:00:00	QQQ	ETF	57.61	57.7	57.57	57.67	2240561.0

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

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