PREVIEW / etf_30min / 2015-02-27

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-27.parquet
  size:    371 KB
  rows:    12,600

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
2015-02-27 04:00:00	SPY	ETF	211.16	211.17	211.09	211.09	2859.0
2015-02-27 05:00:00	SPY	ETF	211.14	211.17	211.14	211.17	400.0
2015-02-27 05:30:00	SPY	ETF	211.17	211.18	211.05	211.05	14012.0
2015-02-27 06:00:00	SPY	ETF	211.08	211.17	211.08	211.15	2650.0
2015-02-27 06:30:00	SPY	ETF	211.12	211.23	211.12	211.2	1867.0
2015-02-27 07:00:00	SPY	ETF	211.18	211.22	211.13	211.16	36562.0
2015-02-27 07:30:00	SPY	ETF	211.13	211.25	211.08	211.21	50932.0
2015-02-27 08:00:00	SPY	ETF	211.24	211.24	211.1	211.18	92239.0
2015-02-27 08:30:00	SPY	ETF	211.18	211.4	211.15	211.18	223007.0
2015-02-27 09:00:00	SPY	ETF	211.19	211.33	211.18	211.26	268250.0
2015-02-27 09:30:00	SPY	ETF	211.26	211.44	210.84	211.07	10540639.0
2015-02-27 10:00:00	SPY	ETF	211.06	211.37	211.02	211.35	5951051.0
2015-02-27 10:30:00	SPY	ETF	211.35	211.55	211.18	211.52	4316611.0
2015-02-27 11:00:00	SPY	ETF	211.52	211.5399	211.17	211.18	4508912.0
2015-02-27 11:30:00	SPY	ETF	211.18	211.49	211.18	211.39	4029891.0
2015-02-27 12:00:00	SPY	ETF	211.38	211.56	211.36	211.53	3595037.0
2015-02-27 12:30:00	SPY	ETF	211.5314	211.58	211.3	211.36	2986790.0
2015-02-27 13:00:00	SPY	ETF	211.36	211.4	211.13	211.2368	2822563.0
2015-02-27 13:30:00	SPY	ETF	211.234	211.3	211.1	211.27	3307430.0
2015-02-27 14:00:00	SPY	ETF	211.28	211.35	211.13	211.23	4494462.0
2015-02-27 14:30:00	SPY	ETF	211.23	211.24	210.78	210.91	6479969.0
2015-02-27 15:00:00	SPY	ETF	210.9132	211.06	210.71	211.03	7863366.0
2015-02-27 15:30:00	SPY	ETF	211.03	211.05	210.64	210.69	20924584.0
2015-02-27 16:00:00	SPY	ETF	210.69	211.5	210.6	211.0	7900419.0
2015-02-27 16:30:00	SPY	ETF	211.0	211.08	210.66	211.0	9545165.0
2015-02-27 17:00:00	SPY	ETF	211.01	211.03	210.93	210.96	735681.0
2015-02-27 17:30:00	SPY	ETF	210.98	210.99	210.66	210.93	1438745.0
2015-02-27 18:00:00	SPY	ETF	210.93	210.93	210.76	210.79	66971.0
2015-02-27 18:30:00	SPY	ETF	210.79	210.84	210.79	210.81	5711.0
2015-02-27 19:00:00	SPY	ETF	210.83	210.86	210.83	210.83	6867.0
2015-02-27 19:30:00	SPY	ETF	210.83	210.85	210.82	210.83	15333.0
2015-02-27 06:30:00	QQQ	ETF	108.8	108.8	108.8	108.8	100.0
2015-02-27 07:00:00	QQQ	ETF	108.8	108.8	108.76	108.76	3500.0
2015-02-27 07:30:00	QQQ	ETF	108.73	108.78	108.73	108.78	18200.0
2015-02-27 08:00:00	QQQ	ETF	108.79	108.8	108.72	108.74	13265.0
2015-02-27 08:30:00	QQQ	ETF	108.77	108.81	108.74	108.74	33261.0
2015-02-27 09:00:00	QQQ	ETF	108.77	108.84	108.77	108.84	334128.0
2015-02-27 09:30:00	QQQ	ETF	108.84	108.91	108.52	108.78	3047003.0
2015-02-27 10:00:00	QQQ	ETF	108.78	108.9	108.62	108.83	1576046.0
2015-02-27 10:30:00	QQQ	ETF	108.835	108.89	108.73	108.8751	874192.0
2015-02-27 11:00:00	QQQ	ETF	108.87	108.8751	108.661	108.68	955095.0
2015-02-27 11:30:00	QQQ	ETF	108.68	108.82	108.68	108.77	749313.0
2015-02-27 12:00:00	QQQ	ETF	108.76	108.82	108.7401	108.79	596091.0
2015-02-27 12:30:00	QQQ	ETF	108.79	108.81	108.67	108.685	765902.0
2015-02-27 13:00:00	QQQ	ETF	108.68	108.72	108.57	108.62	835394.0
2015-02-27 13:30:00	QQQ	ETF	108.62	108.6299	108.48	108.61	1254600.0
2015-02-27 14:00:00	QQQ	ETF	108.61	108.65	108.44	108.47	898107.0
2015-02-27 14:30:00	QQQ	ETF	108.47	108.5199	108.25	108.365	1224820.0
2015-02-27 15:00:00	QQQ	ETF	108.37	108.48	108.24	108.45	1628567.0
2015-02-27 15:30:00	QQQ	ETF	108.45	108.46	108.23	108.38	3754466.0

> showing 50 of 12,600 rows — these rows as CSV

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