PREVIEW / etf_30min / 2014-12-26

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-26.parquet
  size:    340 KB
  rows:    11,851

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-12-26 05:00:00	SPY	ETF	208.15	208.16	208.15	208.16	3600.0
2014-12-26 05:30:00	SPY	ETF	208.17	208.17	208.17	208.17	8800.0
2014-12-26 06:00:00	SPY	ETF	208.15	208.15	208.15	208.15	300.0
2014-12-26 06:30:00	SPY	ETF	208.14	208.14	208.14	208.14	100.0
2014-12-26 07:00:00	SPY	ETF	208.13	208.14	208.02	208.13	11200.0
2014-12-26 07:30:00	SPY	ETF	208.14	208.21	208.14	208.2	32285.0
2014-12-26 08:00:00	SPY	ETF	208.18	208.27	208.16	208.27	45056.0
2014-12-26 08:30:00	SPY	ETF	208.27	208.3	208.19	208.28	115012.0
2014-12-26 09:00:00	SPY	ETF	208.27	208.33	208.24	208.3	221726.0
2014-12-26 09:30:00	SPY	ETF	208.31	208.73	208.25	208.66	6659749.0
2014-12-26 10:00:00	SPY	ETF	208.65	208.7463	208.52	208.56	4570574.0
2014-12-26 10:30:00	SPY	ETF	208.55	208.66	208.48	208.64	3073772.0
2014-12-26 11:00:00	SPY	ETF	208.64	208.7	208.57	208.58	2668506.0
2014-12-26 11:30:00	SPY	ETF	208.59	208.65	208.55	208.6	2935186.0
2014-12-26 12:00:00	SPY	ETF	208.605	208.61	208.43	208.53	2040580.0
2014-12-26 12:30:00	SPY	ETF	208.53	208.63	208.51	208.61	1937782.0
2014-12-26 13:00:00	SPY	ETF	208.6199	208.75	208.59	208.69	2569639.0
2014-12-26 13:30:00	SPY	ETF	208.69	208.77	208.65	208.73	2204482.0
2014-12-26 14:00:00	SPY	ETF	208.7386	208.85	208.69	208.705	3074244.0
2014-12-26 14:30:00	SPY	ETF	208.7	208.81	208.69	208.8	2530700.0
2014-12-26 15:00:00	SPY	ETF	208.804	208.84	208.715	208.73	3199446.0
2014-12-26 15:30:00	SPY	ETF	208.731	208.74	208.39	208.42	9065023.0
2014-12-26 16:00:00	SPY	ETF	208.41	208.6061	208.32	208.5	5035063.0
2014-12-26 16:30:00	SPY	ETF	208.5	208.55	208.44	208.5	4417325.0
2014-12-26 17:00:00	SPY	ETF	208.5	208.5	208.41	208.41	21808.0
2014-12-26 17:30:00	SPY	ETF	208.48	208.49	208.44	208.48	16064.0
2014-12-26 18:00:00	SPY	ETF	208.49	208.53	208.49	208.52	105709.0
2014-12-26 18:30:00	SPY	ETF	208.54	208.54	208.5	208.5	1725.0
2014-12-26 19:00:00	SPY	ETF	208.52	208.52	208.52	208.52	435.0
2014-12-26 19:30:00	SPY	ETF	208.53	208.58	208.52	208.58	6054.0
2014-12-26 05:00:00	QQQ	ETF	104.55	104.55	104.55	104.55	9100.0
2014-12-26 06:00:00	QQQ	ETF	104.55	104.55	104.55	104.55	800.0
2014-12-26 07:00:00	QQQ	ETF	104.55	104.55	104.55	104.55	200.0
2014-12-26 07:30:00	QQQ	ETF	104.53	104.58	104.53	104.58	5850.0
2014-12-26 08:00:00	QQQ	ETF	104.54	104.58	104.5	104.58	6201.0
2014-12-26 08:30:00	QQQ	ETF	104.58	104.61	104.57	104.61	84498.0
2014-12-26 09:00:00	QQQ	ETF	104.61	104.63	104.54	104.56	63478.0
2014-12-26 09:30:00	QQQ	ETF	104.6	104.85	104.57	104.76	2070651.0
2014-12-26 10:00:00	QQQ	ETF	104.76	104.85	104.73	104.74	1117921.0
2014-12-26 10:30:00	QQQ	ETF	104.75	104.87	104.741	104.85	605333.0
2014-12-26 11:00:00	QQQ	ETF	104.8563	104.9	104.81	104.84	453670.0
2014-12-26 11:30:00	QQQ	ETF	104.84	104.94	104.83	104.87	718683.0
2014-12-26 12:00:00	QQQ	ETF	104.88	104.95	104.8	104.9	606963.0
2014-12-26 12:30:00	QQQ	ETF	104.905	105.01	104.891	105.0002	377711.0
2014-12-26 13:00:00	QQQ	ETF	105.0	105.179	105.0	105.12	995623.0
2014-12-26 13:30:00	QQQ	ETF	105.12	105.19	105.1	105.17	583519.0
2014-12-26 14:00:00	QQQ	ETF	105.16	105.245	105.16	105.21	673438.0
2014-12-26 14:30:00	QQQ	ETF	105.21	105.245	105.17	105.23	636863.0
2014-12-26 15:00:00	QQQ	ETF	105.22	105.26	105.185	105.241	868921.0
2014-12-26 15:30:00	QQQ	ETF	105.24	105.25	105.0	105.05	2088612.0

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

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