PREVIEW / etf_30min / 2011-07-08

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-08.parquet
  size:    282 KB
  rows:    9,495

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-08 04:00:00	SPY	ETF	135.62	135.64	135.62	135.64	800.0
2011-07-08 04:30:00	SPY	ETF	135.37	135.65	135.37	135.65	200.0
2011-07-08 05:00:00	SPY	ETF	135.54	135.54	135.46	135.46	300.0
2011-07-08 05:30:00	SPY	ETF	135.37	135.37	135.2	135.2	1500.0
2011-07-08 06:00:00	SPY	ETF	135.34	135.39	135.26	135.35	5200.0
2011-07-08 06:30:00	SPY	ETF	135.49	135.52	135.42	135.52	1600.0
2011-07-08 07:00:00	SPY	ETF	135.5	135.63	135.46	135.54	56650.0
2011-07-08 07:30:00	SPY	ETF	135.55	135.6	135.46	135.49	363178.0
2011-07-08 08:00:00	SPY	ETF	135.54	135.87	135.49	135.87	4984527.0
2011-07-08 08:30:00	SPY	ETF	135.87	135.87	133.68	133.8	17477366.0
2011-07-08 09:00:00	SPY	ETF	133.81	133.91	133.51	133.83	5131326.0
2011-07-08 09:30:00	SPY	ETF	133.83	134.25	133.82	134.1	24267399.0
2011-07-08 10:00:00	SPY	ETF	134.1	134.115	133.595	133.799	16841459.0
2011-07-08 10:30:00	SPY	ETF	133.79	133.97	133.56	133.76	11492481.0
2011-07-08 11:00:00	SPY	ETF	133.755	133.8	133.39	133.569	13615170.0
2011-07-08 11:30:00	SPY	ETF	133.56	133.93	133.44	133.85	10542011.0
2011-07-08 12:00:00	SPY	ETF	133.85	133.93	133.65	133.73	4538459.0
2011-07-08 12:30:00	SPY	ETF	133.725	135.3558	133.72	133.89	4795948.0
2011-07-08 13:00:00	SPY	ETF	133.89	134.05	133.76	134.03	5949833.0
2011-07-08 13:30:00	SPY	ETF	134.04	134.22	133.91	133.95	7927448.0
2011-07-08 14:00:00	SPY	ETF	133.95	134.11	133.8	133.895	6747064.0
2011-07-08 14:30:00	SPY	ETF	133.9089	134.05	133.9	134.01	6347813.0
2011-07-08 15:00:00	SPY	ETF	134.01	134.19	133.9	134.02	7010949.0
2011-07-08 15:30:00	SPY	ETF	134.01	134.44	133.99	134.41	26496683.0
2011-07-08 16:00:00	SPY	ETF	134.41	134.72	133.9623	134.65	12301870.0
2011-07-08 16:30:00	SPY	ETF	134.65	135.3558	134.6	134.67	3165988.0
2011-07-08 17:00:00	SPY	ETF	134.68	134.72	134.65	134.65	174102.0
2011-07-08 17:30:00	SPY	ETF	134.67	134.67	134.62	134.63	23771.0
2011-07-08 18:00:00	SPY	ETF	134.62	134.65	134.4	134.62	243911.0
2011-07-08 18:30:00	SPY	ETF	134.62	134.69	134.6	134.63	39980.0
2011-07-08 19:00:00	SPY	ETF	134.64	134.67	134.64	134.65	17150.0
2011-07-08 19:30:00	SPY	ETF	134.66	134.71	134.65	134.65	13025.0
2011-07-08 04:00:00	QQQ	ETF	59.34	59.34	59.34	59.34	900.0
2011-07-08 05:30:00	QQQ	ETF	59.24	59.24	59.22	59.22	10100.0
2011-07-08 06:00:00	QQQ	ETF	59.3	59.3	59.26	59.26	900.0
2011-07-08 06:30:00	QQQ	ETF	59.28	59.38	59.28	59.38	1100.0
2011-07-08 07:00:00	QQQ	ETF	59.36	59.42	59.35	59.38	41200.0
2011-07-08 07:30:00	QQQ	ETF	59.37	59.4	59.35	59.36	98271.0
2011-07-08 08:00:00	QQQ	ETF	59.36	59.48	59.35	59.46	4751544.0
2011-07-08 08:30:00	QQQ	ETF	59.36	59.38	58.65	58.68	3489006.0
2011-07-08 09:00:00	QQQ	ETF	58.69	58.71	58.53	58.69	1343091.0
2011-07-08 09:30:00	QQQ	ETF	58.69	58.935	58.67	58.86	7741126.0
2011-07-08 10:00:00	QQQ	ETF	58.86	58.88	58.61	58.671	5214413.0
2011-07-08 10:30:00	QQQ	ETF	58.68	58.69	58.55	58.61	3404595.0
2011-07-08 11:00:00	QQQ	ETF	58.6	58.605	58.37	58.44	3576835.0
2011-07-08 11:30:00	QQQ	ETF	58.45	58.64	58.37	58.585	3392109.0
2011-07-08 12:00:00	QQQ	ETF	58.59	58.65	58.5	58.585	1767774.0
2011-07-08 12:30:00	QQQ	ETF	58.5898	58.75	58.56	58.7	1551427.0
2011-07-08 13:00:00	QQQ	ETF	58.7	58.74	58.6099	58.74	2111374.0
2011-07-08 13:30:00	QQQ	ETF	58.74	58.83	58.682	58.7	2592687.0

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

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