PREVIEW / etf_30min / 2013-10-04

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-04.parquet
  size:    307 KB
  rows:    10,270

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-10-04 04:00:00	SPY	ETF	167.65	167.65	167.56	167.6	33020.0
2013-10-04 04:30:00	SPY	ETF	167.61	167.92	167.61	167.87	30703.0
2013-10-04 05:00:00	SPY	ETF	167.86	167.9	167.84	167.88	29730.0
2013-10-04 05:30:00	SPY	ETF	167.89	167.93	167.84	167.9	2868.0
2013-10-04 06:00:00	SPY	ETF	167.88	167.9	167.86	167.9	5600.0
2013-10-04 06:30:00	SPY	ETF	167.9	167.94	167.85	167.92	32803.0
2013-10-04 07:00:00	SPY	ETF	167.91	168.0	167.88	167.88	104088.0
2013-10-04 07:30:00	SPY	ETF	167.86	167.87	167.78	167.87	86378.0
2013-10-04 08:00:00	SPY	ETF	167.84	168.03	167.67	167.82	198201.0
2013-10-04 08:30:00	SPY	ETF	167.81	167.9	167.67	167.89	415535.0
2013-10-04 09:00:00	SPY	ETF	167.87	167.95	167.7	167.74	411039.0
2013-10-04 09:30:00	SPY	ETF	167.75	168.27	167.53	168.15	11238825.0
2013-10-04 10:00:00	SPY	ETF	168.19	168.445	168.08	168.29	8175409.0
2013-10-04 10:30:00	SPY	ETF	168.29	168.65	168.22	168.26	8516493.0
2013-10-04 11:00:00	SPY	ETF	168.265	168.34	167.97	168.14	8135292.0
2013-10-04 11:30:00	SPY	ETF	168.15	168.47	168.1	168.4	4992657.0
2013-10-04 12:00:00	SPY	ETF	168.4	168.83	168.35	168.8201	5778209.0
2013-10-04 12:30:00	SPY	ETF	168.82	168.89	168.685	168.75	5201118.0
2013-10-04 13:00:00	SPY	ETF	168.75	168.82	168.64	168.69	3410502.0
2013-10-04 13:30:00	SPY	ETF	168.69	168.83	168.615	168.64	4423874.0
2013-10-04 14:00:00	SPY	ETF	168.64	168.85	168.64	168.829	3558538.0
2013-10-04 14:30:00	SPY	ETF	168.8299	169.045	168.76	168.97	4201535.0
2013-10-04 15:00:00	SPY	ETF	168.9638	169.06	168.79	168.84	5102041.0
2013-10-04 15:30:00	SPY	ETF	168.84	168.94	168.65	168.86	12537773.0
2013-10-04 16:00:00	SPY	ETF	168.86	168.98	168.61	168.92	7916142.0
2013-10-04 16:30:00	SPY	ETF	168.91	168.96	168.75	168.76	674665.0
2013-10-04 17:00:00	SPY	ETF	168.76	168.76	168.6	168.65	160181.0
2013-10-04 17:30:00	SPY	ETF	168.69	168.74	168.5506	168.66	239610.0
2013-10-04 18:00:00	SPY	ETF	168.7	168.75	168.7	168.73	3888.0
2013-10-04 18:30:00	SPY	ETF	168.75	168.76	168.75	168.75	300.0
2013-10-04 19:00:00	SPY	ETF	168.75	168.77	168.71	168.77	2177.0
2013-10-04 19:30:00	SPY	ETF	168.78	168.91	168.7	168.84	18363.0
2013-10-04 04:00:00	QQQ	ETF	78.73	78.73	78.66	78.7	12600.0
2013-10-04 04:30:00	QQQ	ETF	78.71	78.86	78.71	78.82	13900.0
2013-10-04 05:00:00	QQQ	ETF	78.83	78.85	78.83	78.84	3900.0
2013-10-04 05:30:00	QQQ	ETF	78.83	78.88	78.81	78.88	7185.0
2013-10-04 06:00:00	QQQ	ETF	78.87	78.87	78.86	78.86	1600.0
2013-10-04 06:30:00	QQQ	ETF	78.85	78.86	78.84	78.86	3400.0
2013-10-04 07:00:00	QQQ	ETF	78.87	78.9	78.83	78.83	6906.0
2013-10-04 07:30:00	QQQ	ETF	78.84	78.84	78.79	78.8	10964.0
2013-10-04 08:00:00	QQQ	ETF	78.79	78.88	78.72	78.78	41161.0
2013-10-04 08:30:00	QQQ	ETF	78.77	78.82	78.71	78.81	39034.0
2013-10-04 09:00:00	QQQ	ETF	78.81	78.83	78.71	78.72	46531.0
2013-10-04 09:30:00	QQQ	ETF	78.71	79.11	78.65	79.005	3171393.0
2013-10-04 10:00:00	QQQ	ETF	79.01	79.2	78.96	79.1	2131926.0
2013-10-04 10:30:00	QQQ	ETF	79.1	79.24	79.041	79.0679	1437206.0
2013-10-04 11:00:00	QQQ	ETF	79.06	79.11	78.96	79.025	1913659.0
2013-10-04 11:30:00	QQQ	ETF	79.02	79.16	79.01	79.14	834862.0
2013-10-04 12:00:00	QQQ	ETF	79.14	79.36	79.11	79.36	1193273.0
2013-10-04 12:30:00	QQQ	ETF	79.36	79.41	79.32	79.33	1064897.0

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

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