PREVIEW / etf_30min / 2018-10-23

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-23.parquet
  size:    515 KB
  rows:    17,743

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-23 04:00:00	SPY	ETF	272.11	272.11	271.48	271.62	69757.0
2018-10-23 04:30:00	SPY	ETF	271.66	271.98	271.51	271.66	57680.0
2018-10-23 05:00:00	SPY	ETF	271.65	271.65	270.85	271.01	91679.0
2018-10-23 05:30:00	SPY	ETF	270.91	271.63	270.8	271.63	87634.0
2018-10-23 06:00:00	SPY	ETF	271.64	271.74	271.35	271.59	64166.0
2018-10-23 06:30:00	SPY	ETF	271.59	272.04	271.23	271.76	111944.0
2018-10-23 07:00:00	SPY	ETF	271.71	271.94	271.41	271.53	337580.0
2018-10-23 07:30:00	SPY	ETF	271.5	271.56	270.5	271.32	881674.0
2018-10-23 08:00:00	SPY	ETF	271.7701	272.9	270.75	270.89	943182.0
2018-10-23 08:30:00	SPY	ETF	270.8901	271.66	270.82	271.22	644654.0
2018-10-23 09:00:00	SPY	ETF	271.23	271.23	270.3	270.96	1875177.0
2018-10-23 09:30:00	SPY	ETF	270.95	271.72	270.04	270.66	16088846.0
2018-10-23 10:00:00	SPY	ETF	270.6515	271.6163	268.61	269.48	15730022.0
2018-10-23 10:30:00	SPY	ETF	269.48	270.48	268.78	269.95	10710715.0
2018-10-23 11:00:00	SPY	ETF	269.95	271.11	269.48	270.785	8796060.0
2018-10-23 11:30:00	SPY	ETF	270.78	270.94	269.56	269.5836	5504414.0
2018-10-23 12:00:00	SPY	ETF	269.58	271.3275	269.55	271.18	6316526.0
2018-10-23 12:30:00	SPY	ETF	271.2	271.855	271.15	271.31	5724284.0
2018-10-23 13:00:00	SPY	ETF	271.31	273.015	271.22	272.47	8138055.0
2018-10-23 13:30:00	SPY	ETF	272.47	272.88	271.51	271.66	6313569.0
2018-10-23 14:00:00	SPY	ETF	271.66	273.77	271.66	273.4	7300846.0
2018-10-23 14:30:00	SPY	ETF	273.4	274.58	273.38	274.32	8743344.0
2018-10-23 15:00:00	SPY	ETF	274.315	274.87	274.02	274.3	9765737.0
2018-10-23 15:30:00	SPY	ETF	274.29	274.64	273.27	273.54	15310930.0
2018-10-23 16:00:00	SPY	ETF	273.49	274.13	271.74	274.08	13156011.0
2018-10-23 16:30:00	SPY	ETF	274.08	274.08	273.61	274.0	768772.0
2018-10-23 17:00:00	SPY	ETF	273.93	273.96	273.8	273.82	342228.0
2018-10-23 17:30:00	SPY	ETF	273.87	273.88	273.61	273.85	58718.0
2018-10-23 18:00:00	SPY	ETF	273.87	274.07	273.61	273.82	262852.0
2018-10-23 18:30:00	SPY	ETF	273.81	273.88	273.55	273.6	126698.0
2018-10-23 19:00:00	SPY	ETF	273.63	273.95	273.61	273.94	78845.0
2018-10-23 19:30:00	SPY	ETF	273.95	274.11	273.85	273.99	25341.0
2018-10-23 04:00:00	QQQ	ETF	171.69	171.69	171.25	171.4	74494.0
2018-10-23 04:30:00	QQQ	ETF	171.34	171.61	171.25	171.35	37015.0
2018-10-23 05:00:00	QQQ	ETF	171.3	171.3	170.79	170.89	33451.0
2018-10-23 05:30:00	QQQ	ETF	170.8	171.49	170.77	171.49	35310.0
2018-10-23 06:00:00	QQQ	ETF	171.42	171.47	171.24	171.27	26622.0
2018-10-23 06:30:00	QQQ	ETF	171.31	171.63	171.03	171.5	68634.0
2018-10-23 07:00:00	QQQ	ETF	171.47	171.57	171.07	171.17	104710.0
2018-10-23 07:30:00	QQQ	ETF	171.1	171.27	170.56	171.02	345416.0
2018-10-23 08:00:00	QQQ	ETF	171.07	172.53	170.5301	170.83	290045.0
2018-10-23 08:30:00	QQQ	ETF	170.81	171.15	170.76	171.12	375280.0
2018-10-23 09:00:00	QQQ	ETF	171.03	171.04	170.4	170.72	756628.0
2018-10-23 09:30:00	QQQ	ETF	170.8	171.4	170.18	170.47	10816027.0
2018-10-23 10:00:00	QQQ	ETF	170.47	170.58	168.82	169.76	9680247.0
2018-10-23 10:30:00	QQQ	ETF	169.77	170.35	169.2916	169.95	4770535.0
2018-10-23 11:00:00	QQQ	ETF	169.94	171.0	169.49	170.75	5196618.0
2018-10-23 11:30:00	QQQ	ETF	170.76	170.83	169.96	169.98	3393392.0
2018-10-23 12:00:00	QQQ	ETF	169.98	171.57	169.97	171.47	4400839.0
2018-10-23 12:30:00	QQQ	ETF	171.48	172.26	171.46	171.525	4397934.0

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

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