PREVIEW / etf_30min / 2017-12-15

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-15.parquet
  size:    455 KB
  rows:    15,739

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
2017-12-15 04:00:00	SPY	ETF	264.95	264.95	264.74	264.88	7855.0
2017-12-15 04:30:00	SPY	ETF	264.73	264.78	264.68	264.71	6599.0
2017-12-15 05:00:00	SPY	ETF	264.74	264.8	264.7	264.8	7110.0
2017-12-15 05:30:00	SPY	ETF	264.64	264.76	264.64	264.76	20450.0
2017-12-15 06:00:00	SPY	ETF	264.74	264.84	264.72	264.76	2781.0
2017-12-15 06:30:00	SPY	ETF	264.7	264.82	264.7	264.79	5717.0
2017-12-15 07:00:00	SPY	ETF	264.85	264.95	264.79	264.95	138315.0
2017-12-15 07:30:00	SPY	ETF	264.92	265.12	264.91	265.03	275539.0
2017-12-15 08:00:00	SPY	ETF	264.94	265.3	264.85	265.2	153779.0
2017-12-15 08:30:00	SPY	ETF	265.2	265.66	265.07	265.12	540041.0
2017-12-15 09:00:00	SPY	ETF	265.12	265.54	264.93	265.45	1604800.0
2017-12-15 09:30:00	SPY	ETF	265.45	265.68	265.39	265.51	8349763.0
2017-12-15 10:00:00	SPY	ETF	265.5	266.34	265.5	266.14	22385080.0
2017-12-15 10:30:00	SPY	ETF	266.13	266.14	265.86	265.92	9950429.0
2017-12-15 11:00:00	SPY	ETF	265.93	266.5	265.92	266.44	6272028.0
2017-12-15 11:30:00	SPY	ETF	266.44	266.625	266.3	266.501	5741833.0
2017-12-15 12:00:00	SPY	ETF	266.5	266.64	266.39	266.62	3302581.0
2017-12-15 12:30:00	SPY	ETF	266.62	266.7	266.52	266.6105	6478884.0
2017-12-15 13:00:00	SPY	ETF	266.61	266.67	266.49	266.53	4449043.0
2017-12-15 13:30:00	SPY	ETF	266.53	266.8	266.52	266.79	3083210.0
2017-12-15 14:00:00	SPY	ETF	266.795	267.01	266.75	266.821	7163295.0
2017-12-15 14:30:00	SPY	ETF	266.825	266.95	266.71	266.81	10743631.0
2017-12-15 15:00:00	SPY	ETF	266.815	267.04	266.79	266.955	7161653.0
2017-12-15 15:30:00	SPY	ETF	266.955	266.99	266.24	266.53	21667348.0
2017-12-15 16:00:00	SPY	ETF	266.52	267.06	266.49	266.99	16772074.0
2017-12-15 16:30:00	SPY	ETF	267.0	267.05	266.4832	267.04	1946439.0
2017-12-15 17:00:00	SPY	ETF	267.03	267.06	266.51	267.06	2514912.0
2017-12-15 17:30:00	SPY	ETF	267.06	267.15	264.2552	267.12	381784.0
2017-12-15 18:00:00	SPY	ETF	267.06	267.18	266.97	267.16	1344014.0
2017-12-15 18:30:00	SPY	ETF	267.15	267.26	267.15	267.23	18934.0
2017-12-15 19:00:00	SPY	ETF	267.2	267.21	266.93	267.11	46604.0
2017-12-15 19:30:00	SPY	ETF	267.13	267.23	267.1	267.23	19821.0
2017-12-15 04:00:00	QQQ	ETF	156.19	156.19	156.19	156.19	3000.0
2017-12-15 04:30:00	QQQ	ETF	156.14	156.14	156.14	156.14	6400.0
2017-12-15 05:00:00	QQQ	ETF	156.14	156.2	156.14	156.2	7514.0
2017-12-15 05:30:00	QQQ	ETF	156.14	156.24	156.13	156.24	59378.0
2017-12-15 06:00:00	QQQ	ETF	156.25	156.27	156.2	156.2	23599.0
2017-12-15 06:30:00	QQQ	ETF	156.2	156.22	156.18	156.22	14300.0
2017-12-15 07:00:00	QQQ	ETF	156.21	156.24	156.2	156.23	44370.0
2017-12-15 07:30:00	QQQ	ETF	156.23	156.35	156.23	156.34	53649.0
2017-12-15 08:00:00	QQQ	ETF	156.2	156.36	156.2	156.31	75584.0
2017-12-15 08:30:00	QQQ	ETF	156.3	156.36	155.88	156.28	1068427.0
2017-12-15 09:00:00	QQQ	ETF	156.28	156.55	156.15	156.49	596739.0
2017-12-15 09:30:00	QQQ	ETF	156.49	156.56	156.23	156.37	3216990.0
2017-12-15 10:00:00	QQQ	ETF	156.37	156.79	156.33	156.61	2962979.0
2017-12-15 10:30:00	QQQ	ETF	156.61	156.8499	156.55	156.735	1363013.0
2017-12-15 11:00:00	QQQ	ETF	156.74	157.09	156.74	157.02	1323351.0
2017-12-15 11:30:00	QQQ	ETF	157.0	157.28	157.0	157.28	2677016.0
2017-12-15 12:00:00	QQQ	ETF	157.27	157.52	157.2663	157.47	1030626.0
2017-12-15 12:30:00	QQQ	ETF	157.47	157.54	156.5008	157.461	1469424.0

> showing 50 of 15,739 rows — these rows as CSV

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