PREVIEW / etf_30min / 2019-07-18

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-18.parquet
  size:    507 KB
  rows:    17,564

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
2019-07-18 04:00:00	SPY	ETF	297.28	297.28	296.79	296.89	34638.0
2019-07-18 04:30:00	SPY	ETF	296.88	296.88	296.84	296.88	500.0
2019-07-18 05:00:00	SPY	ETF	297.07	297.3	297.07	297.27	2720.0
2019-07-18 05:30:00	SPY	ETF	297.29	297.32	297.16	297.17	13564.0
2019-07-18 06:00:00	SPY	ETF	297.17	297.32	297.12	297.32	2311.0
2019-07-18 06:30:00	SPY	ETF	297.25	297.51	297.19	297.5	44972.0
2019-07-18 07:00:00	SPY	ETF	297.48	297.68	297.39	297.51	74972.0
2019-07-18 07:30:00	SPY	ETF	297.53	297.55	297.34	297.38	105035.0
2019-07-18 08:00:00	SPY	ETF	297.5001	297.56	296.72	297.55	59859.0
2019-07-18 08:30:00	SPY	ETF	297.54	297.79	297.48	297.48	181648.0
2019-07-18 09:00:00	SPY	ETF	297.43	297.46	297.16	297.22	177273.0
2019-07-18 09:30:00	SPY	ETF	297.19	297.7	297.05	297.535	4672657.0
2019-07-18 10:00:00	SPY	ETF	297.535	298.05	297.32	297.905	3139940.0
2019-07-18 10:30:00	SPY	ETF	297.93	298.12	297.67	297.85	2314315.0
2019-07-18 11:00:00	SPY	ETF	297.85	297.94	297.11	297.225	2455377.0
2019-07-18 11:30:00	SPY	ETF	297.22	297.26	296.7	296.845	3306688.0
2019-07-18 12:00:00	SPY	ETF	296.84	297.51	296.79	297.42	2927877.0
2019-07-18 12:30:00	SPY	ETF	297.42	297.64	297.3701	297.43	2481198.0
2019-07-18 13:00:00	SPY	ETF	297.435	297.79	297.4	297.615	2210263.0
2019-07-18 13:30:00	SPY	ETF	297.62	297.79	297.44	297.64	1489885.0
2019-07-18 14:00:00	SPY	ETF	297.64	298.615	297.6215	298.5025	5622837.0
2019-07-18 14:30:00	SPY	ETF	298.5	298.9353	298.44	298.92	3591441.0
2019-07-18 15:00:00	SPY	ETF	298.92	299.25	298.38	298.66	4234245.0
2019-07-18 15:30:00	SPY	ETF	298.655	298.9	298.41	298.85	6634403.0
2019-07-18 16:00:00	SPY	ETF	298.85	299.08	298.68	298.88	4444906.0
2019-07-18 16:30:00	SPY	ETF	298.92	299.62	298.92	299.5	528132.0
2019-07-18 17:00:00	SPY	ETF	299.49	299.5	298.83	299.44	32848.0
2019-07-18 17:30:00	SPY	ETF	299.45	299.54	298.83	299.54	33762.0
2019-07-18 18:00:00	SPY	ETF	299.54	300.0	298.82	298.95	224375.0
2019-07-18 18:30:00	SPY	ETF	298.99	299.29	298.81	298.84	73405.0
2019-07-18 19:00:00	SPY	ETF	298.86	299.19	298.79	299.06	50811.0
2019-07-18 19:30:00	SPY	ETF	299.09	299.35	299.09	299.19	19418.0
2019-07-18 04:00:00	QQQ	ETF	191.2	191.2	190.94	190.96	3644.0
2019-07-18 04:30:00	QQQ	ETF	190.99	191.04	190.98	191.04	1000.0
2019-07-18 05:00:00	QQQ	ETF	191.18	191.32	191.18	191.25	3328.0
2019-07-18 05:30:00	QQQ	ETF	191.27	191.3	191.15	191.18	6727.0
2019-07-18 06:00:00	QQQ	ETF	191.2	191.26	191.13	191.22	4325.0
2019-07-18 06:30:00	QQQ	ETF	191.2	191.4	191.2	191.37	32050.0
2019-07-18 07:00:00	QQQ	ETF	191.36	191.5	191.32	191.41	30040.0
2019-07-18 07:30:00	QQQ	ETF	191.4	191.5	191.33	191.34	11206.0
2019-07-18 08:00:00	QQQ	ETF	191.3401	191.49	190.48	191.47	84314.0
2019-07-18 08:30:00	QQQ	ETF	191.46	191.73	191.37	191.5	55295.0
2019-07-18 09:00:00	QQQ	ETF	191.49	191.53	191.3	191.33	58448.0
2019-07-18 09:30:00	QQQ	ETF	191.3	192.07	191.17	191.75	2550088.0
2019-07-18 10:00:00	QQQ	ETF	191.7599	192.14	191.53	191.885	1845915.0
2019-07-18 10:30:00	QQQ	ETF	191.89	192.0	191.41	191.53	1834413.0
2019-07-18 11:00:00	QQQ	ETF	191.54	191.62	190.91	191.04	1684756.0
2019-07-18 11:30:00	QQQ	ETF	191.04	191.07	190.69	190.77	2091766.0
2019-07-18 12:00:00	QQQ	ETF	190.77	191.25	190.71	191.15	2104891.0
2019-07-18 12:30:00	QQQ	ETF	191.16	191.31	191.06	191.12	626486.0

> showing 50 of 17,564 rows — these rows as CSV

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