PREVIEW / etf_30min / 2015-03-12

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-12.parquet
  size:    376 KB
  rows:    12,600

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-12 04:00:00	SPY	ETF	204.65	205.35	204.65	205.29	2600.0
2015-03-12 04:30:00	SPY	ETF	205.21	205.25	205.21	205.25	760.0
2015-03-12 05:00:00	SPY	ETF	205.33	205.33	205.15	205.15	2200.0
2015-03-12 05:30:00	SPY	ETF	204.99	205.07	204.9	204.9	2060.0
2015-03-12 06:00:00	SPY	ETF	204.92	205.16	204.92	205.16	17600.0
2015-03-12 06:30:00	SPY	ETF	205.15	205.29	205.02	205.24	16030.0
2015-03-12 07:00:00	SPY	ETF	205.11	205.12	204.83	204.9	51500.0
2015-03-12 07:30:00	SPY	ETF	204.94	205.19	204.83	205.19	138623.0
2015-03-12 08:00:00	SPY	ETF	205.16	205.41	205.01	205.28	328161.0
2015-03-12 08:30:00	SPY	ETF	205.05	205.61	204.93	205.6	1054984.0
2015-03-12 09:00:00	SPY	ETF	205.6	205.61	205.18	205.26	1200491.0
2015-03-12 09:30:00	SPY	ETF	205.26	206.43	205.2	206.17	17118259.0
2015-03-12 10:00:00	SPY	ETF	206.18	206.32	205.93	206.2	8866585.0
2015-03-12 10:30:00	SPY	ETF	206.2	206.37	205.97	206.26	5386464.0
2015-03-12 11:00:00	SPY	ETF	206.26	206.7	206.13	206.615	5942551.0
2015-03-12 11:30:00	SPY	ETF	206.62	206.69	206.43	206.46	3987796.0
2015-03-12 12:00:00	SPY	ETF	206.47	206.5	206.33	206.45	3398675.0
2015-03-12 12:30:00	SPY	ETF	206.45	206.51	206.21	206.42	2566767.0
2015-03-12 13:00:00	SPY	ETF	206.42	206.62	206.34	206.49	2900700.0
2015-03-12 13:30:00	SPY	ETF	206.485	206.69	206.34	206.59	2766050.0
2015-03-12 14:00:00	SPY	ETF	206.59	206.63	206.44	206.59	2790633.0
2015-03-12 14:30:00	SPY	ETF	206.6	206.88	206.42	206.84	4284741.0
2015-03-12 15:00:00	SPY	ETF	206.845	207.11	206.845	207.04	6736278.0
2015-03-12 15:30:00	SPY	ETF	207.03	207.175	206.92	207.11	15300557.0
2015-03-12 16:00:00	SPY	ETF	207.1	207.13	206.1906	206.97	5532896.0
2015-03-12 16:30:00	SPY	ETF	206.96	207.13	205.8272	207.06	1764575.0
2015-03-12 17:00:00	SPY	ETF	207.04	207.1	206.94	206.94	380004.0
2015-03-12 17:30:00	SPY	ETF	206.94	206.97	206.93	206.96	411256.0
2015-03-12 18:00:00	SPY	ETF	206.98	207.06	206.95	207.05	51863.0
2015-03-12 18:30:00	SPY	ETF	207.05	207.09	207.03	207.09	14405.0
2015-03-12 19:00:00	SPY	ETF	207.09	207.14	207.07	207.14	71275.0
2015-03-12 19:30:00	SPY	ETF	207.14	207.18	207.12	207.18	22766.0
2015-03-12 04:30:00	QQQ	ETF	105.47	105.47	105.47	105.47	100.0
2015-03-12 06:00:00	QQQ	ETF	105.39	105.43	105.39	105.43	1100.0
2015-03-12 06:30:00	QQQ	ETF	105.46	105.46	105.44	105.44	9400.0
2015-03-12 07:00:00	QQQ	ETF	105.44	105.44	105.35	105.35	8500.0
2015-03-12 07:30:00	QQQ	ETF	105.37	105.49	105.35	105.49	26110.0
2015-03-12 08:00:00	QQQ	ETF	105.39	105.52	105.33	105.41	81822.0
2015-03-12 08:30:00	QQQ	ETF	105.41	105.52	105.31	105.52	197765.0
2015-03-12 09:00:00	QQQ	ETF	105.51	105.51	104.93	105.02	1645748.0
2015-03-12 09:30:00	QQQ	ETF	105.03	105.7195	104.96	105.535	4341160.0
2015-03-12 10:00:00	QQQ	ETF	105.535	105.63	105.36	105.57	2141752.0
2015-03-12 10:30:00	QQQ	ETF	105.57	105.66	105.41	105.53	881246.0
2015-03-12 11:00:00	QQQ	ETF	105.515	105.8	105.45	105.72	1242268.0
2015-03-12 11:30:00	QQQ	ETF	105.72	105.74	105.5701	105.6	653559.0
2015-03-12 12:00:00	QQQ	ETF	105.6	105.66	105.52	105.62	514381.0
2015-03-12 12:30:00	QQQ	ETF	105.605	105.65	105.5	105.6	356077.0
2015-03-12 13:00:00	QQQ	ETF	105.595	105.7	105.55	105.66	724737.0
2015-03-12 13:30:00	QQQ	ETF	105.65	105.78	105.5647	105.73	639358.0
2015-03-12 14:00:00	QQQ	ETF	105.735	105.74	105.63	105.67	678994.0

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

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