PREVIEW / etf_30min / 2014-04-14

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-14.parquet
  size:    338 KB
  rows:    11,398

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-04-14 04:00:00	SPY	ETF	181.5	181.65	181.34	181.46	10436.0
2014-04-14 04:30:00	SPY	ETF	181.46	181.53	181.36	181.53	7364.0
2014-04-14 05:00:00	SPY	ETF	181.55	181.55	181.24	181.3	12662.0
2014-04-14 05:30:00	SPY	ETF	181.25	181.45	181.23	181.45	8167.0
2014-04-14 06:00:00	SPY	ETF	181.43	181.65	181.38	181.61	14768.0
2014-04-14 06:30:00	SPY	ETF	181.63	181.8	181.54	181.8	53800.0
2014-04-14 07:00:00	SPY	ETF	181.82	181.91	181.71	181.76	285512.0
2014-04-14 07:30:00	SPY	ETF	181.76	182.18	181.72	182.16	720868.0
2014-04-14 08:00:00	SPY	ETF	181.77	182.5	181.75	182.43	1252478.0
2014-04-14 08:30:00	SPY	ETF	182.43	182.82	182.39	182.61	1900391.0
2014-04-14 09:00:00	SPY	ETF	182.62	182.93	182.6	182.92	797349.0
2014-04-14 09:30:00	SPY	ETF	182.93	183.03	182.19	182.29	15818107.0
2014-04-14 10:00:00	SPY	ETF	182.28	182.71	182.13	182.45	9431330.0
2014-04-14 10:30:00	SPY	ETF	182.45	183.29	182.39	183.25	11004576.0
2014-04-14 11:00:00	SPY	ETF	183.241	183.3	182.86	183.0008	7233078.0
2014-04-14 11:30:00	SPY	ETF	183.0	183.27	182.91	182.94	5942508.0
2014-04-14 12:00:00	SPY	ETF	182.94	183.17	182.84	183.14	3868141.0
2014-04-14 12:30:00	SPY	ETF	183.14	183.37	183.07	183.21	3076147.0
2014-04-14 13:00:00	SPY	ETF	183.21	183.23	182.75	182.77	5086352.0
2014-04-14 13:30:00	SPY	ETF	182.78	183.02	182.63	182.632	5502361.0
2014-04-14 14:00:00	SPY	ETF	182.64	182.9842	182.3	182.3201	5669642.0
2014-04-14 14:30:00	SPY	ETF	182.33	183.04	182.16	182.23	6114743.0
2014-04-14 15:00:00	SPY	ETF	182.23	182.26	181.44	182.0	17947393.0
2014-04-14 15:30:00	SPY	ETF	181.99	183.05	181.985	182.95	20443014.0
2014-04-14 16:00:00	SPY	ETF	182.94	183.07	181.4802	183.03	5241353.0
2014-04-14 16:30:00	SPY	ETF	183.04	183.08	182.0737	183.05	1133510.0
2014-04-14 17:00:00	SPY	ETF	183.04	183.07	183.02	183.07	59167.0
2014-04-14 17:30:00	SPY	ETF	181.4802	183.04	181.4802	183.02	522515.0
2014-04-14 18:00:00	SPY	ETF	183.03	183.15	183.03	183.07	73067.0
2014-04-14 18:30:00	SPY	ETF	183.05	183.06	183.02	183.02	46026.0
2014-04-14 19:00:00	SPY	ETF	183.03	183.11	183.03	183.07	18905.0
2014-04-14 19:30:00	SPY	ETF	183.07	183.1	183.04	183.08	56819.0
2014-04-14 04:00:00	QQQ	ETF	84.09	84.09	83.98	83.98	2100.0
2014-04-14 04:30:00	QQQ	ETF	83.98	84.03	83.98	84.01	1700.0
2014-04-14 05:00:00	QQQ	ETF	83.9	83.9	83.9	83.9	200.0
2014-04-14 05:30:00	QQQ	ETF	83.88	83.88	83.88	83.88	1000.0
2014-04-14 06:00:00	QQQ	ETF	83.98	84.09	83.98	84.09	20100.0
2014-04-14 06:30:00	QQQ	ETF	84.1	84.2	84.08	84.2	28000.0
2014-04-14 07:00:00	QQQ	ETF	84.2	84.25	84.16	84.23	51943.0
2014-04-14 07:30:00	QQQ	ETF	84.25	84.42	84.23	84.42	20500.0
2014-04-14 08:00:00	QQQ	ETF	84.41	84.59	84.17	84.57	88576.0
2014-04-14 08:30:00	QQQ	ETF	84.57	84.76	84.57	84.66	467141.0
2014-04-14 09:00:00	QQQ	ETF	84.66	84.86	84.66	84.84	403074.0
2014-04-14 09:30:00	QQQ	ETF	84.85	84.9	84.3	84.37	6819545.0
2014-04-14 10:00:00	QQQ	ETF	84.36	84.68	84.27	84.46	4121785.0
2014-04-14 10:30:00	QQQ	ETF	84.47	85.17	84.42	85.13	4550541.0
2014-04-14 11:00:00	QQQ	ETF	85.13	85.2	84.99	85.06	2902151.0
2014-04-14 11:30:00	QQQ	ETF	85.06	85.22	84.94	84.96	1472259.0
2014-04-14 12:00:00	QQQ	ETF	84.963	85.08	84.84	85.05	2140531.0
2014-04-14 12:30:00	QQQ	ETF	85.06	85.18	85.0	85.04	1491057.0

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

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