PREVIEW / etf_30min / 2014-05-21

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-21.parquet
  size:    321 KB
  rows:    11,149

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
2014-05-21 04:00:00	SPY	ETF	187.62	187.78	187.62	187.77	4095.0
2014-05-21 04:30:00	SPY	ETF	187.7	187.74	187.7	187.74	3500.0
2014-05-21 05:00:00	SPY	ETF	187.78	187.89	187.78	187.88	8401.0
2014-05-21 05:30:00	SPY	ETF	187.96	188.0	187.86	187.86	25519.0
2014-05-21 06:00:00	SPY	ETF	187.84	187.9	187.84	187.84	3646.0
2014-05-21 06:30:00	SPY	ETF	187.89	187.89	187.66	187.66	10531.0
2014-05-21 07:00:00	SPY	ETF	187.67	187.8	187.66	187.79	52595.0
2014-05-21 07:30:00	SPY	ETF	187.8	187.9	187.79	187.86	214345.0
2014-05-21 08:00:00	SPY	ETF	187.86	187.92	187.66	187.87	184046.0
2014-05-21 08:30:00	SPY	ETF	187.88	188.16	187.82	188.1	622815.0
2014-05-21 09:00:00	SPY	ETF	188.11	188.15	188.04	188.08	713297.0
2014-05-21 09:30:00	SPY	ETF	188.1	188.83	188.06	188.635	14481263.0
2014-05-21 10:00:00	SPY	ETF	188.64	188.76	188.59	188.7	5276739.0
2014-05-21 10:30:00	SPY	ETF	188.7	188.94	188.691	188.72	5769018.0
2014-05-21 11:00:00	SPY	ETF	188.72	188.82	188.45	188.489	7030445.0
2014-05-21 11:30:00	SPY	ETF	188.48	188.57	188.275	188.41	5685061.0
2014-05-21 12:00:00	SPY	ETF	188.4	188.59	188.33	188.58	3000787.0
2014-05-21 12:30:00	SPY	ETF	188.59	188.78	188.57	188.73	3177916.0
2014-05-21 13:00:00	SPY	ETF	188.73	188.87	188.71	188.72	3659278.0
2014-05-21 13:30:00	SPY	ETF	188.73	188.83	188.65	188.77	1952113.0
2014-05-21 14:00:00	SPY	ETF	188.77	189.08	188.49	188.815	9646399.0
2014-05-21 14:30:00	SPY	ETF	188.82	189.03	188.76	188.95	3515838.0
2014-05-21 15:00:00	SPY	ETF	188.945	189.22	188.88	189.1	6675912.0
2014-05-21 15:30:00	SPY	ETF	189.1	189.17	189.0	189.12	8299426.0
2014-05-21 16:00:00	SPY	ETF	189.11	189.16	187.5993	189.13	3789628.0
2014-05-21 16:30:00	SPY	ETF	189.14	189.14	188.96	188.97	1011689.0
2014-05-21 17:00:00	SPY	ETF	188.96	189.13	188.91	188.99	775700.0
2014-05-21 17:30:00	SPY	ETF	189.01	189.03	188.98	188.98	31126.0
2014-05-21 18:00:00	SPY	ETF	188.99	189.0	188.95	188.98	30520.0
2014-05-21 18:30:00	SPY	ETF	188.99	189.0	188.97	188.97	19705.0
2014-05-21 19:00:00	SPY	ETF	188.99	189.02	188.99	189.0	2230.0
2014-05-21 19:30:00	SPY	ETF	188.99	189.06	188.97	189.06	42520.0
2014-05-21 05:00:00	QQQ	ETF	88.19	88.24	88.19	88.24	5100.0
2014-05-21 05:30:00	QQQ	ETF	88.25	88.25	88.25	88.25	600.0
2014-05-21 06:30:00	QQQ	ETF	88.18	88.18	88.18	88.18	200.0
2014-05-21 07:00:00	QQQ	ETF	88.12	88.21	88.12	88.2	50300.0
2014-05-21 07:30:00	QQQ	ETF	88.18	88.2	88.16	88.18	54030.0
2014-05-21 08:00:00	QQQ	ETF	88.18	88.21	88.11	88.19	55656.0
2014-05-21 08:30:00	QQQ	ETF	88.19	88.25	88.1	88.24	99996.0
2014-05-21 09:00:00	QQQ	ETF	88.23	88.23	88.14	88.15	181090.0
2014-05-21 09:30:00	QQQ	ETF	88.16	88.65	88.11	88.525	5044245.0
2014-05-21 10:00:00	QQQ	ETF	88.51	88.54	88.39	88.48	2302460.0
2014-05-21 10:30:00	QQQ	ETF	88.49	88.685	88.49	88.54	2479019.0
2014-05-21 11:00:00	QQQ	ETF	88.535	88.59	88.305	88.3399	2059691.0
2014-05-21 11:30:00	QQQ	ETF	88.33	88.41	88.2401	88.39	1496996.0
2014-05-21 12:00:00	QQQ	ETF	88.39	88.52	88.35	88.52	1102286.0
2014-05-21 12:30:00	QQQ	ETF	88.52	88.6	88.5	88.5501	1071403.0
2014-05-21 13:00:00	QQQ	ETF	88.56	88.6499	88.55	88.575	1141898.0
2014-05-21 13:30:00	QQQ	ETF	88.58	88.67	88.54	88.61	1111507.0
2014-05-21 14:00:00	QQQ	ETF	88.61	88.79	88.48	88.66	3672112.0

> showing 50 of 11,149 rows — these rows as CSV

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