PREVIEW / etf_30min / 2019-10-03

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-03.parquet
  size:    520 KB
  rows:    17,919

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-03 04:00:00	SPY	ETF	288.4	288.7	288.03	288.66	27929.0
2019-10-03 04:30:00	SPY	ETF	288.58	288.64	288.29	288.4	8140.0
2019-10-03 05:00:00	SPY	ETF	288.39	288.53	288.34	288.34	2411.0
2019-10-03 05:30:00	SPY	ETF	288.21	288.5	288.1	288.5	9440.0
2019-10-03 06:00:00	SPY	ETF	288.45	288.58	288.34	288.53	15212.0
2019-10-03 06:30:00	SPY	ETF	288.56	288.59	287.89	287.9	29833.0
2019-10-03 07:00:00	SPY	ETF	287.9	288.1	287.79	288.02	59640.0
2019-10-03 07:30:00	SPY	ETF	288.04	288.05	287.18	287.39	135445.0
2019-10-03 08:00:00	SPY	ETF	288.0101	288.72	287.16	287.68	192533.0
2019-10-03 08:30:00	SPY	ETF	287.65	287.9	287.53	287.56	271851.0
2019-10-03 09:00:00	SPY	ETF	287.56	287.98	287.54	287.84	300545.0
2019-10-03 09:30:00	SPY	ETF	287.81	288.45	287.38	288.33	6018722.0
2019-10-03 10:00:00	SPY	ETF	288.03	288.33	284.82	287.07	18636540.0
2019-10-03 10:30:00	SPY	ETF	287.08	287.76	286.43	287.3898	7909867.0
2019-10-03 11:00:00	SPY	ETF	287.37	289.46	287.09	288.625	11238111.0
2019-10-03 11:30:00	SPY	ETF	288.63	288.71	287.95	288.09	4775199.0
2019-10-03 12:00:00	SPY	ETF	288.09	289.07	288.09	288.89	2670430.0
2019-10-03 12:30:00	SPY	ETF	288.89	289.63	288.79	289.48	2858121.0
2019-10-03 13:00:00	SPY	ETF	289.49	289.67	289.16	289.3578	2069051.0
2019-10-03 13:30:00	SPY	ETF	289.35	290.09	289.28	289.98	2871117.0
2019-10-03 14:00:00	SPY	ETF	289.985	290.225	289.67	290.1552	3253110.0
2019-10-03 14:30:00	SPY	ETF	290.17	290.2	289.635	289.71	3281024.0
2019-10-03 15:00:00	SPY	ETF	289.71	289.85	289.345	289.57	4464163.0
2019-10-03 15:30:00	SPY	ETF	289.5747	290.4	289.09	290.37	9485721.0
2019-10-03 16:00:00	SPY	ETF	290.38	290.55	290.3111	290.52	3474318.0
2019-10-03 16:30:00	SPY	ETF	290.51	290.53	290.4	290.45	476210.0
2019-10-03 17:00:00	SPY	ETF	290.45	290.46	290.35	290.46	122116.0
2019-10-03 17:30:00	SPY	ETF	290.43	290.47	290.36	290.36	30549.0
2019-10-03 18:00:00	SPY	ETF	290.45	290.53	290.28	290.53	35123.0
2019-10-03 18:30:00	SPY	ETF	290.41	290.41	290.21	290.21	35517.0
2019-10-03 19:00:00	SPY	ETF	290.22	290.29	290.2	290.24	15382.0
2019-10-03 19:30:00	SPY	ETF	290.29	290.3	290.02	290.07	98773.0
2019-10-03 04:00:00	QQQ	ETF	184.26	184.54	184.05	184.48	6491.0
2019-10-03 04:30:00	QQQ	ETF	184.44	184.44	184.27	184.27	2200.0
2019-10-03 05:00:00	QQQ	ETF	184.26	184.44	184.26	184.35	1500.0
2019-10-03 05:30:00	QQQ	ETF	184.23	184.4	184.22	184.38	9950.0
2019-10-03 06:00:00	QQQ	ETF	184.47	184.47	184.47	184.47	600.0
2019-10-03 06:30:00	QQQ	ETF	184.38	184.38	184.04	184.06	7999.0
2019-10-03 07:00:00	QQQ	ETF	184.12	184.17	184.02	184.13	10260.0
2019-10-03 07:30:00	QQQ	ETF	184.1	184.1	183.52	183.71	67377.0
2019-10-03 08:00:00	QQQ	ETF	184.02	184.55	183.55	183.86	60122.0
2019-10-03 08:30:00	QQQ	ETF	183.86	184.02	183.76	183.78	130570.0
2019-10-03 09:00:00	QQQ	ETF	183.78	184.14	183.72	184.07	282015.0
2019-10-03 09:30:00	QQQ	ETF	184.07	184.4975	183.6322	184.1974	3168595.0
2019-10-03 10:00:00	QQQ	ETF	184.19	184.19	181.82	183.42	7051775.0
2019-10-03 10:30:00	QQQ	ETF	183.4222	183.86	182.89	183.7	3488953.0
2019-10-03 11:00:00	QQQ	ETF	183.69	185.37	183.5	184.89	4209560.0
2019-10-03 11:30:00	QQQ	ETF	184.88	184.95	184.45	184.54	1336551.0
2019-10-03 12:00:00	QQQ	ETF	184.57	185.44	184.57	185.29	2024773.0
2019-10-03 12:30:00	QQQ	ETF	185.29	185.8	185.19	185.65	1716844.0

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

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