PREVIEW / etf_30min / 2013-08-08

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-08.parquet
  size:    320 KB
  rows:    10,751

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-08-08 04:00:00	SPY	ETF	169.43	169.59	169.42	169.53	6100.0
2013-08-08 04:30:00	SPY	ETF	169.56	169.65	169.53	169.64	3000.0
2013-08-08 05:00:00	SPY	ETF	169.59	169.59	169.53	169.59	1000.0
2013-08-08 05:30:00	SPY	ETF	169.65	169.68	169.65	169.65	600.0
2013-08-08 06:00:00	SPY	ETF	169.61	169.73	169.61	169.73	12800.0
2013-08-08 06:30:00	SPY	ETF	169.73	169.9	169.73	169.89	78800.0
2013-08-08 07:00:00	SPY	ETF	169.9	170.03	169.86	169.95	219767.0
2013-08-08 07:30:00	SPY	ETF	169.96	169.97	169.9	169.91	82625.0
2013-08-08 08:00:00	SPY	ETF	169.9	170.0	169.87	169.91	155190.0
2013-08-08 08:30:00	SPY	ETF	169.95	169.99	169.81	169.91	472576.0
2013-08-08 09:00:00	SPY	ETF	169.91	170.07	169.86	169.98	439538.0
2013-08-08 09:30:00	SPY	ETF	169.98	170.18	169.69	169.83	11196262.0
2013-08-08 10:00:00	SPY	ETF	169.83	169.88	169.26	169.42	10990432.0
2013-08-08 10:30:00	SPY	ETF	169.42	169.42	168.93	169.1901	6575611.0
2013-08-08 11:00:00	SPY	ETF	169.19	169.33	169.09	169.33	6820531.0
2013-08-08 11:30:00	SPY	ETF	169.32	169.5	169.27	169.47	3680606.0
2013-08-08 12:00:00	SPY	ETF	169.47	169.86	169.47	169.81	5831541.0
2013-08-08 12:30:00	SPY	ETF	169.81	170.05	169.81	169.96	5614666.0
2013-08-08 13:00:00	SPY	ETF	169.96	170.13	169.9	169.979	3906619.0
2013-08-08 13:30:00	SPY	ETF	169.98	170.05	169.88	170.02	4047027.0
2013-08-08 14:00:00	SPY	ETF	170.02	170.13	169.98	170.109	3569076.0
2013-08-08 14:30:00	SPY	ETF	170.11	170.16	169.92	170.01	8359097.0
2013-08-08 15:00:00	SPY	ETF	170.01	170.07	169.87	169.9725	4564816.0
2013-08-08 15:30:00	SPY	ETF	169.97	170.065	169.79	169.79	8181692.0
2013-08-08 16:00:00	SPY	ETF	169.79	169.94	169.2133	169.86	10361046.0
2013-08-08 16:30:00	SPY	ETF	169.86	169.91	169.2133	169.9	2292673.0
2013-08-08 17:00:00	SPY	ETF	169.9	169.91	169.2133	169.87	2029518.0
2013-08-08 17:30:00	SPY	ETF	169.88	169.89	169.87	169.87	12708.0
2013-08-08 18:00:00	SPY	ETF	169.85	169.93	169.85	169.9	202242.0
2013-08-08 18:30:00	SPY	ETF	169.85	169.85	169.81	169.84	6164.0
2013-08-08 19:00:00	SPY	ETF	169.85	169.9	169.85	169.89	6680.0
2013-08-08 19:30:00	SPY	ETF	169.86	169.88	169.72	169.76	26185.0
2013-08-08 04:00:00	QQQ	ETF	76.59	76.66	76.59	76.64	6800.0
2013-08-08 04:30:00	QQQ	ETF	76.66	76.72	76.66	76.72	5400.0
2013-08-08 05:00:00	QQQ	ETF	76.7	76.72	76.7	76.72	1600.0
2013-08-08 05:30:00	QQQ	ETF	76.74	76.74	76.72	76.72	2000.0
2013-08-08 06:00:00	QQQ	ETF	76.7	76.74	76.7	76.74	1600.0
2013-08-08 06:30:00	QQQ	ETF	76.76	76.8	76.76	76.8	3200.0
2013-08-08 07:00:00	QQQ	ETF	76.82	76.85	76.8	76.83	42050.0
2013-08-08 07:30:00	QQQ	ETF	76.83	76.83	76.82	76.82	5705.0
2013-08-08 08:00:00	QQQ	ETF	76.82	76.85	76.66	76.8	31300.0
2013-08-08 08:30:00	QQQ	ETF	76.82	76.84	76.79	76.81	35830.0
2013-08-08 09:00:00	QQQ	ETF	76.81	76.89	76.81	76.84	160571.0
2013-08-08 09:30:00	QQQ	ETF	76.84	76.91	76.61	76.67	1726292.0
2013-08-08 10:00:00	QQQ	ETF	76.67	76.68	76.33	76.485	2210150.0
2013-08-08 10:30:00	QQQ	ETF	76.48	76.55	76.3	76.5409	1636898.0
2013-08-08 11:00:00	QQQ	ETF	76.54	76.75	76.53	76.75	1329492.0
2013-08-08 11:30:00	QQQ	ETF	76.755	76.815	76.72	76.81	1345832.0
2013-08-08 12:00:00	QQQ	ETF	76.81	76.94	76.809	76.9099	1857317.0
2013-08-08 12:30:00	QQQ	ETF	76.91	76.98	76.89	76.895	906985.0

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

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