PREVIEW / etf_30min / 2018-02-08

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-08.parquet
  size:    515 KB
  rows:    17,829

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-02-08 04:00:00	SPY	ETF	266.89	267.5	266.72	267.17	31933.0
2018-02-08 04:30:00	SPY	ETF	267.39	267.41	266.86	267.08	53151.0
2018-02-08 05:00:00	SPY	ETF	266.92	266.92	266.02	266.66	68258.0
2018-02-08 05:30:00	SPY	ETF	266.7	266.77	266.02	266.02	43831.0
2018-02-08 06:00:00	SPY	ETF	266.0	266.38	265.69	266.29	32920.0
2018-02-08 06:30:00	SPY	ETF	266.34	266.39	265.55	265.92	81553.0
2018-02-08 07:00:00	SPY	ETF	265.85	266.88	265.85	266.75	576624.0
2018-02-08 07:30:00	SPY	ETF	266.66	267.25	266.55	267.04	376325.0
2018-02-08 08:00:00	SPY	ETF	267.04	268.1	265.89	267.89	516463.0
2018-02-08 08:30:00	SPY	ETF	268.02	268.27	267.66	268.09	466308.0
2018-02-08 09:00:00	SPY	ETF	268.07	268.45	267.84	267.97	569785.0
2018-02-08 09:30:00	SPY	ETF	268.01	268.17	266.1	266.95	14502661.0
2018-02-08 10:00:00	SPY	ETF	266.9401	267.54	265.91	266.08	11631966.0
2018-02-08 10:30:00	SPY	ETF	266.06	266.55	264.31	264.91	11632694.0
2018-02-08 11:00:00	SPY	ETF	264.95	265.77	263.68	264.01	12542229.0
2018-02-08 11:30:00	SPY	ETF	263.98	265.67	263.68	264.61	11013223.0
2018-02-08 12:00:00	SPY	ETF	264.59	265.02	262.57	263.15	11893115.0
2018-02-08 12:30:00	SPY	ETF	263.1703	264.18	261.16	262.21	13242179.0
2018-02-08 13:00:00	SPY	ETF	262.22	263.7	261.53	262.31	17551523.0
2018-02-08 13:30:00	SPY	ETF	262.26	264.73	262.1	264.1717	13014316.0
2018-02-08 14:00:00	SPY	ETF	264.15	264.5	262.81	263.08	10495861.0
2018-02-08 14:30:00	SPY	ETF	263.05	263.18	261.62	262.2099	10327647.0
2018-02-08 15:00:00	SPY	ETF	262.21	263.1	261.09	261.87	16453688.0
2018-02-08 15:30:00	SPY	ETF	261.86	262.29	257.59	257.72	51394596.0
2018-02-08 16:00:00	SPY	ETF	257.72	259.64	257.63	259.3	25752497.0
2018-02-08 16:30:00	SPY	ETF	257.7283	265.8182	257.7283	259.55	4161207.0
2018-02-08 17:00:00	SPY	ETF	259.43	259.55	257.63	259.33	2284885.0
2018-02-08 17:30:00	SPY	ETF	259.33	259.47	257.63	259.29	425585.0
2018-02-08 18:00:00	SPY	ETF	259.3	259.75	257.63	259.0	939186.0
2018-02-08 18:30:00	SPY	ETF	259.0	259.05	258.31	258.5	67903.0
2018-02-08 19:00:00	SPY	ETF	258.73	260.34	258.62	259.8	133846.0
2018-02-08 19:30:00	SPY	ETF	259.85	259.95	259.32	259.72	89570.0
2018-02-08 04:00:00	QQQ	ETF	160.11	160.46	160.11	160.44	14223.0
2018-02-08 04:30:00	QQQ	ETF	160.26	160.38	160.18	160.18	7520.0
2018-02-08 05:00:00	QQQ	ETF	160.09	160.09	159.68	160.0	31416.0
2018-02-08 05:30:00	QQQ	ETF	159.96	160.0	159.57	159.63	22650.0
2018-02-08 06:00:00	QQQ	ETF	159.56	159.82	159.53	159.8	9588.0
2018-02-08 06:30:00	QQQ	ETF	159.77	159.77	159.33	159.43	13773.0
2018-02-08 07:00:00	QQQ	ETF	159.49	160.18	159.49	160.05	53395.0
2018-02-08 07:30:00	QQQ	ETF	159.97	160.45	159.94	160.29	93760.0
2018-02-08 08:00:00	QQQ	ETF	160.11	160.98	159.69	160.98	154129.0
2018-02-08 08:30:00	QQQ	ETF	161.0	161.17	160.64	160.74	331398.0
2018-02-08 09:00:00	QQQ	ETF	160.83	161.06	160.55	160.69	237207.0
2018-02-08 09:30:00	QQQ	ETF	160.69	160.8	159.4	159.93	6030479.0
2018-02-08 10:00:00	QQQ	ETF	159.9067	160.36	159.29	159.44	4346117.0
2018-02-08 10:30:00	QQQ	ETF	159.44	159.6	157.62	158.19	8390976.0
2018-02-08 11:00:00	QQQ	ETF	158.21	158.84	157.26	157.505	4978820.0
2018-02-08 11:30:00	QQQ	ETF	157.49	158.65	157.29	158.2	4475086.0
2018-02-08 12:00:00	QQQ	ETF	158.19	158.53	156.7299	157.18	3973785.0
2018-02-08 12:30:00	QQQ	ETF	157.2	157.68	155.58	156.32	6233587.0

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

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