PREVIEW / etf_30min / 2019-10-09

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-09.parquet
  size:    506 KB
  rows:    17,613

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-10-09 04:00:00	SPY	ETF	289.5	289.92	289.42	289.92	13983.0
2019-10-09 04:30:00	SPY	ETF	289.98	290.15	289.8	290.03	9421.0
2019-10-09 05:00:00	SPY	ETF	290.0	291.51	290.0	290.97	94625.0
2019-10-09 05:30:00	SPY	ETF	290.89	292.72	290.78	291.38	81423.0
2019-10-09 06:00:00	SPY	ETF	291.15	291.41	290.68	291.21	46710.0
2019-10-09 06:30:00	SPY	ETF	291.19	291.34	291.01	291.06	61864.0
2019-10-09 07:00:00	SPY	ETF	291.01	291.34	290.82	291.3	183037.0
2019-10-09 07:30:00	SPY	ETF	291.26	291.37	291.0	291.36	273002.0
2019-10-09 08:00:00	SPY	ETF	291.37	291.42	289.1	291.01	377299.0
2019-10-09 08:30:00	SPY	ETF	291.05	291.09	290.65	290.89	382824.0
2019-10-09 09:00:00	SPY	ETF	290.89	290.891	289.45	290.75	414952.0
2019-10-09 09:30:00	SPY	ETF	290.75	291.25	290.14	290.43	6220055.0
2019-10-09 10:00:00	SPY	ETF	290.41	290.98	290.3	290.94	2402888.0
2019-10-09 10:30:00	SPY	ETF	290.94	291.06	290.52	290.75	3552004.0
2019-10-09 11:00:00	SPY	ETF	290.74	290.91	290.06	290.457	4252119.0
2019-10-09 11:30:00	SPY	ETF	290.44	291.32	290.39	290.94	2797723.0
2019-10-09 12:00:00	SPY	ETF	290.95	291.32	290.94	291.0681	1476766.0
2019-10-09 12:30:00	SPY	ETF	291.0699	291.33	290.95	291.325	1133115.0
2019-10-09 13:00:00	SPY	ETF	291.34	291.82	290.97	291.125	2774144.0
2019-10-09 13:30:00	SPY	ETF	291.1247	291.58	291.1	291.39	2376494.0
2019-10-09 14:00:00	SPY	ETF	291.4	291.71	291.13	291.52	2582512.0
2019-10-09 14:30:00	SPY	ETF	291.53	292.04	291.53	291.935	3093075.0
2019-10-09 15:00:00	SPY	ETF	291.93	292.13	291.87	292.04	2727219.0
2019-10-09 15:30:00	SPY	ETF	292.05	292.3	291.04	291.23	13858391.0
2019-10-09 16:00:00	SPY	ETF	291.22	291.34	290.92	291.29	6733538.0
2019-10-09 16:30:00	SPY	ETF	291.29	291.62	291.2729	291.46	358679.0
2019-10-09 17:00:00	SPY	ETF	291.47	291.47	291.31	291.37	49635.0
2019-10-09 17:30:00	SPY	ETF	291.37	291.4	291.29	291.32	1613395.0
2019-10-09 18:00:00	SPY	ETF	291.38	291.67	287.72	288.18	608863.0
2019-10-09 18:30:00	SPY	ETF	288.18	288.86	287.6	287.95	502406.0
2019-10-09 19:00:00	SPY	ETF	287.84	288.38	287.76	288.09	149345.0
2019-10-09 19:30:00	SPY	ETF	288.13	289.28	288.02	289.22	133903.0
2019-10-09 04:00:00	QQQ	ETF	185.94	186.26	185.87	186.16	4610.0
2019-10-09 04:30:00	QQQ	ETF	186.3	186.5	186.14	186.39	7686.0
2019-10-09 05:00:00	QQQ	ETF	186.36	187.49	186.35	187.26	30524.0
2019-10-09 05:30:00	QQQ	ETF	187.13	187.72	186.92	187.44	30187.0
2019-10-09 06:00:00	QQQ	ETF	187.36	187.4	186.95	187.28	38064.0
2019-10-09 06:30:00	QQQ	ETF	187.29	187.45	187.18	187.3	8540.0
2019-10-09 07:00:00	QQQ	ETF	187.24	187.4	187.03	187.36	80896.0
2019-10-09 07:30:00	QQQ	ETF	187.35	187.41	187.16	187.36	123589.0
2019-10-09 08:00:00	QQQ	ETF	187.06	187.47	185.31	187.13	144768.0
2019-10-09 08:30:00	QQQ	ETF	187.1	187.18	186.86	186.99	143410.0
2019-10-09 09:00:00	QQQ	ETF	187.02	187.02	186.68	186.93	105265.0
2019-10-09 09:30:00	QQQ	ETF	186.96	187.29	186.43	186.7	2133057.0
2019-10-09 10:00:00	QQQ	ETF	186.7	187.11	186.6	187.06	1198726.0
2019-10-09 10:30:00	QQQ	ETF	187.04	187.18	186.88	187.127	877151.0
2019-10-09 11:00:00	QQQ	ETF	187.13	187.27	186.62	186.835	2328421.0
2019-10-09 11:30:00	QQQ	ETF	186.83	187.4945	186.8	187.25	1128228.0
2019-10-09 12:00:00	QQQ	ETF	187.26	187.48	187.185	187.245	639038.0
2019-10-09 12:30:00	QQQ	ETF	187.26	187.54	187.25	187.5	446295.0

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

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