PREVIEW / etf_30min / 2011-11-04

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-04.parquet
  size:    280 KB
  rows:    9,234

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-11-04 04:00:00	SPY	ETF	126.16	126.16	125.85	125.85	400.0
2011-11-04 04:30:00	SPY	ETF	125.73	125.96	125.7	125.74	3850.0
2011-11-04 05:00:00	SPY	ETF	125.82	125.94	125.65	125.94	1300.0
2011-11-04 05:30:00	SPY	ETF	126.03	126.21	126.03	126.21	400.0
2011-11-04 06:00:00	SPY	ETF	126.13	126.24	126.11	126.24	3790.0
2011-11-04 06:30:00	SPY	ETF	126.06	126.26	126.06	126.2	38000.0
2011-11-04 07:00:00	SPY	ETF	126.17	126.17	125.8	125.93	80796.0
2011-11-04 07:30:00	SPY	ETF	125.92	126.15	125.63	125.66	250942.0
2011-11-04 08:00:00	SPY	ETF	125.65	126.13	125.18	125.35	2803287.0
2011-11-04 08:30:00	SPY	ETF	125.27	126.4	125.0	125.41	7564613.0
2011-11-04 09:00:00	SPY	ETF	125.4	125.5	124.95	125.24	3645550.0
2011-11-04 09:30:00	SPY	ETF	125.23	125.52	124.8	124.9	22149030.0
2011-11-04 10:00:00	SPY	ETF	124.9	125.2155	124.34	124.48	19174412.0
2011-11-04 10:30:00	SPY	ETF	124.44	124.51	124.01	124.46	17375886.0
2011-11-04 11:00:00	SPY	ETF	124.46	124.66	124.12	124.459	21798648.0
2011-11-04 11:30:00	SPY	ETF	124.46	124.72	124.29	124.68	16406020.0
2011-11-04 12:00:00	SPY	ETF	124.6884	124.9	124.61	124.84	16827268.0
2011-11-04 12:30:00	SPY	ETF	124.85	124.87	124.44	124.73	9967017.0
2011-11-04 13:00:00	SPY	ETF	124.73	125.27	124.66	125.21	12410889.0
2011-11-04 13:30:00	SPY	ETF	125.21	125.7	125.11	125.46	13433515.0
2011-11-04 14:00:00	SPY	ETF	125.45	125.65	125.32	125.57	10339241.0
2011-11-04 14:30:00	SPY	ETF	125.57	125.66	125.22	125.4	7883413.0
2011-11-04 15:00:00	SPY	ETF	125.41	125.41	124.905	125.151	16983407.0
2011-11-04 15:30:00	SPY	ETF	125.15	125.63	125.1	125.47	30228356.0
2011-11-04 16:00:00	SPY	ETF	125.45	126.2728	124.65	125.87	9518878.0
2011-11-04 16:30:00	SPY	ETF	125.87	125.88	125.65	125.7	9313791.0
2011-11-04 17:00:00	SPY	ETF	125.65	125.85	125.52	125.7	138983.0
2011-11-04 17:30:00	SPY	ETF	125.7	125.84	125.68	125.78	68554.0
2011-11-04 18:00:00	SPY	ETF	125.74	125.79	125.45	125.78	298677.0
2011-11-04 18:30:00	SPY	ETF	125.78	125.93	125.69	125.87	55137.0
2011-11-04 19:00:00	SPY	ETF	125.87	126.04	125.86	126.02	78714.0
2011-11-04 19:30:00	SPY	ETF	126.04	126.2	126.01	126.15	101506.0
2011-11-04 04:00:00	QQQ	ETF	58.08	58.08	58.08	58.08	1000.0
2011-11-04 05:00:00	QQQ	ETF	57.89	57.89	57.89	57.89	100.0
2011-11-04 06:30:00	QQQ	ETF	58.03	58.07	58.03	58.07	1700.0
2011-11-04 07:00:00	QQQ	ETF	58.05	58.05	57.81	57.87	26096.0
2011-11-04 07:30:00	QQQ	ETF	57.86	57.95	57.67	57.69	161128.0
2011-11-04 08:00:00	QQQ	ETF	57.7	57.87	57.6	57.69	1245556.0
2011-11-04 08:30:00	QQQ	ETF	57.81	58.09	57.68	57.7	3361001.0
2011-11-04 09:00:00	QQQ	ETF	57.72	57.79	57.62	57.77	151928.0
2011-11-04 09:30:00	QQQ	ETF	57.78	57.91	57.5	57.53	7315333.0
2011-11-04 10:00:00	QQQ	ETF	57.53	57.63	57.33	57.34	3614743.0
2011-11-04 10:30:00	QQQ	ETF	57.34	57.43	57.22	57.4	2797906.0
2011-11-04 11:00:00	QQQ	ETF	57.4	57.51	57.2819	57.42	2006390.0
2011-11-04 11:30:00	QQQ	ETF	57.41	57.56	57.4	57.52	3486604.0
2011-11-04 12:00:00	QQQ	ETF	57.53	57.68	57.53	57.64	4037026.0
2011-11-04 12:30:00	QQQ	ETF	57.64	57.66	57.47	57.6	2721524.0
2011-11-04 13:00:00	QQQ	ETF	57.59	57.87	57.55	57.82	4166074.0
2011-11-04 13:30:00	QQQ	ETF	57.82	58.05	57.8	57.949	3188557.0
2011-11-04 14:00:00	QQQ	ETF	57.955	58.01	57.89	57.97	1721942.0

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

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