PREVIEW / etf_30min / 2017-03-03

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-03.parquet
  size:    431 KB
  rows:    14,681

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-03-03 04:00:00	SPY	ETF	237.88	237.88	237.77	237.79	3226.0
2017-03-03 04:30:00	SPY	ETF	237.75	237.75	237.66	237.75	11100.0
2017-03-03 05:00:00	SPY	ETF	237.76	237.85	237.76	237.83	4702.0
2017-03-03 05:30:00	SPY	ETF	237.98	238.09	237.98	238.09	20103.0
2017-03-03 06:00:00	SPY	ETF	238.07	238.26	238.07	238.25	8799.0
2017-03-03 06:30:00	SPY	ETF	238.19	238.31	238.17	238.17	53836.0
2017-03-03 07:00:00	SPY	ETF	238.16	238.25	238.15	238.21	14931.0
2017-03-03 07:30:00	SPY	ETF	238.21	238.21	237.98	238.03	67724.0
2017-03-03 08:00:00	SPY	ETF	238.02	238.23	237.85	238.1	128992.0
2017-03-03 08:30:00	SPY	ETF	238.11	238.27	238.0	238.2	254296.0
2017-03-03 09:00:00	SPY	ETF	238.2	238.28	238.14	238.17	241093.0
2017-03-03 09:30:00	SPY	ETF	238.17	238.48	238.04	238.05	6390188.0
2017-03-03 10:00:00	SPY	ETF	238.05	238.3	237.81	237.885	6115805.0
2017-03-03 10:30:00	SPY	ETF	237.9	238.09	237.73	237.89	5273772.0
2017-03-03 11:00:00	SPY	ETF	237.89	238.3972	237.77	237.89	3064838.0
2017-03-03 11:30:00	SPY	ETF	237.89	238.085	237.8483	238.065	2414982.0
2017-03-03 12:00:00	SPY	ETF	238.06	238.12	237.96	238.115	1923096.0
2017-03-03 12:30:00	SPY	ETF	238.11	238.3	238.11	238.2	3115324.0
2017-03-03 13:00:00	SPY	ETF	238.19	238.39	237.92	238.0921	5051314.0
2017-03-03 13:30:00	SPY	ETF	238.09	238.35	238.0	238.27	2841215.0
2017-03-03 14:00:00	SPY	ETF	238.27	238.43	238.14	238.15	2031539.0
2017-03-03 14:30:00	SPY	ETF	238.16	238.4	238.16	238.355	2166527.0
2017-03-03 15:00:00	SPY	ETF	238.36	238.5	238.23	238.49	3401379.0
2017-03-03 15:30:00	SPY	ETF	238.49	238.61	238.29	238.48	12415204.0
2017-03-03 16:00:00	SPY	ETF	238.47	238.5167	238.32	238.34	19171297.0
2017-03-03 16:30:00	SPY	ETF	238.35	238.42	238.25	238.36	2158504.0
2017-03-03 17:00:00	SPY	ETF	238.34	238.35	238.3	238.3	60166.0
2017-03-03 17:30:00	SPY	ETF	238.3	238.33	238.3	238.33	14062.0
2017-03-03 18:00:00	SPY	ETF	238.32	238.42	238.25	238.3	210412.0
2017-03-03 18:30:00	SPY	ETF	238.28	238.31	238.28	238.31	4202.0
2017-03-03 19:00:00	SPY	ETF	238.3	238.33	238.29	238.33	10420.0
2017-03-03 19:30:00	SPY	ETF	238.33	238.35	238.32	238.35	11119.0
2017-03-03 04:00:00	QQQ	ETF	130.5	130.5	130.46	130.47	650.0
2017-03-03 04:30:00	QQQ	ETF	130.49	130.49	130.44	130.44	900.0
2017-03-03 05:00:00	QQQ	ETF	130.5	130.5	130.5	130.5	15000.0
2017-03-03 05:30:00	QQQ	ETF	130.62	130.62	130.62	130.62	3187.0
2017-03-03 06:30:00	QQQ	ETF	130.61	130.61	130.61	130.61	449.0
2017-03-03 07:00:00	QQQ	ETF	130.61	130.64	130.61	130.64	2200.0
2017-03-03 07:30:00	QQQ	ETF	130.65	130.65	130.56	130.58	17597.0
2017-03-03 08:00:00	QQQ	ETF	130.65	130.65	130.53	130.53	24895.0
2017-03-03 08:30:00	QQQ	ETF	130.55	130.66	130.54	130.66	73206.0
2017-03-03 09:00:00	QQQ	ETF	130.64	130.69	130.64	130.65	39971.0
2017-03-03 09:30:00	QQQ	ETF	130.65	130.83	130.59	130.65	1674734.0
2017-03-03 10:00:00	QQQ	ETF	130.66	130.77	130.39	130.46	1124525.0
2017-03-03 10:30:00	QQQ	ETF	130.471	130.62	130.341	130.52	508257.0
2017-03-03 11:00:00	QQQ	ETF	130.51	130.6167	130.42	130.52	448459.0
2017-03-03 11:30:00	QQQ	ETF	130.52	130.685	130.5	130.678	257572.0
2017-03-03 12:00:00	QQQ	ETF	130.66	130.78	130.63	130.775	314989.0
2017-03-03 12:30:00	QQQ	ETF	130.771	130.85	130.75	130.8156	469882.0
2017-03-03 13:00:00	QQQ	ETF	130.81	130.95	130.63	130.78	1066229.0

> showing 50 of 14,681 rows — these rows as CSV

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