PREVIEW / etf_30min / 2016-02-03

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-03.parquet
  size:    403 KB
  rows:    13,619

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
2016-02-03 04:00:00	SPY	ETF	190.96	191.49	190.81	191.06	52913.0
2016-02-03 04:30:00	SPY	ETF	190.99	191.09	190.32	190.41	18421.0
2016-02-03 05:00:00	SPY	ETF	190.48	190.48	190.0	190.36	35087.0
2016-02-03 05:30:00	SPY	ETF	190.49	190.68	190.04	190.04	46320.0
2016-02-03 06:00:00	SPY	ETF	190.04	190.96	190.04	190.82	43170.0
2016-02-03 06:30:00	SPY	ETF	190.87	191.0	190.7	190.71	45996.0
2016-02-03 07:00:00	SPY	ETF	190.79	191.23	190.79	190.83	98181.0
2016-02-03 07:30:00	SPY	ETF	190.82	190.95	190.31	190.44	397930.0
2016-02-03 08:00:00	SPY	ETF	190.76	190.939	189.56	190.85	892735.0
2016-02-03 08:30:00	SPY	ETF	190.8	191.54	190.73	191.36	1110837.0
2016-02-03 09:00:00	SPY	ETF	191.36	191.64	191.21	191.4	1190998.0
2016-02-03 09:30:00	SPY	ETF	191.41	191.48	189.98	190.08	14886463.0
2016-02-03 10:00:00	SPY	ETF	190.08	190.08	187.78	187.83	24141857.0
2016-02-03 10:30:00	SPY	ETF	187.84	189.08	187.1	188.93	25456138.0
2016-02-03 11:00:00	SPY	ETF	188.93	189.51	187.76	189.15	16730283.0
2016-02-03 11:30:00	SPY	ETF	189.15	189.82	188.57	189.26	13109725.0
2016-02-03 12:00:00	SPY	ETF	189.28	189.62	188.85	189.18	9767667.0
2016-02-03 12:30:00	SPY	ETF	189.18	189.25	188.44	189.2	6904629.0
2016-02-03 13:00:00	SPY	ETF	189.2	189.5	188.6	188.775	5518416.0
2016-02-03 13:30:00	SPY	ETF	188.79	188.815	187.97	187.985	7727750.0
2016-02-03 14:00:00	SPY	ETF	187.985	190.83	187.98	190.51	16300190.0
2016-02-03 14:30:00	SPY	ETF	190.51	191.44	190.2	191.34	18794120.0
2016-02-03 15:00:00	SPY	ETF	191.34	191.78	190.65	190.655	14587121.0
2016-02-03 15:30:00	SPY	ETF	190.655	191.265	190.3	191.19	19399850.0
2016-02-03 16:00:00	SPY	ETF	191.19	191.48	190.21	191.32	5657098.0
2016-02-03 16:30:00	SPY	ETF	191.35	191.46	191.29	191.41	542603.0
2016-02-03 17:00:00	SPY	ETF	191.4	191.47	191.35	191.47	88336.0
2016-02-03 17:30:00	SPY	ETF	191.44	191.48	191.35	191.36	55687.0
2016-02-03 18:00:00	SPY	ETF	191.36	191.74	191.22	191.71	131494.0
2016-02-03 18:30:00	SPY	ETF	191.65	191.71	191.41	191.41	47808.0
2016-02-03 19:00:00	SPY	ETF	191.49	191.6	191.32	191.42	69699.0
2016-02-03 19:30:00	SPY	ETF	191.36	191.47	191.21	191.27	58260.0
2016-02-03 04:00:00	QQQ	ETF	102.5	102.73	102.5	102.73	2300.0
2016-02-03 04:30:00	QQQ	ETF	102.43	102.43	102.08	102.08	900.0
2016-02-03 05:00:00	QQQ	ETF	102.03	102.03	101.9	101.9	5100.0
2016-02-03 05:30:00	QQQ	ETF	102.2	102.24	102.01	102.01	7000.0
2016-02-03 06:00:00	QQQ	ETF	102.11	102.43	102.11	102.39	7500.0
2016-02-03 06:30:00	QQQ	ETF	102.42	102.48	102.35	102.35	2800.0
2016-02-03 07:00:00	QQQ	ETF	102.42	102.63	102.42	102.44	47231.0
2016-02-03 07:30:00	QQQ	ETF	102.52	102.52	102.2	102.24	18508.0
2016-02-03 08:00:00	QQQ	ETF	102.24	102.45	102.21	102.38	45208.0
2016-02-03 08:30:00	QQQ	ETF	102.43	102.84	102.36	102.75	184337.0
2016-02-03 09:00:00	QQQ	ETF	102.77	102.91	102.69	102.8	198267.0
2016-02-03 09:30:00	QQQ	ETF	102.8	102.83	101.78	101.85	5169831.0
2016-02-03 10:00:00	QQQ	ETF	101.84	101.84	100.45	100.47	7633249.0
2016-02-03 10:30:00	QQQ	ETF	100.47	101.16	100.04	101.06	6571376.0
2016-02-03 11:00:00	QQQ	ETF	101.06	101.13	100.23	100.99	4946320.0
2016-02-03 11:30:00	QQQ	ETF	100.99	101.4	100.62	101.08	4295860.0
2016-02-03 12:00:00	QQQ	ETF	101.08	101.3156	100.75	100.871	2756154.0
2016-02-03 12:30:00	QQQ	ETF	100.87	100.87	100.36	100.8	2117214.0

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

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