PREVIEW / etf_30min / 2013-09-25

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-25.parquet
  size:    308 KB
  rows:    10,562

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-25 04:00:00	SPY	ETF	169.33	169.33	169.13	169.27	4500.0
2013-09-25 04:30:00	SPY	ETF	169.26	169.55	169.24	169.51	6460.0
2013-09-25 05:00:00	SPY	ETF	169.55	169.7	169.55	169.67	2800.0
2013-09-25 05:30:00	SPY	ETF	169.7	169.75	169.66	169.67	3100.0
2013-09-25 06:00:00	SPY	ETF	169.61	169.61	169.46	169.51	4200.0
2013-09-25 06:30:00	SPY	ETF	169.5	169.5	169.33	169.38	38500.0
2013-09-25 07:00:00	SPY	ETF	169.37	169.37	169.28	169.34	43526.0
2013-09-25 07:30:00	SPY	ETF	169.37	169.49	169.32	169.49	179463.0
2013-09-25 08:00:00	SPY	ETF	169.35	169.52	169.35	169.43	120236.0
2013-09-25 08:30:00	SPY	ETF	169.41	169.77	169.37	169.68	663642.0
2013-09-25 09:00:00	SPY	ETF	169.69	169.79	169.54	169.63	616532.0
2013-09-25 09:30:00	SPY	ETF	169.64	169.66	169.03	169.31	12443287.0
2013-09-25 10:00:00	SPY	ETF	169.31	169.51	168.89	169.395	12235913.0
2013-09-25 10:30:00	SPY	ETF	169.39	169.59	169.3001	169.39	6095165.0
2013-09-25 11:00:00	SPY	ETF	169.39	169.85	169.25	169.8	7532382.0
2013-09-25 11:30:00	SPY	ETF	169.8	169.93	169.76	169.83	4592607.0
2013-09-25 12:00:00	SPY	ETF	169.825	169.88	169.35	169.51	7745024.0
2013-09-25 12:30:00	SPY	ETF	169.51	169.98	169.43	169.61	3578149.0
2013-09-25 13:00:00	SPY	ETF	169.62	169.75	169.48	169.4851	3641870.0
2013-09-25 13:30:00	SPY	ETF	169.48	169.48	168.9	169.23	13338901.0
2013-09-25 14:00:00	SPY	ETF	169.23	169.38	169.04	169.21	6415088.0
2013-09-25 14:30:00	SPY	ETF	169.21	169.37	169.07	169.18	5003151.0
2013-09-25 15:00:00	SPY	ETF	169.18	169.53	169.08	169.17	6208000.0
2013-09-25 15:30:00	SPY	ETF	169.18	169.31	169.03	169.08	10736810.0
2013-09-25 16:00:00	SPY	ETF	169.07	169.3197	168.98	169.04	3350074.0
2013-09-25 16:30:00	SPY	ETF	169.05	169.15	169.05	169.1	3336122.0
2013-09-25 17:00:00	SPY	ETF	169.06	169.3023	169.06	169.07	51168.0
2013-09-25 17:30:00	SPY	ETF	169.07	169.1	169.07	169.09	6562.0
2013-09-25 18:00:00	SPY	ETF	169.1	169.22	169.1	169.22	29507.0
2013-09-25 18:30:00	SPY	ETF	169.21	169.23	169.16	169.19	14633.0
2013-09-25 19:00:00	SPY	ETF	169.19	169.22	169.18	169.2	18215.0
2013-09-25 19:30:00	SPY	ETF	169.2	169.23	169.15	169.19	49000.0
2013-09-25 04:00:00	QQQ	ETF	78.67	78.67	78.67	78.67	100.0
2013-09-25 04:30:00	QQQ	ETF	78.65	78.82	78.65	78.82	19000.0
2013-09-25 05:00:00	QQQ	ETF	78.86	78.96	78.86	78.94	10900.0
2013-09-25 05:30:00	QQQ	ETF	78.92	78.94	78.92	78.92	4800.0
2013-09-25 06:00:00	QQQ	ETF	78.9	78.9	78.76	78.8	14700.0
2013-09-25 06:30:00	QQQ	ETF	78.8	78.8	78.76	78.76	8100.0
2013-09-25 07:00:00	QQQ	ETF	78.75	78.75	78.72	78.72	6600.0
2013-09-25 07:30:00	QQQ	ETF	78.74	78.8	78.74	78.8	11500.0
2013-09-25 08:00:00	QQQ	ETF	78.82	78.84	78.78	78.82	12550.0
2013-09-25 08:30:00	QQQ	ETF	78.8	78.95	78.76	78.9	242900.0
2013-09-25 09:00:00	QQQ	ETF	78.92	78.94	78.84	78.86	83452.0
2013-09-25 09:30:00	QQQ	ETF	78.88	78.89	78.55	78.58	2646360.0
2013-09-25 10:00:00	QQQ	ETF	78.58	78.73	78.4	78.7	3644679.0
2013-09-25 10:30:00	QQQ	ETF	78.7	78.8401	78.63	78.7195	1095604.0
2013-09-25 11:00:00	QQQ	ETF	78.72	78.94	78.62	78.91	1127350.0
2013-09-25 11:30:00	QQQ	ETF	78.91	78.9799	78.88	78.93	982035.0
2013-09-25 12:00:00	QQQ	ETF	78.93	79.0	78.71	78.81	1173159.0
2013-09-25 12:30:00	QQQ	ETF	78.81	78.9	78.78	78.84	752505.0

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

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