PREVIEW / etf_30min / 2018-07-19

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-07-19.parquet
  size:    464 KB
  rows:    15,985

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-07-19 04:00:00	SPY	ETF	280.59	280.59	280.29	280.52	20341.0
2018-07-19 04:30:00	SPY	ETF	280.49	280.68	280.42	280.59	22176.0
2018-07-19 05:00:00	SPY	ETF	280.64	280.64	280.48	280.59	13821.0
2018-07-19 05:30:00	SPY	ETF	280.61	280.61	280.35	280.35	22400.0
2018-07-19 06:00:00	SPY	ETF	280.38	280.41	280.09	280.11	17304.0
2018-07-19 06:30:00	SPY	ETF	280.21	280.33	280.12	280.32	48277.0
2018-07-19 07:00:00	SPY	ETF	280.36	280.38	280.16	280.2	79455.0
2018-07-19 07:30:00	SPY	ETF	280.19	280.33	280.15	280.16	128715.0
2018-07-19 08:00:00	SPY	ETF	280.15	280.88	280.05	280.07	256414.0
2018-07-19 08:30:00	SPY	ETF	280.06	280.29	280.06	280.12	332920.0
2018-07-19 09:00:00	SPY	ETF	280.11	280.31	280.08	280.3	243495.0
2018-07-19 09:30:00	SPY	ETF	280.31	280.69	279.46	279.78	6957351.0
2018-07-19 10:00:00	SPY	ETF	279.77	280.21	279.71	279.895	4573584.0
2018-07-19 10:30:00	SPY	ETF	279.89	280.18	279.63	280.01	3953417.0
2018-07-19 11:00:00	SPY	ETF	280.02	280.41	280.0161	280.2413	3191510.0
2018-07-19 11:30:00	SPY	ETF	280.25	280.58	280.22	280.45	2303749.0
2018-07-19 12:00:00	SPY	ETF	280.46	280.52	280.09	280.21	2215285.0
2018-07-19 12:30:00	SPY	ETF	280.21	280.29	279.9	280.09	1997321.0
2018-07-19 13:00:00	SPY	ETF	280.09	280.48	279.77	280.31	5445045.0
2018-07-19 13:30:00	SPY	ETF	280.3	280.57	280.2	280.55	1939484.0
2018-07-19 14:00:00	SPY	ETF	280.55	280.74	280.46	280.595	2419974.0
2018-07-19 14:30:00	SPY	ETF	280.6	280.62	280.11	280.265	3337898.0
2018-07-19 15:00:00	SPY	ETF	280.27	280.41	279.9	280.1	2679206.0
2018-07-19 15:30:00	SPY	ETF	280.105	280.25	279.8	280.01	7116911.0
2018-07-19 16:00:00	SPY	ETF	280.0	280.1758	279.8	280.01	8891461.0
2018-07-19 16:30:00	SPY	ETF	280.01	280.05	279.96	279.97	427725.0
2018-07-19 17:00:00	SPY	ETF	279.94	280.0	279.9	280.0	436335.0
2018-07-19 17:30:00	SPY	ETF	279.99	280.02	279.94	279.99	13814.0
2018-07-19 18:00:00	SPY	ETF	280.04	280.17	279.92	280.15	41231.0
2018-07-19 18:30:00	SPY	ETF	280.11	280.15	280.0	280.0	4870.0
2018-07-19 19:00:00	SPY	ETF	280.16	280.2	280.13	280.2	5700.0
2018-07-19 19:30:00	SPY	ETF	280.2	280.22	279.9703	280.11	58389.0
2018-07-19 04:00:00	QQQ	ETF	179.71	179.71	179.54	179.6	2150.0
2018-07-19 04:30:00	QQQ	ETF	179.55	179.77	179.54	179.75	3300.0
2018-07-19 05:00:00	QQQ	ETF	179.69	179.69	179.66	179.66	2000.0
2018-07-19 05:30:00	QQQ	ETF	179.68	179.7	179.49	179.54	6210.0
2018-07-19 06:00:00	QQQ	ETF	179.51	179.51	179.17	179.26	10700.0
2018-07-19 06:30:00	QQQ	ETF	179.29	179.31	179.2	179.3	7675.0
2018-07-19 07:00:00	QQQ	ETF	179.41	179.42	179.28	179.29	47666.0
2018-07-19 07:30:00	QQQ	ETF	179.33	179.46	179.23	179.26	207715.0
2018-07-19 08:00:00	QQQ	ETF	179.3001	180.0	179.15	179.25	90638.0
2018-07-19 08:30:00	QQQ	ETF	179.28	179.43	179.2	179.2	90309.0
2018-07-19 09:00:00	QQQ	ETF	179.21	179.39	179.17	179.34	83038.0
2018-07-19 09:30:00	QQQ	ETF	179.34	179.88	178.9	179.16	3007117.0
2018-07-19 10:00:00	QQQ	ETF	179.15	179.42	178.97	179.235	2700214.0
2018-07-19 10:30:00	QQQ	ETF	179.235	179.4	178.92	179.31	2786828.0
2018-07-19 11:00:00	QQQ	ETF	179.314	179.67	179.31	179.5536	982666.0
2018-07-19 11:30:00	QQQ	ETF	179.554	179.76	179.49	179.59	816915.0
2018-07-19 12:00:00	QQQ	ETF	179.59	179.64	179.18	179.3	1134421.0
2018-07-19 12:30:00	QQQ	ETF	179.3	179.36	178.84	179.11	861463.0

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

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