PREVIEW / etf_30min / 2013-09-24

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-24.parquet
  size:    320 KB
  rows:    10,609

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
2013-09-24 04:00:00	SPY	ETF	169.65	169.65	169.5	169.65	14775.0
2013-09-24 04:30:00	SPY	ETF	169.63	169.7	169.61	169.67	5200.0
2013-09-24 05:00:00	SPY	ETF	169.7	169.7	169.58	169.58	1500.0
2013-09-24 05:30:00	SPY	ETF	169.55	169.56	169.46	169.56	4500.0
2013-09-24 06:00:00	SPY	ETF	169.54	169.64	169.49	169.64	12700.0
2013-09-24 06:30:00	SPY	ETF	169.67	169.67	169.64	169.64	38300.0
2013-09-24 07:00:00	SPY	ETF	169.63	169.73	169.56	169.73	22545.0
2013-09-24 07:30:00	SPY	ETF	169.75	169.75	169.42	169.46	266217.0
2013-09-24 08:00:00	SPY	ETF	169.55	169.67	169.46	169.63	150343.0
2013-09-24 08:30:00	SPY	ETF	169.66	169.8	169.58	169.77	389899.0
2013-09-24 09:00:00	SPY	ETF	169.79	169.94	169.76	169.91	830575.0
2013-09-24 09:30:00	SPY	ETF	169.9	169.92	169.57	169.645	11592535.0
2013-09-24 10:00:00	SPY	ETF	169.64	169.66	169.21	169.66	9679686.0
2013-09-24 10:30:00	SPY	ETF	169.65	170.14	169.59	170.04	9740715.0
2013-09-24 11:00:00	SPY	ETF	170.04	170.27	170.04	170.09	6245252.0
2013-09-24 11:30:00	SPY	ETF	170.09	170.2	170.06	170.19	5673399.0
2013-09-24 12:00:00	SPY	ETF	170.19	170.25	170.07	170.23	4741439.0
2013-09-24 12:30:00	SPY	ETF	170.235	170.43	170.2	170.29	4888733.0
2013-09-24 13:00:00	SPY	ETF	170.3	170.39	170.25	170.37	2528896.0
2013-09-24 13:30:00	SPY	ETF	170.38	170.53	170.34	170.34	4064758.0
2013-09-24 14:00:00	SPY	ETF	170.35	170.4	170.08	170.14	4210657.0
2013-09-24 14:30:00	SPY	ETF	170.13	170.23	170.075	170.09	3261464.0
2013-09-24 15:00:00	SPY	ETF	170.09	170.17	169.88	169.92	5616458.0
2013-09-24 15:30:00	SPY	ETF	169.92	169.92	169.37	169.53	15357808.0
2013-09-24 16:00:00	SPY	ETF	169.53	170.2001	169.4858	169.64	3925907.0
2013-09-24 16:30:00	SPY	ETF	169.64	170.15	169.4703	169.64	4282750.0
2013-09-24 17:00:00	SPY	ETF	169.64	169.8959	169.58	169.6	544806.0
2013-09-24 17:30:00	SPY	ETF	169.61	169.64	169.59	169.62	126697.0
2013-09-24 18:00:00	SPY	ETF	169.64	169.66	169.58	169.58	158930.0
2013-09-24 18:30:00	SPY	ETF	169.6	169.6	169.55	169.55	6100.0
2013-09-24 19:00:00	SPY	ETF	169.55	169.6	169.54	169.56	11183.0
2013-09-24 19:30:00	SPY	ETF	169.55	169.56	169.52	169.55	65135.0
2013-09-24 04:30:00	QQQ	ETF	78.82	78.84	78.8	78.84	14100.0
2013-09-24 05:00:00	QQQ	ETF	78.86	78.86	78.8	78.82	7000.0
2013-09-24 05:30:00	QQQ	ETF	78.8	78.8	78.78	78.78	2500.0
2013-09-24 06:00:00	QQQ	ETF	78.78	78.85	78.78	78.85	4800.0
2013-09-24 06:30:00	QQQ	ETF	78.84	78.85	78.84	78.85	500.0
2013-09-24 07:00:00	QQQ	ETF	78.82	78.86	78.81	78.86	5500.0
2013-09-24 07:30:00	QQQ	ETF	78.84	78.84	78.78	78.78	6300.0
2013-09-24 08:00:00	QQQ	ETF	78.75	78.83	78.74	78.82	12705.0
2013-09-24 08:30:00	QQQ	ETF	78.84	78.9	78.82	78.9	26450.0
2013-09-24 09:00:00	QQQ	ETF	78.9	79.01	78.9	78.99	89436.0
2013-09-24 09:30:00	QQQ	ETF	79.0	79.02	78.82	78.83	3146759.0
2013-09-24 10:00:00	QQQ	ETF	78.8234	78.87	78.57	78.87	3286014.0
2013-09-24 10:30:00	QQQ	ETF	78.88	79.15	78.83	79.1	1770443.0
2013-09-24 11:00:00	QQQ	ETF	79.1	79.18	79.047	79.06	1860697.0
2013-09-24 11:30:00	QQQ	ETF	79.07	79.12	79.02	79.09	539609.0
2013-09-24 12:00:00	QQQ	ETF	79.08	79.1	79.011	79.08	607096.0
2013-09-24 12:30:00	QQQ	ETF	79.0799	79.17	79.05	79.1	552230.0
2013-09-24 13:00:00	QQQ	ETF	79.1	79.18	79.07	79.16	294882.0

> showing 50 of 10,609 rows — these rows as CSV

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