PREVIEW / etf_30min / 2018-08-29

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-29.parquet
  size:    476 KB
  rows:    16,190

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-29 04:00:00	SPY	ETF	290.15	290.25	290.15	290.2	3771.0
2018-08-29 04:30:00	SPY	ETF	290.22	290.22	290.17	290.17	700.0
2018-08-29 05:00:00	SPY	ETF	290.1	290.26	290.1	290.2	7300.0
2018-08-29 05:30:00	SPY	ETF	290.1	290.1	289.94	290.02	9907.0
2018-08-29 06:00:00	SPY	ETF	290.02	290.03	289.92	289.92	11752.0
2018-08-29 06:30:00	SPY	ETF	289.96	290.0	289.89	289.9	4300.0
2018-08-29 07:00:00	SPY	ETF	289.94	290.12	289.91	290.05	24564.0
2018-08-29 07:30:00	SPY	ETF	290.12	290.18	290.08	290.17	7588.0
2018-08-29 08:00:00	SPY	ETF	290.0699	290.44	289.81	289.84	51503.0
2018-08-29 08:30:00	SPY	ETF	289.91	289.92	289.72	289.9	162072.0
2018-08-29 09:00:00	SPY	ETF	289.87	290.18	289.85	290.17	349292.0
2018-08-29 09:30:00	SPY	ETF	290.16	290.27	289.8854	290.18	3872791.0
2018-08-29 10:00:00	SPY	ETF	290.18	290.54	289.96	290.53	3058380.0
2018-08-29 10:30:00	SPY	ETF	290.53	290.93	290.5	290.88	3730705.0
2018-08-29 11:00:00	SPY	ETF	290.88	291.47	290.77	291.43	3702904.0
2018-08-29 11:30:00	SPY	ETF	291.42	291.58	291.22	291.455	5407524.0
2018-08-29 12:00:00	SPY	ETF	291.46	291.62	291.3	291.4648	4659067.0
2018-08-29 12:30:00	SPY	ETF	291.465	291.57	291.39	291.495	1825580.0
2018-08-29 13:00:00	SPY	ETF	291.5	291.57	291.295	291.35	1947602.0
2018-08-29 13:30:00	SPY	ETF	291.36	291.36	291.12	291.1498	1700981.0
2018-08-29 14:00:00	SPY	ETF	291.14	291.355	291.13	291.26	2326879.0
2018-08-29 14:30:00	SPY	ETF	291.255	291.42	291.2246	291.345	2796410.0
2018-08-29 15:00:00	SPY	ETF	291.35	291.65	291.35	291.61	5626425.0
2018-08-29 15:30:00	SPY	ETF	291.62	291.74	291.355	291.47	9299641.0
2018-08-29 16:00:00	SPY	ETF	291.45	291.51	291.35	291.43	5163070.0
2018-08-29 16:30:00	SPY	ETF	291.44	291.51	289.8279	291.5	3903332.0
2018-08-29 17:00:00	SPY	ETF	291.48	291.53	291.46	291.49	35603.0
2018-08-29 17:30:00	SPY	ETF	291.49	291.5	291.49	291.5	8313.0
2018-08-29 18:00:00	SPY	ETF	291.55	291.58	291.45	291.52	22988.0
2018-08-29 18:30:00	SPY	ETF	291.52	291.59	291.49	291.55	8126.0
2018-08-29 19:00:00	SPY	ETF	291.53	291.55	291.52	291.55	1606.0
2018-08-29 19:30:00	SPY	ETF	291.53	291.53	291.45	291.46	16300.0
2018-08-29 04:00:00	QQQ	ETF	184.79	185.01	184.79	184.99	4100.0
2018-08-29 04:30:00	QQQ	ETF	184.99	185.03	184.99	185.0	3050.0
2018-08-29 05:00:00	QQQ	ETF	185.0	185.02	185.0	185.0	7895.0
2018-08-29 05:30:00	QQQ	ETF	184.95	184.95	184.95	184.95	2100.0
2018-08-29 06:00:00	QQQ	ETF	184.86	184.88	184.82	184.88	1200.0
2018-08-29 06:30:00	QQQ	ETF	184.84	184.86	184.8	184.8	11280.0
2018-08-29 07:00:00	QQQ	ETF	184.82	184.92	184.82	184.88	30668.0
2018-08-29 07:30:00	QQQ	ETF	184.91	184.92	184.87	184.92	8992.0
2018-08-29 08:00:00	QQQ	ETF	184.84	185.05	184.61	184.72	128541.0
2018-08-29 08:30:00	QQQ	ETF	184.71	184.77	184.65	184.74	102401.0
2018-08-29 09:00:00	QQQ	ETF	184.74	184.93	184.73	184.9	143272.0
2018-08-29 09:30:00	QQQ	ETF	184.91	185.43	184.86	185.31	2970003.0
2018-08-29 10:00:00	QQQ	ETF	185.304	185.69	185.17	185.68	1263826.0
2018-08-29 10:30:00	QQQ	ETF	185.69	186.16	185.62	186.04	2124185.0
2018-08-29 11:00:00	QQQ	ETF	186.04	186.44	185.96	186.4	1721077.0
2018-08-29 11:30:00	QQQ	ETF	186.405	186.54	186.23	186.38	2030791.0
2018-08-29 12:00:00	QQQ	ETF	186.38	186.48	186.23	186.39	1086803.0
2018-08-29 12:30:00	QQQ	ETF	186.39	186.5075	186.27	186.49	1080227.0

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

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