PREVIEW / etf_30min / 2018-06-18

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-18.parquet
  size:    466 KB
  rows:    16,118

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-06-18 04:00:00	SPY	ETF	276.8	276.8	275.87	275.93	20173.0
2018-06-18 04:30:00	SPY	ETF	275.9	276.21	275.9	276.04	14747.0
2018-06-18 05:00:00	SPY	ETF	276.09	276.13	276.02	276.04	7300.0
2018-06-18 05:30:00	SPY	ETF	276.03	276.09	275.86	276.06	28712.0
2018-06-18 06:00:00	SPY	ETF	276.06	276.09	275.72	275.8	33328.0
2018-06-18 06:30:00	SPY	ETF	275.68	275.75	275.5	275.59	140757.0
2018-06-18 07:00:00	SPY	ETF	275.6	275.63	275.48	275.63	90453.0
2018-06-18 07:30:00	SPY	ETF	275.65	275.68	275.3	275.34	319066.0
2018-06-18 08:00:00	SPY	ETF	275.34	276.1	275.25	275.5	265693.0
2018-06-18 08:30:00	SPY	ETF	275.5	275.66	275.4	275.66	146780.0
2018-06-18 09:00:00	SPY	ETF	275.66	275.66	275.37	275.48	334964.0
2018-06-18 09:30:00	SPY	ETF	275.49	275.72	274.95	275.52	6574916.0
2018-06-18 10:00:00	SPY	ETF	275.51	275.78	275.31	275.555	4586273.0
2018-06-18 10:30:00	SPY	ETF	275.56	276.36	275.555	276.1509	5039856.0
2018-06-18 11:00:00	SPY	ETF	276.15	276.59	276.15	276.32	2899735.0
2018-06-18 11:30:00	SPY	ETF	276.32	276.4099	276.0	276.06	2704544.0
2018-06-18 12:00:00	SPY	ETF	276.06	276.29	275.86	275.93	3523307.0
2018-06-18 12:30:00	SPY	ETF	275.925	276.2	275.9	276.18	1609470.0
2018-06-18 13:00:00	SPY	ETF	276.19	276.49	276.15	276.39	2307274.0
2018-06-18 13:30:00	SPY	ETF	276.395	276.48	276.25	276.37	1262926.0
2018-06-18 14:00:00	SPY	ETF	276.3775	276.59	276.2	276.49	1854148.0
2018-06-18 14:30:00	SPY	ETF	276.51	276.61	276.14	276.21	3827599.0
2018-06-18 15:00:00	SPY	ETF	276.21	276.47	276.15	276.33	2045058.0
2018-06-18 15:30:00	SPY	ETF	276.32	276.7	276.23	276.57	6945911.0
2018-06-18 16:00:00	SPY	ETF	276.57	276.79	276.48	276.72	4450455.0
2018-06-18 16:30:00	SPY	ETF	276.7	276.75	276.56	276.64	421134.0
2018-06-18 17:00:00	SPY	ETF	276.5941	276.72	276.5941	276.7	31758.0
2018-06-18 17:30:00	SPY	ETF	276.7	276.71	276.67	276.71	32847.0
2018-06-18 18:00:00	SPY	ETF	276.69	276.79	276.67	276.79	41469.0
2018-06-18 18:30:00	SPY	ETF	276.79	276.82	276.64	276.64	21365.0
2018-06-18 19:00:00	SPY	ETF	276.65	276.68	276.65	276.68	1150.0
2018-06-18 19:30:00	SPY	ETF	276.65	276.65	275.02	275.36	273601.0
2018-06-18 04:00:00	QQQ	ETF	175.99	175.99	175.63	175.65	9870.0
2018-06-18 04:30:00	QQQ	ETF	175.65	175.85	175.64	175.76	6350.0
2018-06-18 05:00:00	QQQ	ETF	175.8	175.8	175.73	175.75	4456.0
2018-06-18 05:30:00	QQQ	ETF	175.69	175.81	175.57	175.81	29827.0
2018-06-18 06:00:00	QQQ	ETF	175.76	175.78	175.5	175.57	17571.0
2018-06-18 06:30:00	QQQ	ETF	175.59	175.59	175.33	175.39	14772.0
2018-06-18 07:00:00	QQQ	ETF	175.4	175.48	175.37	175.48	141359.0
2018-06-18 07:30:00	QQQ	ETF	175.49	175.51	175.25	175.25	114151.0
2018-06-18 08:00:00	QQQ	ETF	175.24	175.46	175.2	175.39	76098.0
2018-06-18 08:30:00	QQQ	ETF	175.39	175.52	175.37	175.51	109738.0
2018-06-18 09:00:00	QQQ	ETF	175.54	175.54	175.39	175.51	224109.0
2018-06-18 09:30:00	QQQ	ETF	175.53	175.79	174.94	175.54	4434200.0
2018-06-18 10:00:00	QQQ	ETF	175.54	175.88	175.36	175.62	1942767.0
2018-06-18 10:30:00	QQQ	ETF	175.63	176.46	175.63	176.3216	1531981.0
2018-06-18 11:00:00	QQQ	ETF	176.33	176.65	176.32	176.4	1610792.0
2018-06-18 11:30:00	QQQ	ETF	176.42	176.48	176.22	176.26	850690.0
2018-06-18 12:00:00	QQQ	ETF	176.26	176.4	176.1	176.16	579611.0
2018-06-18 12:30:00	QQQ	ETF	176.16	176.24	176.045	176.205	427225.0

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

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