PREVIEW / etf_30min / 2014-11-11

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-11.parquet
  size:    346 KB
  rows:    11,691

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-11-11 04:00:00	SPY	ETF	204.14	204.19	204.03	204.14	7669.0
2014-11-11 04:30:00	SPY	ETF	204.17	204.25	204.15	204.23	20362.0
2014-11-11 05:00:00	SPY	ETF	204.22	204.22	204.13	204.13	11981.0
2014-11-11 05:30:00	SPY	ETF	204.19	204.19	204.08	204.13	4544.0
2014-11-11 06:00:00	SPY	ETF	204.13	204.17	204.08	204.16	33322.0
2014-11-11 06:30:00	SPY	ETF	204.15	204.15	204.08	204.15	57204.0
2014-11-11 07:00:00	SPY	ETF	204.18	204.33	204.13	204.31	62099.0
2014-11-11 07:30:00	SPY	ETF	204.32	204.37	204.28	204.32	26425.0
2014-11-11 08:00:00	SPY	ETF	204.21	204.33	204.16	204.23	168524.0
2014-11-11 08:30:00	SPY	ETF	204.23	204.25	204.11	204.13	166716.0
2014-11-11 09:00:00	SPY	ETF	204.15	204.17	204.03	204.04	439943.0
2014-11-11 09:30:00	SPY	ETF	204.055	204.11	203.65	203.86	7663460.0
2014-11-11 10:00:00	SPY	ETF	203.87	204.18	203.85	204.12	4947553.0
2014-11-11 10:30:00	SPY	ETF	204.1261	204.25	204.05	204.19	3555767.0
2014-11-11 11:00:00	SPY	ETF	204.2	204.31	204.035	204.13	3525946.0
2014-11-11 11:30:00	SPY	ETF	204.12	204.18	203.95	204.0	2338674.0
2014-11-11 12:00:00	SPY	ETF	204.0	204.03	203.83	203.9199	2988655.0
2014-11-11 12:30:00	SPY	ETF	203.915	204.03	203.845	203.894	1989475.0
2014-11-11 13:00:00	SPY	ETF	203.895	203.9	203.7	203.8	3010537.0
2014-11-11 13:30:00	SPY	ETF	203.8	203.91	203.73	203.82	2804075.0
2014-11-11 14:00:00	SPY	ETF	203.83	204.007	203.79	203.955	2529505.0
2014-11-11 14:30:00	SPY	ETF	203.95	203.955	203.79	203.9	1832290.0
2014-11-11 15:00:00	SPY	ETF	203.9	203.95	203.805	203.845	4054726.0
2014-11-11 15:30:00	SPY	ETF	203.84	204.17	203.81	204.17	7503386.0
2014-11-11 16:00:00	SPY	ETF	204.18	204.25	203.9037	204.16	3522678.0
2014-11-11 16:30:00	SPY	ETF	204.15	204.2	204.1	204.16	717264.0
2014-11-11 17:00:00	SPY	ETF	204.16	204.18	204.12	204.12	70103.0
2014-11-11 17:30:00	SPY	ETF	204.13	204.17	204.12	204.16	7700.0
2014-11-11 18:00:00	SPY	ETF	204.14	204.15	204.09	204.1	47216.0
2014-11-11 18:30:00	SPY	ETF	204.11	204.13	204.07	204.08	20349.0
2014-11-11 19:00:00	SPY	ETF	204.07	204.08	204.01	204.04	64595.0
2014-11-11 19:30:00	SPY	ETF	204.04	204.07	204.0	204.02	64268.0
2014-11-11 04:30:00	QQQ	ETF	102.09	102.1	102.09	102.1	900.0
2014-11-11 05:00:00	QQQ	ETF	102.05	102.05	102.05	102.05	1750.0
2014-11-11 06:30:00	QQQ	ETF	102.03	102.04	102.03	102.04	600.0
2014-11-11 07:00:00	QQQ	ETF	102.06	102.13	102.05	102.13	10600.0
2014-11-11 07:30:00	QQQ	ETF	102.13	102.14	102.1	102.1	19005.0
2014-11-11 08:00:00	QQQ	ETF	102.12	102.13	102.03	102.07	25801.0
2014-11-11 08:30:00	QQQ	ETF	102.08	102.08	102.02	102.03	18201.0
2014-11-11 09:00:00	QQQ	ETF	102.04	102.04	101.97	101.97	88195.0
2014-11-11 09:30:00	QQQ	ETF	101.975	102.02	101.7	101.76	2016587.0
2014-11-11 10:00:00	QQQ	ETF	101.77	102.0999	101.77	102.0701	1223582.0
2014-11-11 10:30:00	QQQ	ETF	102.08	102.13	102.06	102.0951	1055655.0
2014-11-11 11:00:00	QQQ	ETF	102.1	102.16	101.97	102.085	1272651.0
2014-11-11 11:30:00	QQQ	ETF	102.089	102.12	101.989	102.02	653545.0
2014-11-11 12:00:00	QQQ	ETF	102.02	102.04	101.94	102.01	454203.0
2014-11-11 12:30:00	QQQ	ETF	102.01	102.08	101.9801	101.99	387184.0
2014-11-11 13:00:00	QQQ	ETF	102.0	102.01	101.83	101.93	537028.0
2014-11-11 13:30:00	QQQ	ETF	101.939	102.0859	101.899	102.05	376887.0
2014-11-11 14:00:00	QQQ	ETF	102.05	102.12	102.0	102.1	617504.0

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

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