PREVIEW / etf_30min / 2017-11-02

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-02.parquet
  size:    444 KB
  rows:    15,275

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-11-02 04:00:00	SPY	ETF	257.1	257.13	257.02	257.13	500.0
2017-11-02 04:30:00	SPY	ETF	257.15	257.25	257.15	257.15	600.0
2017-11-02 05:00:00	SPY	ETF	257.0	257.14	256.9	257.14	1000.0
2017-11-02 05:30:00	SPY	ETF	257.12	257.19	257.1	257.14	4000.0
2017-11-02 06:00:00	SPY	ETF	257.17	257.17	257.04	257.04	19100.0
2017-11-02 06:30:00	SPY	ETF	257.09	257.12	257.08	257.12	800.0
2017-11-02 07:00:00	SPY	ETF	257.14	257.34	257.14	257.17	28571.0
2017-11-02 07:30:00	SPY	ETF	257.2	257.33	257.2	257.28	30514.0
2017-11-02 08:00:00	SPY	ETF	257.29	257.38	257.17	257.32	60944.0
2017-11-02 08:30:00	SPY	ETF	257.28	257.54	257.28	257.51	163154.0
2017-11-02 09:00:00	SPY	ETF	257.49	257.52	257.36	257.43	239645.0
2017-11-02 09:30:00	SPY	ETF	257.41	257.53	257.25	257.37	4114754.0
2017-11-02 10:00:00	SPY	ETF	257.37	257.39	256.19	256.63	7585450.0
2017-11-02 10:30:00	SPY	ETF	256.64	257.1	256.599	256.93	4791737.0
2017-11-02 11:00:00	SPY	ETF	256.93	257.27	256.78	256.82	3305191.0
2017-11-02 11:30:00	SPY	ETF	256.82	257.035	256.63	257.03	3004129.0
2017-11-02 12:00:00	SPY	ETF	257.035	257.46	256.97	257.42	3018604.0
2017-11-02 12:30:00	SPY	ETF	257.42	257.44	257.23	257.35	2846592.0
2017-11-02 13:00:00	SPY	ETF	257.35	257.4	257.17	257.205	1318379.0
2017-11-02 13:30:00	SPY	ETF	257.2	257.25	257.11	257.18	1935117.0
2017-11-02 14:00:00	SPY	ETF	257.18	257.435	257.13	257.42	1718890.0
2017-11-02 14:30:00	SPY	ETF	257.43	257.44	257.05	257.055	2053668.0
2017-11-02 15:00:00	SPY	ETF	257.055	257.41	257.05	257.39	2715640.0
2017-11-02 15:30:00	SPY	ETF	257.391	257.75	257.39	257.61	9101700.0
2017-11-02 16:00:00	SPY	ETF	257.62	257.75	257.48	257.56	5833972.0
2017-11-02 16:30:00	SPY	ETF	257.7	257.77	257.4104	257.4104	698190.0
2017-11-02 17:00:00	SPY	ETF	257.67	257.75	257.67	257.68	30370.0
2017-11-02 17:30:00	SPY	ETF	257.68	257.69	257.59	257.67	639748.0
2017-11-02 18:00:00	SPY	ETF	257.64	257.72	257.6	257.72	156579.0
2017-11-02 18:30:00	SPY	ETF	257.72	257.74	257.71	257.71	9740.0
2017-11-02 19:00:00	SPY	ETF	257.71	257.77	257.71	257.77	6344.0
2017-11-02 19:30:00	SPY	ETF	257.77	257.8	257.6168	257.79	14773.0
2017-11-02 04:30:00	QQQ	ETF	151.76	151.76	151.76	151.76	2500.0
2017-11-02 05:00:00	QQQ	ETF	151.78	151.78	151.78	151.78	1200.0
2017-11-02 05:30:00	QQQ	ETF	151.78	151.78	151.77	151.77	29952.0
2017-11-02 06:00:00	QQQ	ETF	151.79	151.79	151.76	151.76	1300.0
2017-11-02 06:30:00	QQQ	ETF	151.74	151.74	151.73	151.74	1900.0
2017-11-02 07:00:00	QQQ	ETF	151.91	151.91	151.85	151.85	11442.0
2017-11-02 07:30:00	QQQ	ETF	151.83	151.93	151.83	151.9	7183.0
2017-11-02 08:00:00	QQQ	ETF	151.9	151.95	151.85	151.94	31076.0
2017-11-02 08:30:00	QQQ	ETF	151.95	152.1	151.91	152.09	47981.0
2017-11-02 09:00:00	QQQ	ETF	152.06	152.06	151.9	151.92	104869.0
2017-11-02 09:30:00	QQQ	ETF	151.92	151.99	151.57	151.82	2741518.0
2017-11-02 10:00:00	QQQ	ETF	151.83	151.83	151.13	151.41	3091697.0
2017-11-02 10:30:00	QQQ	ETF	151.41	151.74	151.399	151.455	1645727.0
2017-11-02 11:00:00	QQQ	ETF	151.46	151.74	151.115	151.17	1018797.0
2017-11-02 11:30:00	QQQ	ETF	151.1675	151.3	150.77	151.3	2812833.0
2017-11-02 12:00:00	QQQ	ETF	151.3	151.6	151.23	151.57	1232856.0
2017-11-02 12:30:00	QQQ	ETF	151.58	151.66	151.335	151.555	833721.0
2017-11-02 13:00:00	QQQ	ETF	151.56	151.68	151.4779	151.49	474580.0

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

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