PREVIEW / etf_30min / 2017-11-16

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-16.parquet
  size:    448 KB
  rows:    15,471

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
2017-11-16 04:00:00	SPY	ETF	257.15	257.56	257.1	257.44	8337.0
2017-11-16 04:30:00	SPY	ETF	257.44	257.57	257.4	257.45	36532.0
2017-11-16 05:00:00	SPY	ETF	257.48	257.62	257.48	257.61	2978.0
2017-11-16 05:30:00	SPY	ETF	257.51	257.53	257.41	257.48	14932.0
2017-11-16 06:00:00	SPY	ETF	257.46	257.5	257.38	257.38	14151.0
2017-11-16 06:30:00	SPY	ETF	257.44	257.47	257.35	257.36	5558.0
2017-11-16 07:00:00	SPY	ETF	257.39	257.55	257.34	257.45	209803.0
2017-11-16 07:30:00	SPY	ETF	257.46	257.51	257.4	257.48	72616.0
2017-11-16 08:00:00	SPY	ETF	257.42	257.59	257.36	257.44	351573.0
2017-11-16 08:30:00	SPY	ETF	257.41	257.45	257.32	257.43	153081.0
2017-11-16 09:00:00	SPY	ETF	257.44	257.55	257.43	257.49	400889.0
2017-11-16 09:30:00	SPY	ETF	257.52	257.85	257.4748	257.645	6015472.0
2017-11-16 10:00:00	SPY	ETF	257.64	258.15	257.64	258.02	4621727.0
2017-11-16 10:30:00	SPY	ETF	258.0299	258.4758	258.02	258.35	5282392.0
2017-11-16 11:00:00	SPY	ETF	258.35	258.53	258.22	258.295	3451000.0
2017-11-16 11:30:00	SPY	ETF	258.3	258.53	258.24	258.5	2554303.0
2017-11-16 12:00:00	SPY	ETF	258.49	258.77	258.49	258.76	2454281.0
2017-11-16 12:30:00	SPY	ETF	258.76	258.825	258.65	258.74	2207374.0
2017-11-16 13:00:00	SPY	ETF	258.735	258.89	258.65	258.685	3357789.0
2017-11-16 13:30:00	SPY	ETF	258.69	258.84	258.68	258.79	2834070.0
2017-11-16 14:00:00	SPY	ETF	258.79	259.04	258.78	258.87	3759815.0
2017-11-16 14:30:00	SPY	ETF	258.86	258.99	258.73	258.76	3841539.0
2017-11-16 15:00:00	SPY	ETF	258.76	258.79	258.63	258.77	6066570.0
2017-11-16 15:30:00	SPY	ETF	258.78	258.78	258.52	258.609	12463471.0
2017-11-16 16:00:00	SPY	ETF	258.58	258.63	258.44	258.53	3177552.0
2017-11-16 16:30:00	SPY	ETF	258.55	258.62	256.4856	258.59	906841.0
2017-11-16 17:00:00	SPY	ETF	258.57	258.63	258.55	258.58	139141.0
2017-11-16 17:30:00	SPY	ETF	258.58	258.6	258.57	258.57	30212.0
2017-11-16 18:00:00	SPY	ETF	258.57	258.67	258.45	258.67	122541.0
2017-11-16 18:30:00	SPY	ETF	258.67	258.7	258.61	258.64	20788.0
2017-11-16 19:00:00	SPY	ETF	258.62	258.62	258.4	258.57	88716.0
2017-11-16 19:30:00	SPY	ETF	258.61	258.65	258.54	258.65	42108.0
2017-11-16 04:00:00	QQQ	ETF	153.0	153.23	152.93	153.2	2220.0
2017-11-16 04:30:00	QQQ	ETF	153.2	153.3	153.2	153.24	1836.0
2017-11-16 05:00:00	QQQ	ETF	153.37	153.39	153.37	153.38	6075.0
2017-11-16 05:30:00	QQQ	ETF	153.26	153.5	153.26	153.34	30660.0
2017-11-16 06:00:00	QQQ	ETF	153.26	153.3	153.2	153.2	2586.0
2017-11-16 06:30:00	QQQ	ETF	153.28	153.3	153.26	153.26	12648.0
2017-11-16 07:00:00	QQQ	ETF	153.27	153.36	153.24	153.34	25110.0
2017-11-16 07:30:00	QQQ	ETF	153.33	153.42	153.33	153.39	14410.0
2017-11-16 08:00:00	QQQ	ETF	153.38	153.44	153.32	153.36	117587.0
2017-11-16 08:30:00	QQQ	ETF	153.33	153.39	153.23	153.37	188893.0
2017-11-16 09:00:00	QQQ	ETF	153.38	153.41	153.33	153.39	248098.0
2017-11-16 09:30:00	QQQ	ETF	153.39	153.79	153.33	153.7492	2723234.0
2017-11-16 10:00:00	QQQ	ETF	153.745	154.0556	153.74	153.98	2887531.0
2017-11-16 10:30:00	QQQ	ETF	153.98	154.32	153.94	154.26	1770530.0
2017-11-16 11:00:00	QQQ	ETF	154.26	154.4	154.25	154.32	1355928.0
2017-11-16 11:30:00	QQQ	ETF	154.3275	154.49	154.31	154.425	799464.0
2017-11-16 12:00:00	QQQ	ETF	154.425	154.68	154.42	154.67	1159249.0
2017-11-16 12:30:00	QQQ	ETF	154.67	154.75	154.6	154.69	1338832.0

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

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