PREVIEW / etf_30min / 2014-10-07

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-07.parquet
  size:    360 KB
  rows:    12,113

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-07 04:00:00	SPY	ETF	195.81	195.81	195.23	195.45	2826.0
2014-10-07 04:30:00	SPY	ETF	195.52	195.52	195.0	195.16	5165.0
2014-10-07 05:00:00	SPY	ETF	195.2	195.2	195.15	195.18	7100.0
2014-10-07 05:30:00	SPY	ETF	195.15	195.41	195.06	195.4	37567.0
2014-10-07 06:00:00	SPY	ETF	195.38	195.49	195.37	195.45	24133.0
2014-10-07 06:30:00	SPY	ETF	195.45	195.46	195.3	195.39	25152.0
2014-10-07 07:00:00	SPY	ETF	195.41	195.49	195.34	195.41	298982.0
2014-10-07 07:30:00	SPY	ETF	195.38	195.73	195.3	195.72	318581.0
2014-10-07 08:00:00	SPY	ETF	195.9026	195.92	195.35	195.85	675958.0
2014-10-07 08:30:00	SPY	ETF	195.87	195.89	195.65	195.76	247908.0
2014-10-07 09:00:00	SPY	ETF	195.74	195.79	195.13	195.26	1301533.0
2014-10-07 09:30:00	SPY	ETF	195.28	195.38	194.53	195.02	16354019.0
2014-10-07 10:00:00	SPY	ETF	195.0239	195.39	194.96	195.28	13906876.0
2014-10-07 10:30:00	SPY	ETF	195.29	195.72	195.08	195.12	7937056.0
2014-10-07 11:00:00	SPY	ETF	195.11	195.18	194.62	194.7	7846121.0
2014-10-07 11:30:00	SPY	ETF	194.7	195.2	194.56	195.07	7348028.0
2014-10-07 12:00:00	SPY	ETF	195.08	195.5	195.02	195.33	7218825.0
2014-10-07 12:30:00	SPY	ETF	195.33	195.41	194.86	195.0	3641642.0
2014-10-07 13:00:00	SPY	ETF	195.0	195.32	194.74	195.26	4435640.0
2014-10-07 13:30:00	SPY	ETF	195.27	195.3	194.85	195.06	4338250.0
2014-10-07 14:00:00	SPY	ETF	195.06	195.13	194.45	194.5	6263794.0
2014-10-07 14:30:00	SPY	ETF	194.49	194.49	194.225	194.33	9014154.0
2014-10-07 15:00:00	SPY	ETF	194.32	194.47	193.61	193.93	12575940.0
2014-10-07 15:30:00	SPY	ETF	193.93	194.12	193.25	193.26	25508776.0
2014-10-07 16:00:00	SPY	ETF	193.24	195.2951	193.13	193.25	7960699.0
2014-10-07 16:30:00	SPY	ETF	193.25	196.272	193.03	193.07	6691849.0
2014-10-07 17:00:00	SPY	ETF	193.05	193.14	193.01	193.11	110300.0
2014-10-07 17:30:00	SPY	ETF	193.11	193.14	193.04	193.14	80944.0
2014-10-07 18:00:00	SPY	ETF	193.18	193.24	193.15	193.22	56725.0
2014-10-07 18:30:00	SPY	ETF	193.22	193.23	193.17	193.17	125125.0
2014-10-07 19:00:00	SPY	ETF	193.17	193.26	193.17	193.26	79446.0
2014-10-07 19:30:00	SPY	ETF	193.25	193.4	193.25	193.36	55054.0
2014-10-07 20:00:00	SPY	ETF	193.302	193.302	193.302	193.302	244500.0
2014-10-07 04:00:00	QQQ	ETF	97.61	97.61	97.53	97.53	400.0
2014-10-07 04:30:00	QQQ	ETF	97.59	97.59	97.39	97.45	2500.0
2014-10-07 05:00:00	QQQ	ETF	97.45	97.46	97.44	97.44	8700.0
2014-10-07 05:30:00	QQQ	ETF	97.39	97.39	97.39	97.39	300.0
2014-10-07 06:00:00	QQQ	ETF	97.57	97.63	97.57	97.63	2400.0
2014-10-07 06:30:00	QQQ	ETF	97.58	97.58	97.53	97.55	2140.0
2014-10-07 07:00:00	QQQ	ETF	97.58	97.6	97.57	97.59	18088.0
2014-10-07 07:30:00	QQQ	ETF	97.51	97.74	97.51	97.74	27600.0
2014-10-07 08:00:00	QQQ	ETF	97.72	97.85	97.7	97.8	71022.0
2014-10-07 08:30:00	QQQ	ETF	97.82	97.83	97.7	97.75	61007.0
2014-10-07 09:00:00	QQQ	ETF	97.73	97.79	97.43	97.48	308766.0
2014-10-07 09:30:00	QQQ	ETF	97.485	97.56	97.1	97.3	6821328.0
2014-10-07 10:00:00	QQQ	ETF	97.29	97.575	97.26	97.5701	3836430.0
2014-10-07 10:30:00	QQQ	ETF	97.573	97.7799	97.35	97.36	3123966.0
2014-10-07 11:00:00	QQQ	ETF	97.36	97.39	97.1	97.16	2541204.0
2014-10-07 11:30:00	QQQ	ETF	97.16	97.435	97.08	97.38	2362555.0
2014-10-07 12:00:00	QQQ	ETF	97.38	97.61	97.35	97.521	1400523.0

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

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