PREVIEW / etf_30min / 2014-09-18

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-18.parquet
  size:    338 KB
  rows:    11,629

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-09-18 04:00:00	SPY	ETF	200.48	201.16	200.48	201.16	8581.0
2014-09-18 04:30:00	SPY	ETF	201.14	201.21	201.14	201.16	659.0
2014-09-18 05:00:00	SPY	ETF	201.32	201.33	201.21	201.21	2167.0
2014-09-18 05:30:00	SPY	ETF	201.27	201.58	201.27	201.55	4129.0
2014-09-18 06:00:00	SPY	ETF	201.5	201.55	201.42	201.54	26557.0
2014-09-18 06:30:00	SPY	ETF	201.5	201.7	201.45	201.55	157248.0
2014-09-18 07:00:00	SPY	ETF	201.48	201.64	201.48	201.53	155922.0
2014-09-18 07:30:00	SPY	ETF	201.53	201.57	201.37	201.37	193033.0
2014-09-18 08:00:00	SPY	ETF	201.37	201.56	201.32	201.4	310300.0
2014-09-18 08:30:00	SPY	ETF	201.4	201.43	201.22	201.3	530164.0
2014-09-18 09:00:00	SPY	ETF	201.3	201.5	201.3	201.35	529797.0
2014-09-18 09:30:00	SPY	ETF	201.36	201.51	201.1	201.45	9532651.0
2014-09-18 10:00:00	SPY	ETF	201.445	201.69	201.23	201.2747	7550035.0
2014-09-18 10:30:00	SPY	ETF	201.27	201.8	201.24	201.57	6364953.0
2014-09-18 11:00:00	SPY	ETF	201.56	201.67	201.48	201.58	5896932.0
2014-09-18 11:30:00	SPY	ETF	201.58	201.73	201.37	201.45	4214070.0
2014-09-18 12:00:00	SPY	ETF	201.46	201.61	201.4599	201.58	2739266.0
2014-09-18 12:30:00	SPY	ETF	201.58	201.665	201.51	201.6027	1945660.0
2014-09-18 13:00:00	SPY	ETF	201.6	201.66	201.495	201.55	3917831.0
2014-09-18 13:30:00	SPY	ETF	201.56	201.61	201.44	201.51	3142966.0
2014-09-18 14:00:00	SPY	ETF	201.52	201.71	201.48	201.52	4436293.0
2014-09-18 14:30:00	SPY	ETF	201.53	201.63	201.47	201.49	3537971.0
2014-09-18 15:00:00	SPY	ETF	201.49	201.74	201.45	201.72	6063454.0
2014-09-18 15:30:00	SPY	ETF	201.72	201.85	201.685	201.77	14719804.0
2014-09-18 16:00:00	SPY	ETF	201.78	201.9	201.4114	201.86	5494374.0
2014-09-18 16:30:00	SPY	ETF	201.87	202.05	201.4716	201.99	2918980.0
2014-09-18 17:00:00	SPY	ETF	201.99	202.08	201.92	202.03	1155293.0
2014-09-18 17:30:00	SPY	ETF	202.02	202.03	201.96	201.96	59292.0
2014-09-18 18:00:00	SPY	ETF	201.96	202.16	201.9	202.1	235298.0
2014-09-18 18:30:00	SPY	ETF	202.1	202.27	202.08	202.18	147836.0
2014-09-18 19:00:00	SPY	ETF	202.16	202.22	202.16	202.18	90567.0
2014-09-18 19:30:00	SPY	ETF	202.14	202.14	202.08	202.1	52545.0
2014-09-18 04:00:00	QQQ	ETF	99.65	99.65	99.64	99.65	2900.0
2014-09-18 04:30:00	QQQ	ETF	99.74	99.74	99.74	99.74	100.0
2014-09-18 05:30:00	QQQ	ETF	99.9	99.9	99.9	99.9	500.0
2014-09-18 06:00:00	QQQ	ETF	99.89	99.94	99.89	99.92	22900.0
2014-09-18 06:30:00	QQQ	ETF	99.91	99.99	99.89	99.94	10107.0
2014-09-18 07:00:00	QQQ	ETF	99.91	99.98	99.91	99.92	28300.0
2014-09-18 07:30:00	QQQ	ETF	99.96	99.97	99.87	99.87	21800.0
2014-09-18 08:00:00	QQQ	ETF	99.85	99.89	99.84	99.85	31723.0
2014-09-18 08:30:00	QQQ	ETF	99.85	99.89	99.8	99.86	84124.0
2014-09-18 09:00:00	QQQ	ETF	99.85	99.94	99.82	99.82	264531.0
2014-09-18 09:30:00	QQQ	ETF	99.83	100.02	99.73	99.99	3940720.0
2014-09-18 10:00:00	QQQ	ETF	99.991	100.13	99.951	100.0	2999775.0
2014-09-18 10:30:00	QQQ	ETF	100.0	100.2	99.98	100.05	2067133.0
2014-09-18 11:00:00	QQQ	ETF	100.04	100.1	99.99	100.03	1041125.0
2014-09-18 11:30:00	QQQ	ETF	100.03	100.08	99.95	99.98	907624.0
2014-09-18 12:00:00	QQQ	ETF	99.98	100.0895	99.97	100.0632	1139012.0
2014-09-18 12:30:00	QQQ	ETF	100.0601	100.16	100.05	100.1232	790065.0
2014-09-18 13:00:00	QQQ	ETF	100.1206	100.185	100.1	100.13	864761.0

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

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