PREVIEW / etf_30min / 2015-02-12

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-12.parquet
  size:    378 KB
  rows:    12,659

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-02-12 04:00:00	SPY	ETF	207.45	207.7	206.98	207.68	1900.0
2015-02-12 04:30:00	SPY	ETF	207.72	207.83	207.66	207.78	91964.0
2015-02-12 05:00:00	SPY	ETF	207.83	207.98	207.77	207.79	75317.0
2015-02-12 05:30:00	SPY	ETF	207.81	208.25	207.81	208.12	20361.0
2015-02-12 06:00:00	SPY	ETF	208.14	208.23	208.04	208.1	21382.0
2015-02-12 06:30:00	SPY	ETF	208.1	208.1	207.81	208.0	34246.0
2015-02-12 07:00:00	SPY	ETF	208.08	208.16	207.96	207.98	83877.0
2015-02-12 07:30:00	SPY	ETF	207.99	208.15	207.99	208.08	151981.0
2015-02-12 08:00:00	SPY	ETF	208.05	208.24	208.03	208.13	315559.0
2015-02-12 08:30:00	SPY	ETF	208.09	208.09	207.56	207.8	914540.0
2015-02-12 09:00:00	SPY	ETF	207.81	208.0	207.66	207.9	821741.0
2015-02-12 09:30:00	SPY	ETF	207.89	208.32	207.68	208.21	12085271.0
2015-02-12 10:00:00	SPY	ETF	208.2	208.46	208.01	208.02	6827461.0
2015-02-12 10:30:00	SPY	ETF	208.02	208.34	207.95	208.11	5916746.0
2015-02-12 11:00:00	SPY	ETF	208.12	208.31	207.85	207.97	5464606.0
2015-02-12 11:30:00	SPY	ETF	207.98	208.36	207.91	208.26	5157550.0
2015-02-12 12:00:00	SPY	ETF	208.26	208.45	208.23	208.445	3278559.0
2015-02-12 12:30:00	SPY	ETF	208.45	208.6	208.28	208.4	4657082.0
2015-02-12 13:00:00	SPY	ETF	208.41	208.65	208.399	208.53	3803097.0
2015-02-12 13:30:00	SPY	ETF	208.525	208.72	208.48	208.69	5117151.0
2015-02-12 14:00:00	SPY	ETF	208.69	208.74	208.47	208.595	4444288.0
2015-02-12 14:30:00	SPY	ETF	208.6	208.85	208.54	208.82	5351576.0
2015-02-12 15:00:00	SPY	ETF	208.83	208.97	208.76	208.845	6392023.0
2015-02-12 15:30:00	SPY	ETF	208.84	208.99	208.64	208.895	12923397.0
2015-02-12 16:00:00	SPY	ETF	208.89	208.969	206.9727	208.85	10781143.0
2015-02-12 16:30:00	SPY	ETF	208.85	208.96	208.75	208.76	1466818.0
2015-02-12 17:00:00	SPY	ETF	208.76	208.8	208.75	208.78	62760.0
2015-02-12 17:30:00	SPY	ETF	208.79	208.81	208.76	208.8	62371.0
2015-02-12 18:00:00	SPY	ETF	208.77	208.78	208.69	208.72	149315.0
2015-02-12 18:30:00	SPY	ETF	208.721	208.77	208.72	208.75	10422.0
2015-02-12 19:00:00	SPY	ETF	208.74	208.78	208.71	208.74	9575.0
2015-02-12 19:30:00	SPY	ETF	208.74	208.75	208.72	208.72	113335.0
2015-02-12 04:00:00	QQQ	ETF	104.9	105.34	104.9	105.34	21150.0
2015-02-12 04:30:00	QQQ	ETF	105.14	105.14	105.14	105.14	200.0
2015-02-12 05:00:00	QQQ	ETF	105.36	105.36	105.36	105.36	6220.0
2015-02-12 05:30:00	QQQ	ETF	105.41	105.49	105.41	105.49	7250.0
2015-02-12 06:00:00	QQQ	ETF	105.54	105.56	105.48	105.48	5600.0
2015-02-12 06:30:00	QQQ	ETF	105.41	105.41	105.4	105.4	2600.0
2015-02-12 07:00:00	QQQ	ETF	105.47	105.49	105.36	105.4	16494.0
2015-02-12 07:30:00	QQQ	ETF	105.4	105.43	105.38	105.4	19035.0
2015-02-12 08:00:00	QQQ	ETF	105.39	105.52	105.11	105.46	96113.0
2015-02-12 08:30:00	QQQ	ETF	105.45	105.47	105.25	105.44	115171.0
2015-02-12 09:00:00	QQQ	ETF	105.43	105.5	105.38	105.45	164820.0
2015-02-12 09:30:00	QQQ	ETF	105.46	105.66	105.3	105.58	4048631.0
2015-02-12 10:00:00	QQQ	ETF	105.59	105.69	105.5	105.52	1474099.0
2015-02-12 10:30:00	QQQ	ETF	105.52	105.66	105.4805	105.58	1201514.0
2015-02-12 11:00:00	QQQ	ETF	105.59	105.634	105.42	105.484	860484.0
2015-02-12 11:30:00	QQQ	ETF	105.5	105.69	105.47	105.64	1038298.0
2015-02-12 12:00:00	QQQ	ETF	105.64	105.77	105.62	105.77	806945.0
2015-02-12 12:30:00	QQQ	ETF	105.77	105.85	105.7	105.775	1097915.0

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

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