PREVIEW / etf_30min / 2014-01-31

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-31.parquet
  size:    358 KB
  rows:    11,854

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
2014-01-31 04:00:00	SPY	ETF	178.28	178.34	177.88	178.06	57623.0
2014-01-31 04:30:00	SPY	ETF	178.06	178.2	177.72	177.82	33060.0
2014-01-31 05:00:00	SPY	ETF	177.84	177.84	177.32	177.56	200205.0
2014-01-31 05:30:00	SPY	ETF	177.59	177.79	177.54	177.58	22934.0
2014-01-31 06:00:00	SPY	ETF	177.61	177.79	177.49	177.54	74561.0
2014-01-31 06:30:00	SPY	ETF	177.57	177.57	176.87	177.0	535293.0
2014-01-31 07:00:00	SPY	ETF	176.98	177.66	176.93	177.39	619631.0
2014-01-31 07:30:00	SPY	ETF	177.35	177.58	177.14	177.22	546727.0
2014-01-31 08:00:00	SPY	ETF	177.54	177.62	176.57	176.8	2166405.0
2014-01-31 08:30:00	SPY	ETF	176.81	177.04	176.61	176.88	3164525.0
2014-01-31 09:00:00	SPY	ETF	176.88	177.19	176.79	177.01	1976333.0
2014-01-31 09:30:00	SPY	ETF	177.02	177.71	176.92	177.42	22487321.0
2014-01-31 10:00:00	SPY	ETF	177.4	177.85	177.25	177.29	15022036.0
2014-01-31 10:30:00	SPY	ETF	177.29	178.13	177.29	177.89	12804236.0
2014-01-31 11:00:00	SPY	ETF	177.88	178.59	177.79	178.5899	11578842.0
2014-01-31 11:30:00	SPY	ETF	178.59	178.68	178.31	178.5805	7112002.0
2014-01-31 12:00:00	SPY	ETF	178.59	178.86	178.48	178.61	7734253.0
2014-01-31 12:30:00	SPY	ETF	178.61	178.67	178.22	178.539	7191454.0
2014-01-31 13:00:00	SPY	ETF	178.54	178.6	178.22	178.36	4851898.0
2014-01-31 13:30:00	SPY	ETF	178.36	179.045	178.34	179.04	7087405.0
2014-01-31 14:00:00	SPY	ETF	179.04	179.19	178.85	179.02	7953190.0
2014-01-31 14:30:00	SPY	ETF	179.015	179.29	178.88	178.92	8411275.0
2014-01-31 15:00:00	SPY	ETF	178.92	178.92	178.33	178.48	16152746.0
2014-01-31 15:30:00	SPY	ETF	178.47	178.6	177.93	178.1	31368042.0
2014-01-31 16:00:00	SPY	ETF	178.1	179.3143	177.52	178.21	14668348.0
2014-01-31 16:30:00	SPY	ETF	178.22	179.3143	178.09	178.11	5002532.0
2014-01-31 17:00:00	SPY	ETF	178.13	178.18	178.08	178.14	153375.0
2014-01-31 17:30:00	SPY	ETF	178.17	178.18	178.09	178.09	15347.0
2014-01-31 18:00:00	SPY	ETF	178.13	178.16	178.08	178.12	41993.0
2014-01-31 18:30:00	SPY	ETF	178.12	178.13	178.07	178.12	8195.0
2014-01-31 19:00:00	SPY	ETF	178.12	178.14	178.11	178.14	2070.0
2014-01-31 19:30:00	SPY	ETF	178.14	178.18	178.1	178.1	50345.0
2014-01-31 04:00:00	QQQ	ETF	86.1	86.14	86.09	86.09	29900.0
2014-01-31 05:00:00	QQQ	ETF	85.87	85.87	85.62	85.67	400.0
2014-01-31 06:00:00	QQQ	ETF	85.75	85.86	85.74	85.74	15300.0
2014-01-31 06:30:00	QQQ	ETF	85.63	85.65	85.44	85.51	41000.0
2014-01-31 07:00:00	QQQ	ETF	85.46	85.74	85.45	85.64	68060.0
2014-01-31 07:30:00	QQQ	ETF	85.64	85.72	85.57	85.68	259892.0
2014-01-31 08:00:00	QQQ	ETF	85.64	85.7	85.4	85.46	630175.0
2014-01-31 08:30:00	QQQ	ETF	85.46	85.57	85.43	85.56	478697.0
2014-01-31 09:00:00	QQQ	ETF	85.55	85.7	85.51	85.54	499954.0
2014-01-31 09:30:00	QQQ	ETF	85.54	85.84	85.45	85.72	6429278.0
2014-01-31 10:00:00	QQQ	ETF	85.73	85.98	85.62	85.64	3113492.0
2014-01-31 10:30:00	QQQ	ETF	85.64	86.02	85.59	85.87	3651430.0
2014-01-31 11:00:00	QQQ	ETF	85.88	86.17	85.83	86.14	2509272.0
2014-01-31 11:30:00	QQQ	ETF	86.14	86.23	86.03	86.23	1173043.0
2014-01-31 12:00:00	QQQ	ETF	86.225	86.431	86.21	86.34	1948012.0
2014-01-31 12:30:00	QQQ	ETF	86.35	86.4	86.16	86.35	1301772.0
2014-01-31 13:00:00	QQQ	ETF	86.35	86.405	86.17	86.24	1465411.0
2014-01-31 13:30:00	QQQ	ETF	86.24	86.57	86.23	86.57	2450541.0

> showing 50 of 11,854 rows — these rows as CSV

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