PREVIEW / etf_30min / 2018-03-14

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-14.parquet
  size:    457 KB
  rows:    15,683

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-03-14 04:00:00	SPY	ETF	277.58	278.0	277.39	277.73	37545.0
2018-03-14 04:30:00	SPY	ETF	277.76	278.0	277.6	277.72	20330.0
2018-03-14 05:00:00	SPY	ETF	277.93	278.0	277.83	277.92	12186.0
2018-03-14 05:30:00	SPY	ETF	277.93	277.95	277.72	277.93	15750.0
2018-03-14 06:00:00	SPY	ETF	277.92	278.1	277.67	277.79	28017.0
2018-03-14 06:30:00	SPY	ETF	277.84	277.92	277.64	277.64	39740.0
2018-03-14 07:00:00	SPY	ETF	277.67	277.94	277.67	277.77	63348.0
2018-03-14 07:30:00	SPY	ETF	277.78	277.89	277.71	277.85	71368.0
2018-03-14 08:00:00	SPY	ETF	277.86	277.92	276.65	277.68	104224.0
2018-03-14 08:30:00	SPY	ETF	277.61	277.98	277.48	277.68	363637.0
2018-03-14 09:00:00	SPY	ETF	277.7	277.88	277.54	277.8	266544.0
2018-03-14 09:30:00	SPY	ETF	277.81	278.02	276.94	277.29	7279936.0
2018-03-14 10:00:00	SPY	ETF	277.29	277.61	276.41	276.86	5259768.0
2018-03-14 10:30:00	SPY	ETF	276.85	277.09	276.55	276.8	4075501.0
2018-03-14 11:00:00	SPY	ETF	276.8	276.92	275.98	276.43	3923586.0
2018-03-14 11:30:00	SPY	ETF	276.43	276.5785	275.03	275.32	8388469.0
2018-03-14 12:00:00	SPY	ETF	275.33	275.64	274.84	275.4	6153189.0
2018-03-14 12:30:00	SPY	ETF	275.42	276.0	275.28	275.52	5672659.0
2018-03-14 13:00:00	SPY	ETF	275.51	275.51	274.87	275.23	5398129.0
2018-03-14 13:30:00	SPY	ETF	275.2299	276.58	275.22	276.225	5542152.0
2018-03-14 14:00:00	SPY	ETF	276.23	276.38	275.67	275.82	3524625.0
2018-03-14 14:30:00	SPY	ETF	275.8299	276.1	274.73	275.53	6951812.0
2018-03-14 15:00:00	SPY	ETF	275.53	275.6	274.7599	274.93	9735045.0
2018-03-14 15:30:00	SPY	ETF	274.93	275.33	274.67	275.27	16582298.0
2018-03-14 16:00:00	SPY	ETF	275.26	275.7639	275.05	275.28	12873086.0
2018-03-14 16:30:00	SPY	ETF	275.27	275.44	275.25	275.35	342042.0
2018-03-14 17:00:00	SPY	ETF	275.39	275.44	275.2193	275.36	61874.0
2018-03-14 17:30:00	SPY	ETF	275.37	275.37	275.2117	275.31	1525245.0
2018-03-14 18:00:00	SPY	ETF	275.33	275.5	275.27	275.49	46856.0
2018-03-14 18:30:00	SPY	ETF	275.5	275.62	275.5	275.62	33548.0
2018-03-14 19:00:00	SPY	ETF	275.6	275.62	275.5	275.6	8095.0
2018-03-14 19:30:00	SPY	ETF	275.6	275.6	275.13	275.42	44308.0
2018-03-14 04:00:00	QQQ	ETF	172.37	172.73	172.2	172.66	14235.0
2018-03-14 04:30:00	QQQ	ETF	172.69	172.84	172.65	172.73	9225.0
2018-03-14 05:00:00	QQQ	ETF	172.88	172.91	172.79	172.81	7200.0
2018-03-14 05:30:00	QQQ	ETF	172.79	172.8	172.71	172.78	13350.0
2018-03-14 06:00:00	QQQ	ETF	172.95	173.0	172.76	172.76	3200.0
2018-03-14 06:30:00	QQQ	ETF	172.82	172.86	172.75	172.75	16680.0
2018-03-14 07:00:00	QQQ	ETF	172.77	172.92	172.73	172.79	39908.0
2018-03-14 07:30:00	QQQ	ETF	172.76	172.82	172.71	172.75	30818.0
2018-03-14 08:00:00	QQQ	ETF	172.76	172.81	171.3	172.52	89028.0
2018-03-14 08:30:00	QQQ	ETF	172.52	172.87	172.5	172.65	145873.0
2018-03-14 09:00:00	QQQ	ETF	172.66	172.76	172.43	172.59	129228.0
2018-03-14 09:30:00	QQQ	ETF	172.58	172.74	171.87	172.12	2956932.0
2018-03-14 10:00:00	QQQ	ETF	172.13	172.64	171.71	172.15	2936770.0
2018-03-14 10:30:00	QQQ	ETF	172.14	172.49	171.91	172.3	1535023.0
2018-03-14 11:00:00	QQQ	ETF	172.3	172.3999	171.42	171.7749	1842381.0
2018-03-14 11:30:00	QQQ	ETF	171.795	171.93	170.96	171.25	2775249.0
2018-03-14 12:00:00	QQQ	ETF	171.26	171.6	170.93	171.53	1686845.0
2018-03-14 12:30:00	QQQ	ETF	171.56	172.08	171.48	171.84	1983854.0

> showing 50 of 15,683 rows — these rows as CSV

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