PREVIEW / etf_30min / 2014-10-09

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-09.parquet
  size:    373 KB
  rows:    12,435

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-10-09 04:00:00	SPY	ETF	197.04	197.45	197.04	197.15	3889.0
2014-10-09 04:30:00	SPY	ETF	197.23	197.26	197.11	197.21	6080.0
2014-10-09 05:00:00	SPY	ETF	197.13	197.3	197.13	197.2	21850.0
2014-10-09 05:30:00	SPY	ETF	197.23	197.3	197.2	197.21	31695.0
2014-10-09 06:00:00	SPY	ETF	197.2	197.28	197.12	197.12	7727.0
2014-10-09 06:30:00	SPY	ETF	197.09	197.14	196.85	196.87	196461.0
2014-10-09 07:00:00	SPY	ETF	196.84	196.9	196.45	196.66	519251.0
2014-10-09 07:30:00	SPY	ETF	196.64	196.68	195.9	196.05	1135735.0
2014-10-09 08:00:00	SPY	ETF	196.03	196.84	195.95	196.2	790632.0
2014-10-09 08:30:00	SPY	ETF	196.19	196.7385	196.17	196.35	1493799.0
2014-10-09 09:00:00	SPY	ETF	196.34	196.38	196.06	196.33	1482127.0
2014-10-09 09:30:00	SPY	ETF	196.33	196.6	195.49	195.72	17143672.0
2014-10-09 10:00:00	SPY	ETF	195.7	196.11	195.47	195.848	10975294.0
2014-10-09 10:30:00	SPY	ETF	195.84	195.84	195.06	195.585	11571533.0
2014-10-09 11:00:00	SPY	ETF	195.58	195.84	195.09	195.44	10706119.0
2014-10-09 11:30:00	SPY	ETF	195.45	195.48	193.83	194.2	16100808.0
2014-10-09 12:00:00	SPY	ETF	194.2	194.4	193.3	193.43	13655468.0
2014-10-09 12:30:00	SPY	ETF	193.455	193.89	193.23	193.81	10939779.0
2014-10-09 13:00:00	SPY	ETF	193.82	193.835	192.82	193.5164	15054806.0
2014-10-09 13:30:00	SPY	ETF	193.51	194.13	193.27	193.43	12540365.0
2014-10-09 14:00:00	SPY	ETF	193.42	193.42	192.76	192.86	13347048.0
2014-10-09 14:30:00	SPY	ETF	192.86	193.38	192.58	192.82	12830934.0
2014-10-09 15:00:00	SPY	ETF	192.82	193.37	192.61	193.22	16006282.0
2014-10-09 15:30:00	SPY	ETF	193.222	193.78	192.65	192.68	28779461.0
2014-10-09 16:00:00	SPY	ETF	192.67	193.36	192.67	192.89	9080991.0
2014-10-09 16:30:00	SPY	ETF	192.89	192.93	192.1	192.39	1758712.0
2014-10-09 17:00:00	SPY	ETF	192.37	192.43	192.21	192.3	218625.0
2014-10-09 17:30:00	SPY	ETF	192.32	192.44	192.26	192.39	112429.0
2014-10-09 18:00:00	SPY	ETF	192.31	192.51	192.31	192.48	298585.0
2014-10-09 18:30:00	SPY	ETF	192.47	192.49	192.25	192.25	78574.0
2014-10-09 19:00:00	SPY	ETF	192.3	192.4	192.19	192.32	202889.0
2014-10-09 19:30:00	SPY	ETF	192.3	192.45	192.17	192.38	126041.0
2014-10-09 04:00:00	QQQ	ETF	98.5	98.88	98.5	98.83	1650.0
2014-10-09 04:30:00	QQQ	ETF	98.8	98.8	98.8	98.8	500.0
2014-10-09 05:30:00	QQQ	ETF	98.81	98.83	98.78	98.82	18300.0
2014-10-09 06:00:00	QQQ	ETF	98.79	98.81	98.77	98.77	19650.0
2014-10-09 06:30:00	QQQ	ETF	98.74	98.8	98.65	98.67	30320.0
2014-10-09 07:00:00	QQQ	ETF	98.65	98.65	98.47	98.56	84950.0
2014-10-09 07:30:00	QQQ	ETF	98.52	98.55	98.11	98.21	118700.0
2014-10-09 08:00:00	QQQ	ETF	98.53	98.53	98.15	98.28	71075.0
2014-10-09 08:30:00	QQQ	ETF	98.28	98.53	98.28	98.4	309752.0
2014-10-09 09:00:00	QQQ	ETF	98.41	98.41	98.23	98.34	451626.0
2014-10-09 09:30:00	QQQ	ETF	98.33	98.57	98.06	98.199	4905385.0
2014-10-09 10:00:00	QQQ	ETF	98.2	98.37	98.03	98.27	2712836.0
2014-10-09 10:30:00	QQQ	ETF	98.26	98.32	97.87	98.3	3232290.0
2014-10-09 11:00:00	QQQ	ETF	98.3	98.55	98.1	98.38	3311976.0
2014-10-09 11:30:00	QQQ	ETF	98.39	98.4	97.4701	97.64	4984935.0
2014-10-09 12:00:00	QQQ	ETF	97.64	97.75	97.14	97.23	4592225.0
2014-10-09 12:30:00	QQQ	ETF	97.225	97.37	97.06	97.295	3286642.0
2014-10-09 13:00:00	QQQ	ETF	97.3	97.31	96.8	97.139	4096288.0

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

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