PREVIEW / etf_30min / 2017-05-02

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-02.parquet
  size:    431 KB
  rows:    14,818

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-05-02 04:00:00	SPY	ETF	238.5	238.62	238.5	238.56	704.0
2017-05-02 04:30:00	SPY	ETF	238.58	238.58	238.51	238.51	1301.0
2017-05-02 05:00:00	SPY	ETF	238.56	238.63	238.54	238.62	2400.0
2017-05-02 05:30:00	SPY	ETF	238.66	238.75	238.66	238.71	8225.0
2017-05-02 06:00:00	SPY	ETF	238.74	238.74	238.54	238.54	800.0
2017-05-02 06:30:00	SPY	ETF	238.58	238.64	238.58	238.63	61700.0
2017-05-02 07:00:00	SPY	ETF	238.63	238.66	238.6	238.63	17400.0
2017-05-02 07:30:00	SPY	ETF	238.63	238.69	238.6	238.66	70755.0
2017-05-02 08:00:00	SPY	ETF	238.68	238.81	238.6	238.78	284522.0
2017-05-02 08:30:00	SPY	ETF	238.78	238.81	238.71	238.79	31432.0
2017-05-02 09:00:00	SPY	ETF	238.79	238.9	238.74	238.85	393084.0
2017-05-02 09:30:00	SPY	ETF	238.84	238.98	238.35	238.36	6841134.0
2017-05-02 10:00:00	SPY	ETF	238.36	238.56	238.3	238.52	4589058.0
2017-05-02 10:30:00	SPY	ETF	238.52	238.62	238.42	238.465	2664028.0
2017-05-02 11:00:00	SPY	ETF	238.47	238.55	238.38	238.471	4052596.0
2017-05-02 11:30:00	SPY	ETF	238.48	238.62	238.43	238.565	3010051.0
2017-05-02 12:00:00	SPY	ETF	238.57	238.83	238.56	238.79	3343027.0
2017-05-02 12:30:00	SPY	ETF	238.79	238.9	238.77	238.8164	1530898.0
2017-05-02 13:00:00	SPY	ETF	238.82	238.8959	238.74	238.765	2119919.0
2017-05-02 13:30:00	SPY	ETF	238.77	238.8	238.63	238.66	2496446.0
2017-05-02 14:00:00	SPY	ETF	238.66	238.78	238.63	238.66	4573923.0
2017-05-02 14:30:00	SPY	ETF	238.65	238.67	238.39	238.455	2827805.0
2017-05-02 15:00:00	SPY	ETF	238.46	238.59	238.38	238.52	2485397.0
2017-05-02 15:30:00	SPY	ETF	238.52	238.81	238.49	238.79	8107911.0
2017-05-02 16:00:00	SPY	ETF	238.78	238.8315	238.66	238.73	5831833.0
2017-05-02 16:30:00	SPY	ETF	238.71	238.77	238.51	238.54	1172178.0
2017-05-02 17:00:00	SPY	ETF	238.55	238.56	238.41	238.45	128219.0
2017-05-02 17:30:00	SPY	ETF	238.43	238.46	238.42	238.46	39132.0
2017-05-02 18:00:00	SPY	ETF	238.47	238.83	238.37	238.56	163527.0
2017-05-02 18:30:00	SPY	ETF	238.56	238.57	238.54	238.57	2880.0
2017-05-02 19:00:00	SPY	ETF	238.56	238.57	238.53	238.57	5582.0
2017-05-02 19:30:00	SPY	ETF	238.57	238.6	238.55	238.57	44356.0
2017-05-02 04:00:00	QQQ	ETF	137.25	137.25	137.21	137.21	1999.0
2017-05-02 04:30:00	QQQ	ETF	137.31	137.31	137.31	137.31	100.0
2017-05-02 05:30:00	QQQ	ETF	137.32	137.34	137.3	137.34	16100.0
2017-05-02 06:00:00	QQQ	ETF	137.39	137.39	137.27	137.27	10300.0
2017-05-02 06:30:00	QQQ	ETF	137.27	137.27	137.27	137.27	10000.0
2017-05-02 07:00:00	QQQ	ETF	137.28	137.31	137.26	137.26	31500.0
2017-05-02 07:30:00	QQQ	ETF	137.27	137.33	137.27	137.32	28050.0
2017-05-02 08:00:00	QQQ	ETF	137.27	137.39	137.27	137.39	8508.0
2017-05-02 08:30:00	QQQ	ETF	137.36	137.42	137.35	137.42	77739.0
2017-05-02 09:00:00	QQQ	ETF	137.41	137.42	137.36	137.37	167033.0
2017-05-02 09:30:00	QQQ	ETF	137.38	137.4	137.06	137.1038	3143370.0
2017-05-02 10:00:00	QQQ	ETF	137.1	137.22	137.02	137.18	1992912.0
2017-05-02 10:30:00	QQQ	ETF	137.18	137.295	137.13	137.26	537265.0
2017-05-02 11:00:00	QQQ	ETF	137.26	137.33	137.22	137.29	1028411.0
2017-05-02 11:30:00	QQQ	ETF	137.29	137.38	137.28	137.32	657414.0
2017-05-02 12:00:00	QQQ	ETF	137.31	137.47	137.31	137.415	1169657.0
2017-05-02 12:30:00	QQQ	ETF	137.415	137.49	137.41	137.43	692952.0
2017-05-02 13:00:00	QQQ	ETF	137.43	137.465	137.34	137.36	412638.0

> showing 50 of 14,818 rows — these rows as CSV

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