PREVIEW / etf_30min / 2015-02-02

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-02.parquet
  size:    387 KB
  rows:    12,984

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-02 04:00:00	SPY	ETF	199.56	199.7	199.56	199.6	1537.0
2015-02-02 04:30:00	SPY	ETF	199.7	199.7	199.7	199.7	4000.0
2015-02-02 05:00:00	SPY	ETF	199.45	199.45	199.45	199.45	1600.0
2015-02-02 05:30:00	SPY	ETF	199.45	199.67	199.35	199.55	37050.0
2015-02-02 06:00:00	SPY	ETF	199.55	200.19	199.55	200.19	52744.0
2015-02-02 06:30:00	SPY	ETF	200.19	200.23	199.96	199.96	35285.0
2015-02-02 07:00:00	SPY	ETF	199.98	200.09	199.86	200.03	151382.0
2015-02-02 07:30:00	SPY	ETF	200.04	200.05	199.7	199.72	226762.0
2015-02-02 08:00:00	SPY	ETF	199.74	200.04	199.6	199.74	304665.0
2015-02-02 08:30:00	SPY	ETF	199.74	199.88	199.45	199.57	353947.0
2015-02-02 09:00:00	SPY	ETF	199.55	200.17	199.54	200.07	1395996.0
2015-02-02 09:30:00	SPY	ETF	200.05	200.26	198.92	198.95	16234152.0
2015-02-02 10:00:00	SPY	ETF	198.93	198.96	197.86	198.44	19982423.0
2015-02-02 10:30:00	SPY	ETF	198.44	199.29	198.16	199.05	11111044.0
2015-02-02 11:00:00	SPY	ETF	199.05	200.23	199.02	200.2201	10691679.0
2015-02-02 11:30:00	SPY	ETF	200.23	200.88	200.08	200.3901	10336823.0
2015-02-02 12:00:00	SPY	ETF	200.4	200.5	199.73	199.932	8558855.0
2015-02-02 12:30:00	SPY	ETF	199.94	200.18	199.34	199.3949	7338203.0
2015-02-02 13:00:00	SPY	ETF	199.4	199.95	199.13	199.801	7336777.0
2015-02-02 13:30:00	SPY	ETF	199.81	200.02	198.86	198.9351	7667992.0
2015-02-02 14:00:00	SPY	ETF	198.93	200.04	198.87	200.02	7231367.0
2015-02-02 14:30:00	SPY	ETF	200.02	200.14	199.41	199.605	6168168.0
2015-02-02 15:00:00	SPY	ETF	199.605	200.62	199.52	200.525	9377475.0
2015-02-02 15:30:00	SPY	ETF	200.53	202.03	200.42	201.87	24688836.0
2015-02-02 16:00:00	SPY	ETF	201.88	202.32	199.052	202.08	6774354.0
2015-02-02 16:30:00	SPY	ETF	202.07	202.11	201.92	202.0	2465127.0
2015-02-02 17:00:00	SPY	ETF	202.02	202.04	201.93	201.95	2142274.0
2015-02-02 17:30:00	SPY	ETF	201.94	201.97	201.92	201.96	105857.0
2015-02-02 18:00:00	SPY	ETF	201.95	202.11	201.92	202.08	75102.0
2015-02-02 18:30:00	SPY	ETF	202.08	202.11	201.93	201.93	28098.0
2015-02-02 19:00:00	SPY	ETF	201.94	201.94	201.84	201.84	62538.0
2015-02-02 19:30:00	SPY	ETF	201.84	201.86	201.63	201.65	223403.0
2015-02-02 04:00:00	QQQ	ETF	101.1	101.1	101.1	101.1	300.0
2015-02-02 05:00:00	QQQ	ETF	101.1	101.1	101.0	101.0	200.0
2015-02-02 06:00:00	QQQ	ETF	101.39	101.39	101.39	101.39	200.0
2015-02-02 06:30:00	QQQ	ETF	100.66	101.41	100.66	101.37	6100.0
2015-02-02 07:00:00	QQQ	ETF	101.33	101.35	101.27	101.32	74800.0
2015-02-02 07:30:00	QQQ	ETF	101.3	101.3	101.15	101.15	91170.0
2015-02-02 08:00:00	QQQ	ETF	101.17	101.21	101.11	101.21	57370.0
2015-02-02 08:30:00	QQQ	ETF	101.18	101.28	101.04	101.08	54784.0
2015-02-02 09:00:00	QQQ	ETF	101.08	101.39	101.08	101.33	209517.0
2015-02-02 09:30:00	QQQ	ETF	101.33	101.5	100.26	100.27	5161436.0
2015-02-02 10:00:00	QQQ	ETF	100.25	100.46	99.75	100.22	5652641.0
2015-02-02 10:30:00	QQQ	ETF	100.23	100.7	100.02	100.5	3092905.0
2015-02-02 11:00:00	QQQ	ETF	100.5	101.27	100.48	101.2299	3029409.0
2015-02-02 11:30:00	QQQ	ETF	101.25	101.63	101.21	101.38	3104465.0
2015-02-02 12:00:00	QQQ	ETF	101.39	101.45	101.02	101.16	1647409.0
2015-02-02 12:30:00	QQQ	ETF	101.17	101.31	100.79	100.83	1425866.0
2015-02-02 13:00:00	QQQ	ETF	100.8267	101.13	100.7	101.0	1620451.0
2015-02-02 13:30:00	QQQ	ETF	101.02	101.14	100.5	100.56	1670680.0

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

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