PREVIEW / etf_30min / 2018-04-09

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-09.parquet
  size:    461 KB
  rows:    15,809

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-04-09 04:00:00	SPY	ETF	261.67	262.08	261.67	262.08	22166.0
2018-04-09 04:30:00	SPY	ETF	262.03	262.27	261.9	262.09	14368.0
2018-04-09 05:00:00	SPY	ETF	262.04	262.2	261.91	262.2	8801.0
2018-04-09 05:30:00	SPY	ETF	262.27	262.33	261.85	261.85	10719.0
2018-04-09 06:00:00	SPY	ETF	261.74	262.15	261.74	261.96	65110.0
2018-04-09 06:30:00	SPY	ETF	261.83	262.1	261.59	261.61	53833.0
2018-04-09 07:00:00	SPY	ETF	261.58	261.85	261.39	261.63	160003.0
2018-04-09 07:30:00	SPY	ETF	261.63	261.82	261.43	261.7	114711.0
2018-04-09 08:00:00	SPY	ETF	261.48	262.37	259.72	261.44	758300.0
2018-04-09 08:30:00	SPY	ETF	261.3	261.52	261.22	261.23	221057.0
2018-04-09 09:00:00	SPY	ETF	261.26	261.62	261.15	261.38	313276.0
2018-04-09 09:30:00	SPY	ETF	261.37	262.45	260.87	262.09	8084757.0
2018-04-09 10:00:00	SPY	ETF	262.1	262.385	261.57	262.3069	3863049.0
2018-04-09 10:30:00	SPY	ETF	262.3	263.1	262.29	262.85	6022865.0
2018-04-09 11:00:00	SPY	ETF	262.86	263.48	262.58	263.33	5003794.0
2018-04-09 11:30:00	SPY	ETF	263.33	264.09	263.3	263.9791	5212883.0
2018-04-09 12:00:00	SPY	ETF	264.0	264.33	263.79	263.97	3215584.0
2018-04-09 12:30:00	SPY	ETF	263.98	264.24	263.62	264.1	3207929.0
2018-04-09 13:00:00	SPY	ETF	264.12	264.6	264.11	264.38	3050598.0
2018-04-09 13:30:00	SPY	ETF	264.38	264.84	264.14	264.78	4424175.0
2018-04-09 14:00:00	SPY	ETF	264.79	264.8	263.65	263.805	4314529.0
2018-04-09 14:30:00	SPY	ETF	263.79	263.98	263.2	263.86	5150272.0
2018-04-09 15:00:00	SPY	ETF	263.86	263.9	262.45	262.8	10052124.0
2018-04-09 15:30:00	SPY	ETF	262.805	262.93	260.54	260.86	22271991.0
2018-04-09 16:00:00	SPY	ETF	260.85	263.02	260.49	261.3	7292237.0
2018-04-09 16:30:00	SPY	ETF	261.31	261.55	260.8025	261.28	3804588.0
2018-04-09 17:00:00	SPY	ETF	261.26	261.26	261.0	261.0	192712.0
2018-04-09 17:30:00	SPY	ETF	261.04	261.29	261.04	261.25	40980.0
2018-04-09 18:00:00	SPY	ETF	261.27	261.33	260.72	260.95	159796.0
2018-04-09 18:30:00	SPY	ETF	260.9	261.5	260.84	260.9	95941.0
2018-04-09 19:00:00	SPY	ETF	260.89	261.3	260.75	261.3	101819.0
2018-04-09 19:30:00	SPY	ETF	261.15	261.21	260.98	261.12	113539.0
2018-04-09 04:00:00	QQQ	ETF	158.1	158.47	158.1	158.43	27217.0
2018-04-09 04:30:00	QQQ	ETF	158.34	158.61	158.29	158.44	14463.0
2018-04-09 05:00:00	QQQ	ETF	158.5	158.68	158.38	158.58	3250.0
2018-04-09 05:30:00	QQQ	ETF	158.57	158.69	158.41	158.43	9562.0
2018-04-09 06:00:00	QQQ	ETF	158.37	158.57	158.36	158.42	8210.0
2018-04-09 06:30:00	QQQ	ETF	158.43	158.43	158.16	158.17	28429.0
2018-04-09 07:00:00	QQQ	ETF	158.18	158.37	158.01	158.17	105711.0
2018-04-09 07:30:00	QQQ	ETF	158.19	158.27	157.6166	158.19	183135.0
2018-04-09 08:00:00	QQQ	ETF	156.63	158.29	156.63	158.04	94697.0
2018-04-09 08:30:00	QQQ	ETF	158.04	158.18	157.94	157.98	78147.0
2018-04-09 09:00:00	QQQ	ETF	157.95	158.21	157.9	158.01	73762.0
2018-04-09 09:30:00	QQQ	ETF	158.0	159.22	157.68	158.99	4921853.0
2018-04-09 10:00:00	QQQ	ETF	158.99	159.3548	158.74	159.3	2382955.0
2018-04-09 10:30:00	QQQ	ETF	159.3	159.74	159.29	159.5261	1919645.0
2018-04-09 11:00:00	QQQ	ETF	159.53	159.85	159.18	159.72	1811975.0
2018-04-09 11:30:00	QQQ	ETF	159.73	160.4	159.71	160.3701	2153204.0
2018-04-09 12:00:00	QQQ	ETF	160.38	160.88	160.19	160.44	2600903.0
2018-04-09 12:30:00	QQQ	ETF	160.44	160.575	160.07	160.39	1874989.0

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

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