PREVIEW / etf_30min / 2018-08-06

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-06.parquet
  size:    457 KB
  rows:    15,786

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
2018-08-06 04:00:00	SPY	ETF	283.6	283.6	283.35	283.41	5872.0
2018-08-06 04:30:00	SPY	ETF	283.3	283.32	283.19	283.19	5002.0
2018-08-06 05:00:00	SPY	ETF	283.24	283.32	283.24	283.32	3783.0
2018-08-06 05:30:00	SPY	ETF	283.31	283.64	283.31	283.64	7062.0
2018-08-06 06:00:00	SPY	ETF	283.64	283.8	283.62	283.8	5252.0
2018-08-06 06:30:00	SPY	ETF	283.87	283.92	283.83	283.92	4894.0
2018-08-06 07:00:00	SPY	ETF	283.91	283.91	283.78	283.81	17430.0
2018-08-06 07:30:00	SPY	ETF	283.81	283.86	283.67	283.69	15542.0
2018-08-06 08:00:00	SPY	ETF	283.66	283.89	283.58	283.58	44373.0
2018-08-06 08:30:00	SPY	ETF	283.6	283.66	283.41	283.43	85690.0
2018-08-06 09:00:00	SPY	ETF	283.45	283.61	283.39	283.54	174157.0
2018-08-06 09:30:00	SPY	ETF	283.64	283.84	283.2015	283.76	4040971.0
2018-08-06 10:00:00	SPY	ETF	283.76	283.99	283.54	283.64	1959255.0
2018-08-06 10:30:00	SPY	ETF	283.63	284.03	283.59	284.01	1615778.0
2018-08-06 11:00:00	SPY	ETF	284.01	284.1	283.84	284.095	1679463.0
2018-08-06 11:30:00	SPY	ETF	284.1	284.4	284.04	284.37	1423167.0
2018-08-06 12:00:00	SPY	ETF	284.38	284.78	284.37	284.6805	3830956.0
2018-08-06 12:30:00	SPY	ETF	284.69	284.8075	284.67	284.785	1356966.0
2018-08-06 13:00:00	SPY	ETF	284.785	284.99	284.64	284.69	2444706.0
2018-08-06 13:30:00	SPY	ETF	284.69	284.71	284.4	284.46	1992426.0
2018-08-06 14:00:00	SPY	ETF	284.46	284.7	284.375	284.6802	1840444.0
2018-08-06 14:30:00	SPY	ETF	284.68	284.84	284.665	284.68	2408492.0
2018-08-06 15:00:00	SPY	ETF	284.68	284.69	284.49	284.6464	2295799.0
2018-08-06 15:30:00	SPY	ETF	284.64	284.73	284.52	284.68	7434755.0
2018-08-06 16:00:00	SPY	ETF	284.68	284.75	284.0017	284.7	3068706.0
2018-08-06 16:30:00	SPY	ETF	284.7	284.75	284.6	284.6	113601.0
2018-08-06 17:00:00	SPY	ETF	284.61	284.65	284.54	284.63	51287.0
2018-08-06 17:30:00	SPY	ETF	284.635	284.6523	284.56	284.59	222662.0
2018-08-06 18:00:00	SPY	ETF	284.63	284.65	284.56	284.6	12438.0
2018-08-06 18:30:00	SPY	ETF	284.6	284.62	284.52	284.62	70547.0
2018-08-06 19:00:00	SPY	ETF	284.58	284.67	284.58	284.63	9250.0
2018-08-06 19:30:00	SPY	ETF	284.65	284.66	284.64	284.65	7575.0
2018-08-06 04:00:00	QQQ	ETF	179.97	180.16	179.97	180.11	3743.0
2018-08-06 04:30:00	QQQ	ETF	180.13	180.13	179.94	179.94	2839.0
2018-08-06 05:00:00	QQQ	ETF	179.94	180.04	179.94	180.04	5400.0
2018-08-06 05:30:00	QQQ	ETF	180.06	180.27	180.06	180.27	4200.0
2018-08-06 06:00:00	QQQ	ETF	180.3	180.3	180.3	180.3	350.0
2018-08-06 06:30:00	QQQ	ETF	180.4	180.43	180.33	180.37	3600.0
2018-08-06 07:00:00	QQQ	ETF	180.37	180.44	180.31	180.31	21530.0
2018-08-06 07:30:00	QQQ	ETF	180.35	180.35	180.21	180.22	21120.0
2018-08-06 08:00:00	QQQ	ETF	180.41	180.41	180.13	180.13	70362.0
2018-08-06 08:30:00	QQQ	ETF	180.13	180.15	179.92	179.97	317052.0
2018-08-06 09:00:00	QQQ	ETF	179.98	180.04	179.89	179.97	130617.0
2018-08-06 09:30:00	QQQ	ETF	179.97	180.36	179.74	180.29	3266887.0
2018-08-06 10:00:00	QQQ	ETF	180.3	180.6	179.96	180.14	2076831.0
2018-08-06 10:30:00	QQQ	ETF	180.14	180.31	180.07	180.215	1182481.0
2018-08-06 11:00:00	QQQ	ETF	180.23	180.365	179.99	180.28	965693.0
2018-08-06 11:30:00	QQQ	ETF	180.28	180.56	180.25	180.5242	724880.0
2018-08-06 12:00:00	QQQ	ETF	180.53	180.889	180.5	180.6967	1411582.0
2018-08-06 12:30:00	QQQ	ETF	180.7	180.94	180.69	180.94	637096.0

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

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