PREVIEW / etf_30min / 2014-04-22

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-22.parquet
  size:    332 KB
  rows:    11,442

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-04-22 04:00:00	SPY	ETF	186.76	187.25	186.76	187.25	1003.0
2014-04-22 05:00:00	SPY	ETF	187.07	187.07	186.92	186.92	4592.0
2014-04-22 05:30:00	SPY	ETF	186.97	187.03	186.96	186.99	10713.0
2014-04-22 06:00:00	SPY	ETF	186.99	187.11	186.98	187.11	7007.0
2014-04-22 06:30:00	SPY	ETF	187.11	187.13	187.03	187.03	15393.0
2014-04-22 07:00:00	SPY	ETF	187.02	187.12	187.0	187.05	107640.0
2014-04-22 07:30:00	SPY	ETF	187.04	187.04	186.92	186.99	63452.0
2014-04-22 08:00:00	SPY	ETF	187.01	187.12	186.88	187.05	253285.0
2014-04-22 08:30:00	SPY	ETF	187.06	187.18	187.02	187.16	130605.0
2014-04-22 09:00:00	SPY	ETF	187.18	187.27	187.11	187.23	605060.0
2014-04-22 09:30:00	SPY	ETF	187.23	187.67	187.13	187.66	12017873.0
2014-04-22 10:00:00	SPY	ETF	187.66	187.94	187.57	187.82	9658213.0
2014-04-22 10:30:00	SPY	ETF	187.83	187.95	187.74	187.92	5911484.0
2014-04-22 11:00:00	SPY	ETF	187.92	188.12	187.9	188.08	5736979.0
2014-04-22 11:30:00	SPY	ETF	188.08	188.18	187.97	188.06	4511419.0
2014-04-22 12:00:00	SPY	ETF	188.06	188.34	188.04	188.27	5421608.0
2014-04-22 12:30:00	SPY	ETF	188.27	188.3	188.17	188.268	3852333.0
2014-04-22 13:00:00	SPY	ETF	188.27	188.34	188.18	188.27	2552534.0
2014-04-22 13:30:00	SPY	ETF	188.28	188.4	188.23	188.32	3627388.0
2014-04-22 14:00:00	SPY	ETF	188.31	188.34	188.19	188.23	3575043.0
2014-04-22 14:30:00	SPY	ETF	188.24	188.4	188.22	188.22	3550608.0
2014-04-22 15:00:00	SPY	ETF	188.23	188.27	187.98	188.0199	6143566.0
2014-04-22 15:30:00	SPY	ETF	188.0199	188.1	187.81	187.86	10086048.0
2014-04-22 16:00:00	SPY	ETF	187.86	188.0637	187.3	187.97	3875626.0
2014-04-22 16:30:00	SPY	ETF	187.97	187.97	187.87	187.89	362435.0
2014-04-22 17:00:00	SPY	ETF	187.87	187.95	187.87	187.89	2067676.0
2014-04-22 17:30:00	SPY	ETF	187.89	187.9	187.83	187.88	35684.0
2014-04-22 18:00:00	SPY	ETF	187.88	187.88	187.76	187.88	45028.0
2014-04-22 18:30:00	SPY	ETF	187.86	187.88	187.79	187.86	28442.0
2014-04-22 19:00:00	SPY	ETF	187.88	187.89	187.86	187.87	8100.0
2014-04-22 19:30:00	SPY	ETF	187.89	187.93	187.86	187.88	16910.0
2014-04-22 05:00:00	QQQ	ETF	86.66	86.66	86.66	86.66	990.0
2014-04-22 05:30:00	QQQ	ETF	86.95	86.96	86.95	86.96	200.0
2014-04-22 06:00:00	QQQ	ETF	86.97	87.0	86.97	87.0	2300.0
2014-04-22 06:30:00	QQQ	ETF	87.06	87.08	87.02	87.02	3010.0
2014-04-22 07:30:00	QQQ	ETF	86.97	86.99	86.97	86.99	700.0
2014-04-22 08:00:00	QQQ	ETF	86.96	87.0	86.87	87.0	583779.0
2014-04-22 08:30:00	QQQ	ETF	87.01	87.07	86.98	87.05	135889.0
2014-04-22 09:00:00	QQQ	ETF	87.05	87.15	87.02	87.11	189626.0
2014-04-22 09:30:00	QQQ	ETF	87.1	87.31	86.9898	87.27	5493986.0
2014-04-22 10:00:00	QQQ	ETF	87.28	87.48	87.2	87.4	3579699.0
2014-04-22 10:30:00	QQQ	ETF	87.405	87.5	87.33	87.48	1674644.0
2014-04-22 11:00:00	QQQ	ETF	87.47	87.57	87.46	87.56	2126441.0
2014-04-22 11:30:00	QQQ	ETF	87.56	87.66	87.5	87.56	1563776.0
2014-04-22 12:00:00	QQQ	ETF	87.56	87.72	87.55	87.695	1093706.0
2014-04-22 12:30:00	QQQ	ETF	87.7	87.72	87.58	87.6304	939640.0
2014-04-22 13:00:00	QQQ	ETF	87.635	87.65	87.56	87.62	982170.0
2014-04-22 13:30:00	QQQ	ETF	87.625	87.7299	87.6	87.71	1232942.0
2014-04-22 14:00:00	QQQ	ETF	87.71	87.72	87.62	87.65	897982.0
2014-04-22 14:30:00	QQQ	ETF	87.65	87.745	87.642	87.66	1225810.0

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

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