PREVIEW / etf_30min / 2015-09-09

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-09.parquet
  size:    391 KB
  rows:    13,044

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
2015-09-09 04:00:00	SPY	ETF	199.5	199.7	199.33	199.52	40353.0
2015-09-09 04:30:00	SPY	ETF	199.42	199.45	199.14	199.28	28606.0
2015-09-09 05:00:00	SPY	ETF	199.31	199.57	199.3	199.3	26395.0
2015-09-09 05:30:00	SPY	ETF	199.42	199.54	199.21	199.35	27135.0
2015-09-09 06:00:00	SPY	ETF	199.31	199.42	199.21	199.22	27237.0
2015-09-09 06:30:00	SPY	ETF	199.22	199.22	198.96	199.07	60590.0
2015-09-09 07:00:00	SPY	ETF	199.11	199.39	199.11	199.24	219612.0
2015-09-09 07:30:00	SPY	ETF	199.24	199.48	199.16	199.32	405934.0
2015-09-09 08:00:00	SPY	ETF	199.33	199.46	198.1	199.11	578251.0
2015-09-09 08:30:00	SPY	ETF	199.11	199.48	199.1	199.48	531987.0
2015-09-09 09:00:00	SPY	ETF	199.48	199.57	197.43	199.35	683261.0
2015-09-09 09:30:00	SPY	ETF	199.32	199.47	198.62	198.77	13185873.0
2015-09-09 10:00:00	SPY	ETF	198.78	198.92	197.98	198.265	10370397.0
2015-09-09 10:30:00	SPY	ETF	198.26	198.41	197.5	197.6769	8689090.0
2015-09-09 11:00:00	SPY	ETF	197.67	198.1	197.53	197.61	7655456.0
2015-09-09 11:30:00	SPY	ETF	197.61	197.92	197.31	197.64	4508053.0
2015-09-09 12:00:00	SPY	ETF	197.65	198.08	197.49	198.03	4611386.0
2015-09-09 12:30:00	SPY	ETF	198.04	198.15	197.59	197.72	3993142.0
2015-09-09 13:00:00	SPY	ETF	197.72	198.03	197.29	197.37	4220334.0
2015-09-09 13:30:00	SPY	ETF	197.36	197.36	196.32	196.38	10966628.0
2015-09-09 14:00:00	SPY	ETF	196.41	198.0	196.1	196.355	10358576.0
2015-09-09 14:30:00	SPY	ETF	196.34	196.44	195.76	196.165	10205249.0
2015-09-09 15:00:00	SPY	ETF	196.16	196.7	195.75	195.92	12111317.0
2015-09-09 15:30:00	SPY	ETF	195.92	196.5685	194.35	194.79	30502301.0
2015-09-09 16:00:00	SPY	ETF	194.78	198.057	194.66	195.08	8498999.0
2015-09-09 16:30:00	SPY	ETF	195.06	199.33	194.79	195.03	2659641.0
2015-09-09 17:00:00	SPY	ETF	195.03	195.17	195.02	195.05	1161750.0
2015-09-09 17:30:00	SPY	ETF	195.06	197.5175	195.05	195.11	1037418.0
2015-09-09 18:00:00	SPY	ETF	195.12	195.12	194.24	194.38	380488.0
2015-09-09 18:30:00	SPY	ETF	194.36	194.48	194.1	194.36	143657.0
2015-09-09 19:00:00	SPY	ETF	194.36	194.64	194.22	194.34	69489.0
2015-09-09 19:30:00	SPY	ETF	194.39	194.69	194.3	194.49	69210.0
2015-09-09 04:00:00	QQQ	ETF	106.42	106.48	106.4	106.4	16212.0
2015-09-09 04:30:00	QQQ	ETF	106.39	106.39	106.32	106.32	2700.0
2015-09-09 05:00:00	QQQ	ETF	106.34	106.44	106.31	106.31	13571.0
2015-09-09 05:30:00	QQQ	ETF	106.3	106.41	106.28	106.28	4900.0
2015-09-09 06:00:00	QQQ	ETF	106.27	106.3	106.21	106.21	5560.0
2015-09-09 06:30:00	QQQ	ETF	106.2	106.2	106.1	106.1	5300.0
2015-09-09 07:00:00	QQQ	ETF	106.2	106.29	106.19	106.19	70255.0
2015-09-09 07:30:00	QQQ	ETF	106.17	106.34	106.17	106.26	32105.0
2015-09-09 08:00:00	QQQ	ETF	106.27	106.3	106.13	106.16	104477.0
2015-09-09 08:30:00	QQQ	ETF	106.18	106.38	106.18	106.36	200684.0
2015-09-09 09:00:00	QQQ	ETF	106.32	106.4	106.21	106.28	635765.0
2015-09-09 09:30:00	QQQ	ETF	106.28	106.31	105.7	105.839	5660311.0
2015-09-09 10:00:00	QQQ	ETF	105.84	105.93	105.48	105.67	2378522.0
2015-09-09 10:30:00	QQQ	ETF	105.67	105.78	105.13	105.25	2496302.0
2015-09-09 11:00:00	QQQ	ETF	105.25	105.53	105.18	105.22	1493214.0
2015-09-09 11:30:00	QQQ	ETF	105.22	105.4324	105.07	105.32	1333779.0
2015-09-09 12:00:00	QQQ	ETF	105.32	105.66	105.24	105.66	1135998.0
2015-09-09 12:30:00	QQQ	ETF	105.67	105.72	105.42	105.49	846321.0

> showing 50 of 13,044 rows — these rows as CSV

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