PREVIEW / etf_30min / 2011-09-28

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-28.parquet
  size:    289 KB
  rows:    9,560

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-09-28 04:00:00	SPY	ETF	117.56	117.56	117.31	117.39	2372.0
2011-09-28 04:30:00	SPY	ETF	117.4	117.62	117.2	117.62	8080.0
2011-09-28 05:00:00	SPY	ETF	117.52	118.0	117.52	117.77	14200.0
2011-09-28 05:30:00	SPY	ETF	117.71	118.3	117.65	118.3	15000.0
2011-09-28 06:00:00	SPY	ETF	118.32	118.72	118.07	118.47	258010.0
2011-09-28 06:30:00	SPY	ETF	118.45	118.65	118.37	118.52	145862.0
2011-09-28 07:00:00	SPY	ETF	118.5	118.56	118.17	118.2	282980.0
2011-09-28 07:30:00	SPY	ETF	118.22	118.32	118.04	118.14	650570.0
2011-09-28 08:00:00	SPY	ETF	118.14	118.5	117.83	118.21	2438839.0
2011-09-28 08:30:00	SPY	ETF	118.22	118.42	117.67	117.86	2957763.0
2011-09-28 09:00:00	SPY	ETF	117.86	118.05	117.68	117.78	1757083.0
2011-09-28 09:30:00	SPY	ETF	117.78	118.49	117.55	118.25	23873541.0
2011-09-28 10:00:00	SPY	ETF	118.24	118.25	117.03	117.33	23378566.0
2011-09-28 10:30:00	SPY	ETF	117.33	117.52	116.9	117.29	21950023.0
2011-09-28 11:00:00	SPY	ETF	117.28	117.41	116.86	117.37	21185425.0
2011-09-28 11:30:00	SPY	ETF	117.37	117.98	117.05	117.79	18064929.0
2011-09-28 12:00:00	SPY	ETF	117.78	117.88	117.21	117.58	11749400.0
2011-09-28 12:30:00	SPY	ETF	117.57	117.59	117.1	117.48	9571115.0
2011-09-28 13:00:00	SPY	ETF	117.47	117.49	116.724	116.77	12058702.0
2011-09-28 13:30:00	SPY	ETF	116.76	116.78	116.05	116.11	20303923.0
2011-09-28 14:00:00	SPY	ETF	116.11	116.31	115.81	116.15	15176543.0
2011-09-28 14:30:00	SPY	ETF	116.16	116.47	116.02	116.34	12742803.0
2011-09-28 15:00:00	SPY	ETF	116.35	117.5058	116.05	116.13	20471927.0
2011-09-28 15:30:00	SPY	ETF	116.13	116.17	114.97	115.11	53683656.0
2011-09-28 16:00:00	SPY	ETF	115.11	118.3346	115.05	115.4	9617287.0
2011-09-28 16:30:00	SPY	ETF	115.41	117.5082	115.11	115.31	1408868.0
2011-09-28 17:00:00	SPY	ETF	115.32	115.36	115.23	115.31	1417920.0
2011-09-28 17:30:00	SPY	ETF	115.25	115.37	115.24	115.29	72461.0
2011-09-28 18:00:00	SPY	ETF	115.28	115.28	115.11	115.2	357989.0
2011-09-28 18:30:00	SPY	ETF	115.2	115.35	115.15	115.29	77847.0
2011-09-28 19:00:00	SPY	ETF	115.28	115.3	115.09	115.11	51795.0
2011-09-28 19:30:00	SPY	ETF	115.12	115.15	115.03	115.14	112775.0
2011-09-28 04:00:00	QQQ	ETF	55.24	55.24	55.24	55.24	100.0
2011-09-28 05:00:00	QQQ	ETF	55.4	55.51	55.4	55.51	514.0
2011-09-28 05:30:00	QQQ	ETF	55.52	55.69	55.52	55.69	1200.0
2011-09-28 06:00:00	QQQ	ETF	55.72	55.94	55.72	55.72	5510.0
2011-09-28 06:30:00	QQQ	ETF	55.81	55.85	55.71	55.74	3000.0
2011-09-28 07:00:00	QQQ	ETF	55.75	55.86	55.71	55.74	36860.0
2011-09-28 07:30:00	QQQ	ETF	55.68	55.8	55.68	55.72	68800.0
2011-09-28 08:00:00	QQQ	ETF	55.68	55.72	55.55	55.7	209799.0
2011-09-28 08:30:00	QQQ	ETF	55.72	55.78	55.46	55.58	443618.0
2011-09-28 09:00:00	QQQ	ETF	55.58	55.66	55.52	55.57	625651.0
2011-09-28 09:30:00	QQQ	ETF	55.58	55.97	55.485	55.79	9089358.0
2011-09-28 10:00:00	QQQ	ETF	55.78	55.79	55.25	55.43	9010163.0
2011-09-28 10:30:00	QQQ	ETF	55.43	55.55	55.23	55.43	5581495.0
2011-09-28 11:00:00	QQQ	ETF	55.42	55.495	55.22	55.37	4123251.0
2011-09-28 11:30:00	QQQ	ETF	55.36	55.67	55.22	55.598	3528157.0
2011-09-28 12:00:00	QQQ	ETF	55.61	55.65	55.36	55.5	3590300.0
2011-09-28 12:30:00	QQQ	ETF	55.505	55.53	55.28	55.48	2330690.0
2011-09-28 13:00:00	QQQ	ETF	55.48	55.48	55.12	55.15	3387515.0

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

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