PREVIEW / etf_30min / 2018-08-22

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-22.parquet
  size:    465 KB
  rows:    16,017

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-22 04:00:00	SPY	ETF	285.26	285.58	285.26	285.3	8477.0
2018-08-22 04:30:00	SPY	ETF	285.39	285.55	285.25	285.55	4025.0
2018-08-22 05:00:00	SPY	ETF	285.55	285.58	285.42	285.42	4556.0
2018-08-22 05:30:00	SPY	ETF	285.43	285.59	285.41	285.42	5544.0
2018-08-22 06:00:00	SPY	ETF	285.48	285.84	285.48	285.75	35404.0
2018-08-22 06:30:00	SPY	ETF	285.77	285.9	285.67	285.9	28510.0
2018-08-22 07:00:00	SPY	ETF	285.9	286.05	285.66	285.66	115558.0
2018-08-22 07:30:00	SPY	ETF	285.68	285.81	285.53	285.6	176232.0
2018-08-22 08:00:00	SPY	ETF	285.822	286.05	285.29	285.36	495388.0
2018-08-22 08:30:00	SPY	ETF	285.34	285.62	285.24	285.6	518508.0
2018-08-22 09:00:00	SPY	ETF	285.59	285.9	285.54	285.9	228058.0
2018-08-22 09:30:00	SPY	ETF	285.88	286.3	285.61	285.77	6397446.0
2018-08-22 10:00:00	SPY	ETF	285.775	286.16	285.575	285.7536	3813207.0
2018-08-22 10:30:00	SPY	ETF	285.75	286.52	285.74	286.4	3651425.0
2018-08-22 11:00:00	SPY	ETF	286.4	286.67	286.33	286.6569	3603395.0
2018-08-22 11:30:00	SPY	ETF	286.66	286.76	286.45	286.66	3097404.0
2018-08-22 12:00:00	SPY	ETF	286.67	286.72	286.38	286.4	1841594.0
2018-08-22 12:30:00	SPY	ETF	286.4	286.51	286.26	286.41	1453928.0
2018-08-22 13:00:00	SPY	ETF	286.41	286.49	286.23	286.42	1738120.0
2018-08-22 13:30:00	SPY	ETF	286.42	286.53	286.32	286.435	1497950.0
2018-08-22 14:00:00	SPY	ETF	286.435	286.72	285.9811	286.21	2445145.0
2018-08-22 14:30:00	SPY	ETF	286.21	286.28	286.06	286.27	2043372.0
2018-08-22 15:00:00	SPY	ETF	286.28	286.41	286.21	286.335	2099006.0
2018-08-22 15:30:00	SPY	ETF	286.34	286.53	286.19	286.2	5770545.0
2018-08-22 16:00:00	SPY	ETF	286.2	286.24	286.0	286.05	3329946.0
2018-08-22 16:30:00	SPY	ETF	286.05	286.13	286.0	286.13	100435.0
2018-08-22 17:00:00	SPY	ETF	286.11	286.17	285.95	286.05	91829.0
2018-08-22 17:30:00	SPY	ETF	286.05	286.12	286.05	286.1	13804.0
2018-08-22 18:00:00	SPY	ETF	286.12	286.35	286.12	286.31	69555.0
2018-08-22 18:30:00	SPY	ETF	286.29	286.32	286.1962	286.3	33506.0
2018-08-22 19:00:00	SPY	ETF	286.3	286.3	286.25	286.25	2900.0
2018-08-22 19:30:00	SPY	ETF	286.25	286.25	286.13	286.18	13520.0
2018-08-22 04:00:00	QQQ	ETF	179.73	179.88	179.71	179.77	7980.0
2018-08-22 04:30:00	QQQ	ETF	179.79	179.9	179.78	179.9	8900.0
2018-08-22 05:00:00	QQQ	ETF	179.9	179.91	179.81	179.81	2500.0
2018-08-22 05:30:00	QQQ	ETF	179.85	179.9	179.85	179.85	4206.0
2018-08-22 06:00:00	QQQ	ETF	179.84	180.18	179.84	180.08	25683.0
2018-08-22 06:30:00	QQQ	ETF	180.08	180.24	180.01	180.21	21122.0
2018-08-22 07:00:00	QQQ	ETF	180.22	180.33	180.03	180.11	25130.0
2018-08-22 07:30:00	QQQ	ETF	180.11	180.16	179.97	180.09	14937.0
2018-08-22 08:00:00	QQQ	ETF	180.36	180.36	179.61	179.76	135732.0
2018-08-22 08:30:00	QQQ	ETF	179.8	179.92	179.68	179.87	100405.0
2018-08-22 09:00:00	QQQ	ETF	179.91	180.01	179.84	179.95	114890.0
2018-08-22 09:30:00	QQQ	ETF	179.96	180.59	179.92	180.03	2568709.0
2018-08-22 10:00:00	QQQ	ETF	180.05	180.52	179.75	180.1699	1532517.0
2018-08-22 10:30:00	QQQ	ETF	180.18	180.901	180.18	180.85	1198912.0
2018-08-22 11:00:00	QQQ	ETF	180.85	181.1	180.79	181.08	1053007.0
2018-08-22 11:30:00	QQQ	ETF	181.08	181.21	180.91	181.17	673919.0
2018-08-22 12:00:00	QQQ	ETF	181.165	181.2	180.81	180.8899	512372.0
2018-08-22 12:30:00	QQQ	ETF	180.8723	180.94	180.73	180.82	688110.0

> showing 50 of 16,017 rows — these rows as CSV

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