PREVIEW / etf_30min / 2018-11-16

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-16.parquet
  size:    483 KB
  rows:    16,772

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-11-16 04:00:00	SPY	ETF	272.45	272.46	272.28	272.32	10742.0
2018-11-16 04:30:00	SPY	ETF	272.34	272.59	272.34	272.5	10120.0
2018-11-16 05:00:00	SPY	ETF	272.41	272.44	272.04	272.14	13620.0
2018-11-16 05:30:00	SPY	ETF	272.12	272.2	271.9	272.0	19048.0
2018-11-16 06:00:00	SPY	ETF	271.97	272.0	271.54	271.66	35602.0
2018-11-16 06:30:00	SPY	ETF	271.66	272.08	271.64	271.93	60588.0
2018-11-16 07:00:00	SPY	ETF	272.0	272.09	271.3	271.63	145503.0
2018-11-16 07:30:00	SPY	ETF	271.57	271.76	271.13	271.68	204101.0
2018-11-16 08:00:00	SPY	ETF	271.8301	272.54	271.05	271.16	315616.0
2018-11-16 08:30:00	SPY	ETF	271.13	272.08	270.77	272.06	890041.0
2018-11-16 09:00:00	SPY	ETF	272.04	272.32	271.45	271.8	1290767.0
2018-11-16 09:30:00	SPY	ETF	271.79	272.81	271.21	272.72	14882095.0
2018-11-16 10:00:00	SPY	ETF	272.695	273.19	272.2678	272.86	8351021.0
2018-11-16 10:30:00	SPY	ETF	272.86	273.95	272.77	273.23	8193284.0
2018-11-16 11:00:00	SPY	ETF	273.24	273.41	272.53	272.77	7551125.0
2018-11-16 11:30:00	SPY	ETF	272.77	272.99	272.05	272.3511	5928038.0
2018-11-16 12:00:00	SPY	ETF	272.36	272.88	272.03	272.14	3380786.0
2018-11-16 12:30:00	SPY	ETF	272.1411	274.75	271.85	273.8625	13327198.0
2018-11-16 13:00:00	SPY	ETF	273.865	274.015	272.86	273.04	5100465.0
2018-11-16 13:30:00	SPY	ETF	273.06	273.13	272.35	272.86	4791392.0
2018-11-16 14:00:00	SPY	ETF	272.8638	273.62	272.68	273.39	4651569.0
2018-11-16 14:30:00	SPY	ETF	273.4	273.92	273.4	273.83	4441336.0
2018-11-16 15:00:00	SPY	ETF	273.83	274.39	273.62	274.105	6715163.0
2018-11-16 15:30:00	SPY	ETF	274.1	274.29	273.41	273.67	18119768.0
2018-11-16 16:00:00	SPY	ETF	273.67	274.35	273.4259	274.24	14519533.0
2018-11-16 16:30:00	SPY	ETF	274.22	274.3	273.73	274.04	676490.0
2018-11-16 17:00:00	SPY	ETF	273.6	274.22	273.6	273.98	326405.0
2018-11-16 17:30:00	SPY	ETF	273.98	274.17	273.73	273.95	875396.0
2018-11-16 18:00:00	SPY	ETF	273.95	273.96	273.81	273.96	25942.0
2018-11-16 18:30:00	SPY	ETF	273.94	273.99	273.9	273.97	4600.0
2018-11-16 19:00:00	SPY	ETF	273.97	274.05	273.92	274.05	4864.0
2018-11-16 19:30:00	SPY	ETF	274.05	274.1	274.01	274.1	6688.0
2018-11-16 04:00:00	QQQ	ETF	167.21	167.21	166.66	166.7	6589.0
2018-11-16 04:30:00	QQQ	ETF	166.74	167.0	166.74	166.93	20970.0
2018-11-16 05:00:00	QQQ	ETF	166.98	166.98	166.6	166.65	11028.0
2018-11-16 05:30:00	QQQ	ETF	166.64	166.69	166.4	166.51	30450.0
2018-11-16 06:00:00	QQQ	ETF	166.51	166.55	166.07	166.29	46316.0
2018-11-16 06:30:00	QQQ	ETF	166.2	166.48	166.18	166.39	18389.0
2018-11-16 07:00:00	QQQ	ETF	166.5	166.54	166.18	166.32	111932.0
2018-11-16 07:30:00	QQQ	ETF	166.32	166.73	166.08	166.57	250669.0
2018-11-16 08:00:00	QQQ	ETF	166.28	167.5	165.98	166.0	175762.0
2018-11-16 08:30:00	QQQ	ETF	166.0	166.69	165.75	166.68	703211.0
2018-11-16 09:00:00	QQQ	ETF	166.68	166.89	166.28	166.5	922759.0
2018-11-16 09:30:00	QQQ	ETF	166.49	167.44	165.78	167.26	6153774.0
2018-11-16 10:00:00	QQQ	ETF	167.2301	167.63	166.805	167.4	3608332.0
2018-11-16 10:30:00	QQQ	ETF	167.41	168.1	167.29	167.39	3342538.0
2018-11-16 11:00:00	QQQ	ETF	167.41	167.5299	166.7	167.03	2142284.0
2018-11-16 11:30:00	QQQ	ETF	167.03	167.22	166.19	166.46	2843160.0
2018-11-16 12:00:00	QQQ	ETF	166.46	166.88	166.12	166.37	2703676.0
2018-11-16 12:30:00	QQQ	ETF	166.35	168.31	166.17	167.58	5215123.0

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

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