PREVIEW / etf_30min / 2018-12-13

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-13.parquet
  size:    489 KB
  rows:    17,032

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-12-13 04:00:00	SPY	ETF	266.28	266.37	265.73	265.86	19068.0
2018-12-13 04:30:00	SPY	ETF	265.8	266.18	265.8	265.92	5680.0
2018-12-13 05:00:00	SPY	ETF	265.88	266.19	265.87	265.9	16776.0
2018-12-13 05:30:00	SPY	ETF	265.99	266.24	265.82	265.83	32280.0
2018-12-13 06:00:00	SPY	ETF	265.9	266.17	265.72	265.96	19831.0
2018-12-13 06:30:00	SPY	ETF	265.91	265.94	265.13	265.29	80134.0
2018-12-13 07:00:00	SPY	ETF	265.38	265.9	265.24	265.9	159330.0
2018-12-13 07:30:00	SPY	ETF	265.88	266.0	265.73	265.75	108722.0
2018-12-13 08:00:00	SPY	ETF	265.82	267.09	265.27	266.39	277474.0
2018-12-13 08:30:00	SPY	ETF	266.39	266.45	265.92	266.39	316045.0
2018-12-13 09:00:00	SPY	ETF	266.39	266.65	266.31	266.48	265736.0
2018-12-13 09:30:00	SPY	ETF	266.52	267.28	265.67	265.76	8762244.0
2018-12-13 10:00:00	SPY	ETF	265.76	267.49	265.74	266.34	6718248.0
2018-12-13 10:30:00	SPY	ETF	266.34	266.68	264.99	265.81	7675162.0
2018-12-13 11:00:00	SPY	ETF	265.8	266.09	265.0	265.59	5044527.0
2018-12-13 11:30:00	SPY	ETF	265.6025	266.51	265.28	265.28	5812408.0
2018-12-13 12:00:00	SPY	ETF	265.27	265.41	264.55	264.74	5656698.0
2018-12-13 12:30:00	SPY	ETF	264.74	265.58	264.68	265.0788	5744451.0
2018-12-13 13:00:00	SPY	ETF	265.07	265.14	264.28	264.79	4110357.0
2018-12-13 13:30:00	SPY	ETF	264.81	265.91	264.72	264.92	5528757.0
2018-12-13 14:00:00	SPY	ETF	264.92	265.04	264.13	264.69	5525110.0
2018-12-13 14:30:00	SPY	ETF	264.66	265.23	264.12	264.97	4670588.0
2018-12-13 15:00:00	SPY	ETF	264.99	265.49	264.54	265.06	6630546.0
2018-12-13 15:30:00	SPY	ETF	265.04	266.04	264.79	265.37	13224294.0
2018-12-13 16:00:00	SPY	ETF	265.39	265.5372	264.7	264.81	7842156.0
2018-12-13 16:30:00	SPY	ETF	264.81	265.15	264.78	264.97	359673.0
2018-12-13 17:00:00	SPY	ETF	264.94	265.488	264.9	265.1	360224.0
2018-12-13 17:30:00	SPY	ETF	265.08	265.37	265.04	265.04	277290.0
2018-12-13 18:00:00	SPY	ETF	265.02	265.03	264.71	264.8	77616.0
2018-12-13 18:30:00	SPY	ETF	264.85	265.19	264.74	265.0	27247.0
2018-12-13 19:00:00	SPY	ETF	265.0	265.29	264.95	265.18	37708.0
2018-12-13 19:30:00	SPY	ETF	265.19	265.19	264.29	264.34	76747.0
2018-12-13 04:00:00	QQQ	ETF	165.98	165.98	165.48	165.48	3287.0
2018-12-13 04:30:00	QQQ	ETF	165.8	165.85	165.55	165.55	1500.0
2018-12-13 05:00:00	QQQ	ETF	165.76	165.85	165.62	165.64	7200.0
2018-12-13 05:30:00	QQQ	ETF	165.75	165.9	165.58	165.58	13500.0
2018-12-13 06:00:00	QQQ	ETF	165.49	165.75	165.44	165.67	5050.0
2018-12-13 06:30:00	QQQ	ETF	165.54	165.54	165.08	165.21	12732.0
2018-12-13 07:00:00	QQQ	ETF	165.35	165.56	165.08	165.56	25543.0
2018-12-13 07:30:00	QQQ	ETF	165.59	165.71	165.5	165.5	25917.0
2018-12-13 08:00:00	QQQ	ETF	165.05	166.78	165.05	166.04	133475.0
2018-12-13 08:30:00	QQQ	ETF	166.1	166.1501	165.72	166.14	124623.0
2018-12-13 09:00:00	QQQ	ETF	166.09	166.26	165.97	166.04	145935.0
2018-12-13 09:30:00	QQQ	ETF	166.06	166.69	165.38	165.5764	3957083.0
2018-12-13 10:00:00	QQQ	ETF	165.57	166.82	165.55	165.95	3354727.0
2018-12-13 10:30:00	QQQ	ETF	165.95	165.995	164.55	165.26	3934187.0
2018-12-13 11:00:00	QQQ	ETF	165.25	165.44	164.61	165.18	2960460.0
2018-12-13 11:30:00	QQQ	ETF	165.18	165.79	164.75	164.76	2960897.0
2018-12-13 12:00:00	QQQ	ETF	164.755	164.87	164.14	164.31	2373326.0
2018-12-13 12:30:00	QQQ	ETF	164.31	164.96	164.27	164.64	2138876.0

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

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