PREVIEW / etf_30min / 2015-05-19

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-19.parquet
  size:    381 KB
  rows:    12,923

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
2015-05-19 04:00:00	SPY	ETF	213.55	213.76	213.51	213.65	12635.0
2015-05-19 04:30:00	SPY	ETF	213.67	213.69	213.67	213.69	400.0
2015-05-19 05:00:00	SPY	ETF	213.68	213.81	213.67	213.7	29570.0
2015-05-19 05:30:00	SPY	ETF	213.72	213.75	213.72	213.75	11712.0
2015-05-19 06:00:00	SPY	ETF	213.77	213.77	213.67	213.73	5800.0
2015-05-19 06:30:00	SPY	ETF	213.72	213.79	213.67	213.67	28056.0
2015-05-19 07:00:00	SPY	ETF	213.71	213.72	213.55	213.65	117448.0
2015-05-19 07:30:00	SPY	ETF	213.66	213.7	213.62	213.66	84897.0
2015-05-19 08:00:00	SPY	ETF	213.66	213.7	213.56	213.6	219392.0
2015-05-19 08:30:00	SPY	ETF	213.66	213.72	213.1	213.42	555064.0
2015-05-19 09:00:00	SPY	ETF	213.4	213.46	213.21	213.26	439749.0
2015-05-19 09:30:00	SPY	ETF	213.24	213.32	212.8	213.07	10356906.0
2015-05-19 10:00:00	SPY	ETF	213.07	213.23	212.86	213.19	5253763.0
2015-05-19 10:30:00	SPY	ETF	213.2	213.31	213.05	213.08	4387223.0
2015-05-19 11:00:00	SPY	ETF	213.08	213.29	212.93	213.25	3887410.0
2015-05-19 11:30:00	SPY	ETF	213.26	213.36	213.11	213.19	2934957.0
2015-05-19 12:00:00	SPY	ETF	213.19	213.27	213.1	213.11	2337023.0
2015-05-19 12:30:00	SPY	ETF	213.1	213.3	213.08	213.2	1555435.0
2015-05-19 13:00:00	SPY	ETF	213.2	213.3	213.15	213.3	1530371.0
2015-05-19 13:30:00	SPY	ETF	213.29	213.57	213.28	213.45	3429794.0
2015-05-19 14:00:00	SPY	ETF	213.455	213.49	213.35	213.37	1882073.0
2015-05-19 14:30:00	SPY	ETF	213.37	213.379	212.97	213.18	4829668.0
2015-05-19 15:00:00	SPY	ETF	213.18	213.19	212.69	212.84	7895552.0
2015-05-19 15:30:00	SPY	ETF	212.83	213.13	212.8	213.01	11944571.0
2015-05-19 16:00:00	SPY	ETF	213.02	213.0932	212.93	212.96	6991147.0
2015-05-19 16:30:00	SPY	ETF	212.96	213.03	212.91	212.98	932208.0
2015-05-19 17:00:00	SPY	ETF	212.97	212.99	212.94	212.99	25499.0
2015-05-19 17:30:00	SPY	ETF	212.97	212.99	212.93	212.96	22068.0
2015-05-19 18:00:00	SPY	ETF	212.95	212.98	212.93	212.94	37066.0
2015-05-19 18:30:00	SPY	ETF	212.99	212.99	212.98	212.98	3200.0
2015-05-19 19:00:00	SPY	ETF	212.98	212.98	212.96	212.96	480.0
2015-05-19 19:30:00	SPY	ETF	212.98	212.99	212.95	212.98	11674.0
2015-05-19 04:30:00	QQQ	ETF	110.38	110.38	110.38	110.38	1000.0
2015-05-19 05:00:00	QQQ	ETF	110.41	110.41	110.41	110.41	17900.0
2015-05-19 05:30:00	QQQ	ETF	110.42	110.42	110.42	110.42	300.0
2015-05-19 06:00:00	QQQ	ETF	110.38	110.38	110.38	110.38	1900.0
2015-05-19 06:30:00	QQQ	ETF	110.45	110.48	110.45	110.48	5200.0
2015-05-19 07:00:00	QQQ	ETF	110.42	110.43	110.36	110.43	34501.0
2015-05-19 07:30:00	QQQ	ETF	110.42	110.46	110.42	110.46	21427.0
2015-05-19 08:00:00	QQQ	ETF	110.45	110.45	110.38	110.43	28343.0
2015-05-19 08:30:00	QQQ	ETF	110.46	110.47	110.24	110.28	55095.0
2015-05-19 09:00:00	QQQ	ETF	110.28	110.29	110.14	110.18	82713.0
2015-05-19 09:30:00	QQQ	ETF	110.17	110.35	110.04	110.21	2620500.0
2015-05-19 10:00:00	QQQ	ETF	110.205	110.28	109.92	110.161	1440441.0
2015-05-19 10:30:00	QQQ	ETF	110.17	110.198	109.99	110.0	804758.0
2015-05-19 11:00:00	QQQ	ETF	110.0	110.08	109.9	110.06	636449.0
2015-05-19 11:30:00	QQQ	ETF	110.06	110.11	109.8899	110.02	627904.0
2015-05-19 12:00:00	QQQ	ETF	110.0199	110.065	109.95	109.952	234746.0
2015-05-19 12:30:00	QQQ	ETF	109.95	110.08	109.93	110.04	422954.0
2015-05-19 13:00:00	QQQ	ETF	110.05	110.09	109.97	110.08	201984.0

> showing 50 of 12,923 rows — these rows as CSV

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