PREVIEW / etf_30min / 2020-10-16

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-16.parquet
  size:    541 KB
  rows:    19,826

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
2020-10-16 04:00:00	SPY	ETF	347.55	347.75	347.37	347.61	13943.0
2020-10-16 04:30:00	SPY	ETF	347.69	347.82	347.6	347.79	28252.0
2020-10-16 05:00:00	SPY	ETF	347.81	347.81	347.49	347.49	4926.0
2020-10-16 05:30:00	SPY	ETF	347.35	347.53	347.03	347.53	14248.0
2020-10-16 06:00:00	SPY	ETF	347.46	348.09	347.34	348.09	8784.0
2020-10-16 06:30:00	SPY	ETF	348.19	348.28	347.58	348.0	156986.0
2020-10-16 07:00:00	SPY	ETF	348.02	348.5	347.78	348.26	119933.0
2020-10-16 07:30:00	SPY	ETF	348.27	348.6	348.22	348.23	66100.0
2020-10-16 08:00:00	SPY	ETF	347.7699	348.51	347.0	348.36	145597.0
2020-10-16 08:30:00	SPY	ETF	348.36	349.0	348.36	348.98	306702.0
2020-10-16 09:00:00	SPY	ETF	348.96	349.16	348.3	348.95	437234.0
2020-10-16 09:30:00	SPY	ETF	348.96	349.2	348.27	349.13	5391850.0
2020-10-16 10:00:00	SPY	ETF	349.13	350.69	349.07	350.62	9830022.0
2020-10-16 10:30:00	SPY	ETF	350.62	350.75	349.77	349.89	7145691.0
2020-10-16 11:00:00	SPY	ETF	349.88	349.89	348.56	349.09	5386510.0
2020-10-16 11:30:00	SPY	ETF	349.08	349.58	348.82	349.44	3290610.0
2020-10-16 12:00:00	SPY	ETF	349.43	349.48	348.6	349.18	2474354.0
2020-10-16 12:30:00	SPY	ETF	349.18	349.23	348.36	349.001	3029247.0
2020-10-16 13:00:00	SPY	ETF	349.01	349.43	348.84	349.31	2213241.0
2020-10-16 13:30:00	SPY	ETF	349.32	349.56	349.08	349.25	2342003.0
2020-10-16 14:00:00	SPY	ETF	349.27	349.74	348.95	349.62	4003801.0
2020-10-16 14:30:00	SPY	ETF	349.625	349.92	349.33	349.89	2783573.0
2020-10-16 15:00:00	SPY	ETF	349.88	349.91	348.56	348.86	3417893.0
2020-10-16 15:30:00	SPY	ETF	348.86	348.92	347.1	347.24	12958255.0
2020-10-16 16:00:00	SPY	ETF	347.24	347.4833	346.06	346.3	20992315.0
2020-10-16 16:30:00	SPY	ETF	346.29	347.29	346.25	346.39	886901.0
2020-10-16 17:00:00	SPY	ETF	346.4	347.29	346.17	346.2	923869.0
2020-10-16 17:30:00	SPY	ETF	346.2	347.29	346.06	346.27	107147.0
2020-10-16 18:00:00	SPY	ETF	346.28	346.48	346.2	346.36	52198.0
2020-10-16 18:30:00	SPY	ETF	346.35	346.48	346.29	346.45	21969.0
2020-10-16 19:00:00	SPY	ETF	346.41	346.48	346.38	346.4	20754.0
2020-10-16 19:30:00	SPY	ETF	346.39	346.45	346.21	346.21	39324.0
2020-10-16 04:00:00	QQQ	ETF	290.1	290.97	290.1	290.41	35379.0
2020-10-16 04:30:00	QQQ	ETF	290.34	290.68	290.22	290.56	16760.0
2020-10-16 05:00:00	QQQ	ETF	290.45	290.61	289.8	289.8	28496.0
2020-10-16 05:30:00	QQQ	ETF	289.78	290.1	289.62	290.1	16415.0
2020-10-16 06:00:00	QQQ	ETF	290.17	290.67	289.77	290.6	19873.0
2020-10-16 06:30:00	QQQ	ETF	290.62	290.87	289.67	290.17	40260.0
2020-10-16 07:00:00	QQQ	ETF	290.14	290.78	289.97	290.62	133842.0
2020-10-16 07:30:00	QQQ	ETF	290.69	291.38	290.69	290.97	84955.0
2020-10-16 08:00:00	QQQ	ETF	290.25	291.34	288.9	291.3	69993.0
2020-10-16 08:30:00	QQQ	ETF	291.36	292.0	291.33	291.98	168732.0
2020-10-16 09:00:00	QQQ	ETF	291.96	292.12	291.41	291.83	537359.0
2020-10-16 09:30:00	QQQ	ETF	291.83	291.98	290.9501	291.795	3211447.0
2020-10-16 10:00:00	QQQ	ETF	291.8	293.269	291.76	293.09	2691192.0
2020-10-16 10:30:00	QQQ	ETF	293.09	293.22	291.63	291.95	2211637.0
2020-10-16 11:00:00	QQQ	ETF	291.95	291.95	289.68	290.42	3441969.0
2020-10-16 11:30:00	QQQ	ETF	290.385	291.05	290.09	290.98	1902610.0
2020-10-16 12:00:00	QQQ	ETF	290.96	291.16	290.13	290.83	1466362.0
2020-10-16 12:30:00	QQQ	ETF	290.79	290.915	289.78	290.76	1952700.0

> showing 50 of 19,826 rows — these rows as CSV

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