PREVIEW / etf_30min / 2018-10-31

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-31.parquet
  size:    502 KB
  rows:    17,247

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-31 04:00:00	SPY	ETF	269.1	269.75	269.0	269.69	26986.0
2018-10-31 04:30:00	SPY	ETF	269.7	269.94	269.59	269.86	27075.0
2018-10-31 05:00:00	SPY	ETF	269.89	269.89	269.47	269.61	41529.0
2018-10-31 05:30:00	SPY	ETF	269.63	269.65	269.12	269.25	86175.0
2018-10-31 06:00:00	SPY	ETF	269.25	269.58	269.25	269.49	78921.0
2018-10-31 06:30:00	SPY	ETF	269.55	269.96	269.5	269.8	47474.0
2018-10-31 07:00:00	SPY	ETF	269.76	270.16	269.71	269.84	131372.0
2018-10-31 07:30:00	SPY	ETF	269.84	270.26	269.79	270.11	219819.0
2018-10-31 08:00:00	SPY	ETF	269.89	270.89	268.38	270.57	462416.0
2018-10-31 08:30:00	SPY	ETF	270.56	270.91	270.47	270.79	482288.0
2018-10-31 09:00:00	SPY	ETF	270.81	271.06	270.45	270.74	630377.0
2018-10-31 09:30:00	SPY	ETF	270.65	271.65	270.12	271.51	11533097.0
2018-10-31 10:00:00	SPY	ETF	271.51	272.24	271.06	271.98	6838635.0
2018-10-31 10:30:00	SPY	ETF	271.99	272.45	271.41	271.46	7024465.0
2018-10-31 11:00:00	SPY	ETF	271.48	272.0	270.92	271.82	6130251.0
2018-10-31 11:30:00	SPY	ETF	271.81	271.92	270.8	271.23	5537293.0
2018-10-31 12:00:00	SPY	ETF	271.25	271.44	270.365	271.12	4482799.0
2018-10-31 12:30:00	SPY	ETF	271.13	272.24	270.95	272.01	4964046.0
2018-10-31 13:00:00	SPY	ETF	272.02	272.72	271.89	272.23	4883541.0
2018-10-31 13:30:00	SPY	ETF	272.24	272.77	271.81	272.42	3723076.0
2018-10-31 14:00:00	SPY	ETF	272.42	273.2	272.09	272.91	7256780.0
2018-10-31 14:30:00	SPY	ETF	272.91	273.1	272.39	272.865	4912943.0
2018-10-31 15:00:00	SPY	ETF	272.86	273.23	271.99	272.42	12627226.0
2018-10-31 15:30:00	SPY	ETF	272.42	272.5	270.54	270.69	26749444.0
2018-10-31 16:00:00	SPY	ETF	270.69	271.05	270.0	270.15	14243932.0
2018-10-31 16:30:00	SPY	ETF	270.15	270.47	270.0	270.14	588307.0
2018-10-31 17:00:00	SPY	ETF	270.13	270.7244	270.08	270.215	137454.0
2018-10-31 17:30:00	SPY	ETF	270.21	270.22	270.11	270.19	78292.0
2018-10-31 18:00:00	SPY	ETF	270.19	270.75	270.15	270.56	495707.0
2018-10-31 18:30:00	SPY	ETF	270.58	270.65	270.41	270.57	18057.0
2018-10-31 19:00:00	SPY	ETF	270.61	270.63	270.49	270.51	13664.0
2018-10-31 19:30:00	SPY	ETF	270.46	270.88	270.45	270.77	84697.0
2018-10-31 04:00:00	QQQ	ETF	167.29	167.51	167.22	167.46	5971.0
2018-10-31 04:30:00	QQQ	ETF	167.46	167.74	167.36	167.74	11402.0
2018-10-31 05:00:00	QQQ	ETF	167.75	167.75	167.41	167.47	16323.0
2018-10-31 05:30:00	QQQ	ETF	167.48	167.51	167.14	167.18	12021.0
2018-10-31 06:00:00	QQQ	ETF	167.24	167.4	167.08	167.19	17018.0
2018-10-31 06:30:00	QQQ	ETF	167.25	167.75	167.19	167.53	30057.0
2018-10-31 07:00:00	QQQ	ETF	167.51	167.9	167.41	167.48	84120.0
2018-10-31 07:30:00	QQQ	ETF	167.48	167.91	167.41	167.8	173545.0
2018-10-31 08:00:00	QQQ	ETF	167.78	168.6	166.34	168.28	718934.0
2018-10-31 08:30:00	QQQ	ETF	168.27	168.48	168.1	168.38	423416.0
2018-10-31 09:00:00	QQQ	ETF	168.37	168.69	168.28	168.53	544408.0
2018-10-31 09:30:00	QQQ	ETF	168.54	169.95	168.54	169.87	9626313.0
2018-10-31 10:00:00	QQQ	ETF	169.88	170.81	169.7	170.45	7073326.0
2018-10-31 10:30:00	QQQ	ETF	170.46	170.885	169.69	169.795	5306735.0
2018-10-31 11:00:00	QQQ	ETF	169.8	170.36	169.15	170.13	3940640.0
2018-10-31 11:30:00	QQQ	ETF	170.12	170.21	168.88	169.37	3003511.0
2018-10-31 12:00:00	QQQ	ETF	169.36	169.91	168.65	169.57	2724470.0
2018-10-31 12:30:00	QQQ	ETF	169.59	170.44	169.46	170.23	2702058.0

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

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