PREVIEW / etf_30min / 2018-10-15

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-15.parquet
  size:    494 KB
  rows:    17,156

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-10-15 04:00:00	SPY	ETF	274.7	274.82	273.96	274.12	93398.0
2018-10-15 04:30:00	SPY	ETF	274.09	274.12	273.7	273.86	55387.0
2018-10-15 05:00:00	SPY	ETF	273.86	274.6	273.8	274.51	84958.0
2018-10-15 05:30:00	SPY	ETF	274.53	274.98	274.45	274.82	86603.0
2018-10-15 06:00:00	SPY	ETF	274.84	275.05	274.74	274.75	56031.0
2018-10-15 06:30:00	SPY	ETF	274.75	274.91	274.6	274.75	101194.0
2018-10-15 07:00:00	SPY	ETF	274.72	275.39	274.66	275.34	166313.0
2018-10-15 07:30:00	SPY	ETF	275.28	275.99	275.25	275.8	434282.0
2018-10-15 08:00:00	SPY	ETF	275.95	276.0	274.58	276.0	250393.0
2018-10-15 08:30:00	SPY	ETF	275.94	275.94	275.47	275.74	333846.0
2018-10-15 09:00:00	SPY	ETF	275.73	275.89	275.46	275.54	373446.0
2018-10-15 09:30:00	SPY	ETF	275.55	276.14	275.11	275.28	9868872.0
2018-10-15 10:00:00	SPY	ETF	275.26	275.42	274.3	275.06	7207243.0
2018-10-15 10:30:00	SPY	ETF	275.07	275.71	274.99	275.57	4600153.0
2018-10-15 11:00:00	SPY	ETF	275.58	276.6	275.46	276.54	5720752.0
2018-10-15 11:30:00	SPY	ETF	276.55	276.65	275.11	275.23	5339944.0
2018-10-15 12:00:00	SPY	ETF	275.23	275.55	274.62	275.45	7254552.0
2018-10-15 12:30:00	SPY	ETF	275.455	276.0593	275.34	275.75	3366356.0
2018-10-15 13:00:00	SPY	ETF	275.75	276.45	275.67	275.82	3052704.0
2018-10-15 13:30:00	SPY	ETF	275.83	276.84	275.71	276.5599	5021084.0
2018-10-15 14:00:00	SPY	ETF	276.57	276.63	275.44	275.53	4565652.0
2018-10-15 14:30:00	SPY	ETF	275.53	277.04	275.36	276.725	4644784.0
2018-10-15 15:00:00	SPY	ETF	276.73	276.95	275.51	275.63	10505925.0
2018-10-15 15:30:00	SPY	ETF	275.62	275.88	274.46	274.48	16789123.0
2018-10-15 16:00:00	SPY	ETF	274.47	275.78	274.02	274.17	8144319.0
2018-10-15 16:30:00	SPY	ETF	274.13	275.4	273.78	273.92	1771254.0
2018-10-15 17:00:00	SPY	ETF	273.94	274.01	273.92	273.99	39524.0
2018-10-15 17:30:00	SPY	ETF	274.01	274.4	273.96	273.98	131044.0
2018-10-15 18:00:00	SPY	ETF	273.96	274.6	273.75	274.0	82790.0
2018-10-15 18:30:00	SPY	ETF	274.09	274.32	274.09	274.19	51197.0
2018-10-15 19:00:00	SPY	ETF	274.21	274.71	274.16	274.55	79289.0
2018-10-15 19:30:00	SPY	ETF	274.58	274.75	274.51	274.67	31651.0
2018-10-15 04:00:00	QQQ	ETF	173.04	173.04	172.33	172.55	39129.0
2018-10-15 04:30:00	QQQ	ETF	172.6	172.6	172.09	172.28	16765.0
2018-10-15 05:00:00	QQQ	ETF	172.28	172.83	172.28	172.72	78153.0
2018-10-15 05:30:00	QQQ	ETF	172.71	173.01	172.68	172.9	98570.0
2018-10-15 06:00:00	QQQ	ETF	172.92	173.1	172.83	172.95	152400.0
2018-10-15 06:30:00	QQQ	ETF	172.95	173.05	172.83	172.96	126046.0
2018-10-15 07:00:00	QQQ	ETF	172.89	173.5	172.88	173.47	312403.0
2018-10-15 07:30:00	QQQ	ETF	173.47	174.08	173.42	173.99	340939.0
2018-10-15 08:00:00	QQQ	ETF	174.0	174.32	172.58	174.23	261300.0
2018-10-15 08:30:00	QQQ	ETF	174.15	174.15	173.7	173.88	294136.0
2018-10-15 09:00:00	QQQ	ETF	173.88	174.01	173.53	173.68	662299.0
2018-10-15 09:30:00	QQQ	ETF	173.69	173.99	172.53	172.7	8558798.0
2018-10-15 10:00:00	QQQ	ETF	172.67	172.79	171.56	172.25	6530736.0
2018-10-15 10:30:00	QQQ	ETF	172.25	172.87	172.14	172.78	3244875.0
2018-10-15 11:00:00	QQQ	ETF	172.8	173.9101	172.66	173.8	3864578.0
2018-10-15 11:30:00	QQQ	ETF	173.81	173.93	172.49	172.58	3017078.0
2018-10-15 12:00:00	QQQ	ETF	172.59	173.06	172.17	172.99	2899076.0
2018-10-15 12:30:00	QQQ	ETF	173.0	173.5	172.89	173.2	2034461.0

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

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