PREVIEW / etf_30min / 2014-08-13

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-13.parquet
  size:    333 KB
  rows:    11,293

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-08-13 04:00:00	SPY	ETF	194.23	194.45	194.23	194.42	6899.0
2014-08-13 04:30:00	SPY	ETF	194.43	194.43	194.33	194.37	3539.0
2014-08-13 05:00:00	SPY	ETF	194.39	194.39	194.3	194.3	943.0
2014-08-13 05:30:00	SPY	ETF	194.3	194.4	194.18	194.38	50504.0
2014-08-13 06:00:00	SPY	ETF	194.33	194.39	194.32	194.39	3760.0
2014-08-13 06:30:00	SPY	ETF	194.41	194.63	194.41	194.58	147180.0
2014-08-13 07:00:00	SPY	ETF	194.63	194.63	194.37	194.44	248662.0
2014-08-13 07:30:00	SPY	ETF	194.41	194.57	194.41	194.57	174115.0
2014-08-13 08:00:00	SPY	ETF	194.54	194.65	193.67	194.44	403839.0
2014-08-13 08:30:00	SPY	ETF	194.45	194.5	194.22	194.24	475092.0
2014-08-13 09:00:00	SPY	ETF	194.25	194.31	194.08	194.29	755510.0
2014-08-13 09:30:00	SPY	ETF	194.29	194.54	193.99	194.089	9022682.0
2014-08-13 10:00:00	SPY	ETF	194.08	194.35	193.96	194.23	5586417.0
2014-08-13 10:30:00	SPY	ETF	194.23	194.49	194.2	194.47	4323287.0
2014-08-13 11:00:00	SPY	ETF	194.465	195.02	194.455	194.92	8012643.0
2014-08-13 11:30:00	SPY	ETF	194.92	195.06	194.8	194.81	5756050.0
2014-08-13 12:00:00	SPY	ETF	194.8	194.88	194.6	194.81	4230273.0
2014-08-13 12:30:00	SPY	ETF	194.81	194.92	194.68	194.83	1635742.0
2014-08-13 13:00:00	SPY	ETF	194.84	194.89	194.74	194.82	1962461.0
2014-08-13 13:30:00	SPY	ETF	194.82	194.97	194.8	194.881	2749466.0
2014-08-13 14:00:00	SPY	ETF	194.89	194.89	194.6	194.67	3348817.0
2014-08-13 14:30:00	SPY	ETF	194.67	194.8	194.64	194.73	1544868.0
2014-08-13 15:00:00	SPY	ETF	194.72	194.85	194.62	194.76	2488743.0
2014-08-13 15:30:00	SPY	ETF	194.765	194.92	194.7	194.91	8060318.0
2014-08-13 16:00:00	SPY	ETF	194.91	195.07	193.5724	195.01	5556522.0
2014-08-13 16:30:00	SPY	ETF	195.01	195.18	195.01	195.16	1391471.0
2014-08-13 17:00:00	SPY	ETF	195.16	195.18	195.11	195.15	29377.0
2014-08-13 17:30:00	SPY	ETF	195.16	195.2	195.15	195.15	29796.0
2014-08-13 18:00:00	SPY	ETF	195.15	195.16	195.02	195.04	45187.0
2014-08-13 18:30:00	SPY	ETF	195.06	195.06	195.0	195.05	14650.0
2014-08-13 19:00:00	SPY	ETF	195.06	195.06	195.03	195.06	4259.0
2014-08-13 19:30:00	SPY	ETF	195.08	195.08	194.99	195.01	56207.0
2014-08-13 04:00:00	QQQ	ETF	95.71	95.78	95.71	95.78	1300.0
2014-08-13 05:00:00	QQQ	ETF	95.7	95.7	95.7	95.7	4000.0
2014-08-13 05:30:00	QQQ	ETF	95.72	95.78	95.72	95.76	5100.0
2014-08-13 06:30:00	QQQ	ETF	95.8	95.92	95.8	95.87	105150.0
2014-08-13 07:00:00	QQQ	ETF	95.85	95.87	95.79	95.79	13700.0
2014-08-13 07:30:00	QQQ	ETF	95.85	95.87	95.85	95.87	11800.0
2014-08-13 08:00:00	QQQ	ETF	95.86	95.92	95.82	95.83	88368.0
2014-08-13 08:30:00	QQQ	ETF	95.79	95.87	95.75	95.76	96634.0
2014-08-13 09:00:00	QQQ	ETF	95.76	95.81	95.68	95.8	156969.0
2014-08-13 09:30:00	QQQ	ETF	95.81	95.979	95.76	95.811	3188230.0
2014-08-13 10:00:00	QQQ	ETF	95.805	96.05	95.8	96.03	2340587.0
2014-08-13 10:30:00	QQQ	ETF	96.035	96.17	96.015	96.155	2933269.0
2014-08-13 11:00:00	QQQ	ETF	96.15	96.34	96.15	96.3006	2761519.0
2014-08-13 11:30:00	QQQ	ETF	96.31	96.41	96.27	96.28	1545216.0
2014-08-13 12:00:00	QQQ	ETF	96.28	96.31	96.17	96.295	1557868.0
2014-08-13 12:30:00	QQQ	ETF	96.295	96.36	96.23	96.2749	1173454.0
2014-08-13 13:00:00	QQQ	ETF	96.2701	96.35	96.26	96.33	544073.0
2014-08-13 13:30:00	QQQ	ETF	96.335	96.45	96.3274	96.405	770388.0

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

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