PREVIEW / etf_30min / 2019-04-17

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-17.parquet
  size:    495 KB
  rows:    17,321

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-04-17 04:00:00	SPY	ETF	290.52	290.71	290.52	290.71	3230.0
2019-04-17 04:30:00	SPY	ETF	290.66	290.69	290.64	290.68	11176.0
2019-04-17 05:00:00	SPY	ETF	290.69	290.78	290.66	290.68	8484.0
2019-04-17 05:30:00	SPY	ETF	290.72	290.81	290.72	290.79	4951.0
2019-04-17 06:00:00	SPY	ETF	290.82	290.82	290.77	290.79	14319.0
2019-04-17 06:30:00	SPY	ETF	290.8	290.81	290.72	290.76	16064.0
2019-04-17 07:00:00	SPY	ETF	290.7	290.9	290.7	290.86	24000.0
2019-04-17 07:30:00	SPY	ETF	290.84	290.95	290.84	290.89	72442.0
2019-04-17 08:00:00	SPY	ETF	290.7401	290.98	290.46	290.92	160657.0
2019-04-17 08:30:00	SPY	ETF	290.92	291.14	290.92	291.08	169659.0
2019-04-17 09:00:00	SPY	ETF	291.08	291.41	291.05	291.41	403739.0
2019-04-17 09:30:00	SPY	ETF	291.4	291.425	290.1	290.125	6980029.0
2019-04-17 10:00:00	SPY	ETF	290.125	290.205	289.58	290.18	5347647.0
2019-04-17 10:30:00	SPY	ETF	290.17	290.31	289.78	289.82	2755222.0
2019-04-17 11:00:00	SPY	ETF	289.83	290.21	289.66	289.69	4049541.0
2019-04-17 11:30:00	SPY	ETF	289.68	289.94	289.35	289.59	2984103.0
2019-04-17 12:00:00	SPY	ETF	289.58	289.64	289.2	289.61	2564531.0
2019-04-17 12:30:00	SPY	ETF	289.61	289.84	289.565	289.73	1793775.0
2019-04-17 13:00:00	SPY	ETF	289.74	290.15	289.52	289.59	3669847.0
2019-04-17 13:30:00	SPY	ETF	289.6	289.85	289.51	289.53	1462941.0
2019-04-17 14:00:00	SPY	ETF	289.53	289.64	288.99	289.07	3610549.0
2019-04-17 14:30:00	SPY	ETF	289.075	289.555	289.07	289.49	2114068.0
2019-04-17 15:00:00	SPY	ETF	289.48	289.6801	289.47	289.53	2037829.0
2019-04-17 15:30:00	SPY	ETF	289.54	289.8	289.45	289.48	6925269.0
2019-04-17 16:00:00	SPY	ETF	289.49	289.5102	289.12	289.22	9599903.0
2019-04-17 16:30:00	SPY	ETF	289.23	289.5069	289.11	289.22	356683.0
2019-04-17 17:00:00	SPY	ETF	289.225	289.25	289.11	289.12	52636.0
2019-04-17 17:30:00	SPY	ETF	289.18	289.45	289.13	289.18	36720.0
2019-04-17 18:00:00	SPY	ETF	289.19	289.32	289.17	289.26	78269.0
2019-04-17 18:30:00	SPY	ETF	289.25	289.34	289.25	289.33	43316.0
2019-04-17 19:00:00	SPY	ETF	289.33	289.37	289.3	289.35	51102.0
2019-04-17 19:30:00	SPY	ETF	289.35	289.42	289.29	289.4199	37903.0
2019-04-17 04:00:00	QQQ	ETF	186.95	187.06	186.95	187.06	6399.0
2019-04-17 04:30:00	QQQ	ETF	187.01	187.01	187.0	187.0	300.0
2019-04-17 05:00:00	QQQ	ETF	187.07	187.07	187.05	187.05	2500.0
2019-04-17 05:30:00	QQQ	ETF	187.09	187.11	187.06	187.1	29978.0
2019-04-17 06:00:00	QQQ	ETF	187.1	187.17	187.1	187.14	16390.0
2019-04-17 06:30:00	QQQ	ETF	187.13	187.13	187.11	187.11	2650.0
2019-04-17 07:00:00	QQQ	ETF	187.08	187.27	187.08	187.24	31412.0
2019-04-17 07:30:00	QQQ	ETF	187.27	187.3	187.26	187.28	46345.0
2019-04-17 08:00:00	QQQ	ETF	187.1401	187.5	186.95	187.49	101271.0
2019-04-17 08:30:00	QQQ	ETF	187.44	187.66	187.44	187.57	134884.0
2019-04-17 09:00:00	QQQ	ETF	187.58	187.88	187.56	187.78	123842.0
2019-04-17 09:30:00	QQQ	ETF	187.75	187.93	187.045	187.0985	3077541.0
2019-04-17 10:00:00	QQQ	ETF	187.105	187.43	186.635	187.37	2619638.0
2019-04-17 10:30:00	QQQ	ETF	187.37	187.55	187.03	187.06	1587954.0
2019-04-17 11:00:00	QQQ	ETF	187.07	187.33	186.85	186.92	924286.0
2019-04-17 11:30:00	QQQ	ETF	186.9	187.26	186.6	187.005	1552506.0
2019-04-17 12:00:00	QQQ	ETF	187.0	187.09	186.63	187.09	1112546.0
2019-04-17 12:30:00	QQQ	ETF	187.09	187.28	187.04	187.17	883891.0

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

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