PREVIEW / etf_30min / 2015-03-02

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-02.parquet
  size:    384 KB
  rows:    12,949

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-03-02 04:00:00	SPY	ETF	211.07	211.08	211.07	211.08	1000.0
2015-03-02 04:30:00	SPY	ETF	211.02	211.14	211.02	211.12	11100.0
2015-03-02 05:00:00	SPY	ETF	211.07	211.13	211.04	211.13	2774.0
2015-03-02 06:00:00	SPY	ETF	211.05	211.05	210.99	211.0	3240.0
2015-03-02 06:30:00	SPY	ETF	210.95	211.0	210.79	210.79	33945.0
2015-03-02 07:00:00	SPY	ETF	210.88	210.95	210.79	210.89	16855.0
2015-03-02 07:30:00	SPY	ETF	210.86	210.86	210.71	210.78	119018.0
2015-03-02 08:00:00	SPY	ETF	210.77	210.83	210.63	210.79	240423.0
2015-03-02 08:30:00	SPY	ETF	210.79	210.83	210.6	210.62	198693.0
2015-03-02 09:00:00	SPY	ETF	210.61	210.8	210.57	210.78	503862.0
2015-03-02 09:30:00	SPY	ETF	210.78	211.29	210.72	211.27	9112182.0
2015-03-02 10:00:00	SPY	ETF	211.27	211.66	211.25	211.62	7369728.0
2015-03-02 10:30:00	SPY	ETF	211.625	211.75	211.47	211.6	4740729.0
2015-03-02 11:00:00	SPY	ETF	211.6	211.66	211.41	211.52	3996916.0
2015-03-02 11:30:00	SPY	ETF	211.52	211.78	211.51	211.55	4695968.0
2015-03-02 12:00:00	SPY	ETF	211.559	211.59	211.21	211.2601	3938540.0
2015-03-02 12:30:00	SPY	ETF	211.2699	211.47	211.23	211.41	2978984.0
2015-03-02 13:00:00	SPY	ETF	211.415	211.48	211.36	211.47	2759516.0
2015-03-02 13:30:00	SPY	ETF	211.47	211.65	211.4375	211.6152	2871002.0
2015-03-02 14:00:00	SPY	ETF	211.62	211.67	211.375	211.38	3643857.0
2015-03-02 14:30:00	SPY	ETF	211.38	211.69	211.37	211.645	4088241.0
2015-03-02 15:00:00	SPY	ETF	211.65	211.84	211.6	211.82	5672180.0
2015-03-02 15:30:00	SPY	ETF	211.82	212.06	211.79	212.0	16972991.0
2015-03-02 16:00:00	SPY	ETF	212.01	212.03	211.86	211.93	7749984.0
2015-03-02 16:30:00	SPY	ETF	211.93	211.99	211.93	211.93	2522124.0
2015-03-02 17:00:00	SPY	ETF	211.93	211.96	211.5697	211.9	88813.0
2015-03-02 17:30:00	SPY	ETF	211.9	211.95	211.12	211.91	1493025.0
2015-03-02 18:00:00	SPY	ETF	211.92	211.96	211.89	211.93	22113.0
2015-03-02 18:30:00	SPY	ETF	211.93	211.93	211.93	211.93	700.0
2015-03-02 19:00:00	SPY	ETF	211.915	211.92	211.89	211.89	24974.0
2015-03-02 19:30:00	SPY	ETF	211.88	211.89	211.86	211.86	75705.0
2015-03-02 05:00:00	QQQ	ETF	108.75	108.75	108.75	108.75	300.0
2015-03-02 05:30:00	QQQ	ETF	108.73	108.73	108.73	108.73	100.0
2015-03-02 06:00:00	QQQ	ETF	108.61	108.61	108.61	108.61	1000.0
2015-03-02 06:30:00	QQQ	ETF	108.61	108.65	108.52	108.52	25300.0
2015-03-02 07:00:00	QQQ	ETF	108.55	108.6	108.53	108.6	14092.0
2015-03-02 07:30:00	QQQ	ETF	108.57	108.57	108.53	108.57	29644.0
2015-03-02 08:00:00	QQQ	ETF	108.56	108.61	108.51	108.57	39507.0
2015-03-02 08:30:00	QQQ	ETF	108.35	108.6	108.35	108.54	53456.0
2015-03-02 09:00:00	QQQ	ETF	108.55	108.62	108.53	108.61	98329.0
2015-03-02 09:30:00	QQQ	ETF	108.61	109.07	108.59	109.06	4323502.0
2015-03-02 10:00:00	QQQ	ETF	109.06	109.21	108.99	109.19	2474947.0
2015-03-02 10:30:00	QQQ	ETF	109.195	109.25	108.98	109.08	1823620.0
2015-03-02 11:00:00	QQQ	ETF	109.08	109.23	108.98	109.18	1148764.0
2015-03-02 11:30:00	QQQ	ETF	109.18	109.29	109.16	109.19	928138.0
2015-03-02 12:00:00	QQQ	ETF	109.19	109.22	108.97	109.0	926406.0
2015-03-02 12:30:00	QQQ	ETF	109.0	109.05	108.87	109.01	1168366.0
2015-03-02 13:00:00	QQQ	ETF	109.01	109.02	108.83	108.907	669610.0
2015-03-02 13:30:00	QQQ	ETF	108.92	109.075	108.88	109.07	654096.0
2015-03-02 14:00:00	QQQ	ETF	109.07	109.16	109.0232	109.03	924089.0

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

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