PREVIEW / etf_30min / 2017-10-02

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-02.parquet
  size:    449 KB
  rows:    15,577

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-10-02 04:00:00	SPY	ETF	251.44	251.48	251.41	251.48	17900.0
2017-10-02 04:30:00	SPY	ETF	251.46	251.46	251.43	251.45	370.0
2017-10-02 05:00:00	SPY	ETF	251.45	251.48	251.45	251.48	802.0
2017-10-02 05:30:00	SPY	ETF	251.52	251.57	251.52	251.55	7369.0
2017-10-02 06:00:00	SPY	ETF	251.53	251.62	251.49	251.62	8504.0
2017-10-02 06:30:00	SPY	ETF	251.63	251.69	251.58	251.68	12077.0
2017-10-02 07:00:00	SPY	ETF	251.68	251.7	251.58	251.64	28686.0
2017-10-02 07:30:00	SPY	ETF	251.63	251.76	251.63	251.73	115541.0
2017-10-02 08:00:00	SPY	ETF	251.72	251.76	251.61	251.68	98259.0
2017-10-02 08:30:00	SPY	ETF	251.66	251.71	251.5	251.51	201400.0
2017-10-02 09:00:00	SPY	ETF	251.52	251.55	251.45	251.48	253519.0
2017-10-02 09:30:00	SPY	ETF	251.49	251.88	251.4	251.85	5273954.0
2017-10-02 10:00:00	SPY	ETF	251.87	252.195	251.76	251.87	5671856.0
2017-10-02 10:30:00	SPY	ETF	251.875	252.03	251.83	251.87	2880760.0
2017-10-02 11:00:00	SPY	ETF	251.87	251.95	251.62	251.73	1986096.0
2017-10-02 11:30:00	SPY	ETF	251.72	251.9	251.61	251.615	2049786.0
2017-10-02 12:00:00	SPY	ETF	251.615	251.89	251.525	251.81	1906746.0
2017-10-02 12:30:00	SPY	ETF	251.82	252.04	251.82	252.0	2400942.0
2017-10-02 13:00:00	SPY	ETF	252.01	252.07	251.93	252.02	1637974.0
2017-10-02 13:30:00	SPY	ETF	252.03	252.1	251.965	252.08	1297770.0
2017-10-02 14:00:00	SPY	ETF	252.085	252.1	251.97	252.09	1839642.0
2017-10-02 14:30:00	SPY	ETF	252.08	252.14	252.04	252.11	1498149.0
2017-10-02 15:00:00	SPY	ETF	252.11	252.17	251.2926	252.12	4632139.0
2017-10-02 15:30:00	SPY	ETF	252.11	252.3	252.01	252.29	8486933.0
2017-10-02 16:00:00	SPY	ETF	252.28	252.34	252.23	252.29	9922627.0
2017-10-02 16:30:00	SPY	ETF	252.29	252.44	251.9313	252.41	749935.0
2017-10-02 17:00:00	SPY	ETF	252.42	252.43	252.38	252.41	50314.0
2017-10-02 17:30:00	SPY	ETF	252.41	252.42	252.37	252.37	2160775.0
2017-10-02 18:00:00	SPY	ETF	252.36	252.39	252.28	252.3	84686.0
2017-10-02 18:30:00	SPY	ETF	252.33	252.33	252.29	252.3	14559.0
2017-10-02 19:00:00	SPY	ETF	252.29	252.3	252.25	252.26	22748.0
2017-10-02 19:30:00	SPY	ETF	252.28	252.28	252.23	252.23	52498.0
2017-10-02 04:00:00	QQQ	ETF	145.62	145.62	145.62	145.62	400.0
2017-10-02 04:30:00	QQQ	ETF	145.61	145.61	145.55	145.57	2100.0
2017-10-02 05:00:00	QQQ	ETF	145.59	145.59	145.59	145.59	200.0
2017-10-02 05:30:00	QQQ	ETF	145.7	145.7	145.7	145.7	200.0
2017-10-02 06:30:00	QQQ	ETF	145.8	145.8	145.79	145.79	11800.0
2017-10-02 07:00:00	QQQ	ETF	145.79	145.8	145.75	145.77	2982.0
2017-10-02 07:30:00	QQQ	ETF	145.84	145.89	145.83	145.85	4890.0
2017-10-02 08:00:00	QQQ	ETF	145.86	145.86	145.78	145.8	33228.0
2017-10-02 08:30:00	QQQ	ETF	145.78	145.86	145.63	145.7	64792.0
2017-10-02 09:00:00	QQQ	ETF	145.71	145.71	145.63	145.69	257600.0
2017-10-02 09:30:00	QQQ	ETF	145.68	146.05	145.66	146.04	3811320.0
2017-10-02 10:00:00	QQQ	ETF	146.02	146.17	145.86	146.01	2096148.0
2017-10-02 10:30:00	QQQ	ETF	146.01	146.14	145.9247	145.94	1443060.0
2017-10-02 11:00:00	QQQ	ETF	145.94	146.04	145.77	145.84	1563759.0
2017-10-02 11:30:00	QQQ	ETF	145.83	145.83	145.12	145.12	2998208.0
2017-10-02 12:00:00	QQQ	ETF	145.12	145.39	144.93	145.34	2278128.0
2017-10-02 12:30:00	QQQ	ETF	145.34	145.475	145.3	145.46	1240087.0
2017-10-02 13:00:00	QQQ	ETF	145.465	145.54	145.39	145.4536	1185723.0

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

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