PREVIEW / etf_30min / 2014-04-04

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-04.parquet
  size:    352 KB
  rows:    11,740

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-04 04:00:00	SPY	ETF	189.05	189.11	189.01	189.09	17645.0
2014-04-04 04:30:00	SPY	ETF	189.1	189.13	189.05	189.13	4918.0
2014-04-04 05:00:00	SPY	ETF	189.12	189.15	189.12	189.14	4061.0
2014-04-04 05:30:00	SPY	ETF	189.15	189.2	189.15	189.15	8176.0
2014-04-04 06:00:00	SPY	ETF	189.17	189.2	189.12	189.12	33500.0
2014-04-04 06:30:00	SPY	ETF	189.09	189.1	189.04	189.09	43112.0
2014-04-04 07:00:00	SPY	ETF	189.07	189.18	189.04	189.15	122153.0
2014-04-04 07:30:00	SPY	ETF	189.15	189.21	189.14	189.16	136685.0
2014-04-04 08:00:00	SPY	ETF	189.15	189.3	189.0	189.19	849273.0
2014-04-04 08:30:00	SPY	ETF	189.12	189.68	188.72	189.54	2823282.0
2014-04-04 09:00:00	SPY	ETF	189.54	189.74	189.48	189.63	1266990.0
2014-04-04 09:30:00	SPY	ETF	189.64	189.7	188.66	188.98	17744160.0
2014-04-04 10:00:00	SPY	ETF	188.98	189.55	188.97	189.28	10853809.0
2014-04-04 10:30:00	SPY	ETF	189.271	189.54	189.0	189.05	10267822.0
2014-04-04 11:00:00	SPY	ETF	189.045	189.06	188.22	188.34	10424781.0
2014-04-04 11:30:00	SPY	ETF	188.33	188.57	187.72	188.0201	14669506.0
2014-04-04 12:00:00	SPY	ETF	188.03	188.045	187.27	187.59	12025412.0
2014-04-04 12:30:00	SPY	ETF	187.59	187.77	187.02	187.17	7004749.0
2014-04-04 13:00:00	SPY	ETF	187.18	187.49	186.95	187.13	7447998.0
2014-04-04 13:30:00	SPY	ETF	187.13	189.25	186.86	186.965	8849878.0
2014-04-04 14:00:00	SPY	ETF	186.96	187.1	186.62	186.65	9125545.0
2014-04-04 14:30:00	SPY	ETF	186.66	186.755	186.1	186.585	11519586.0
2014-04-04 15:00:00	SPY	ETF	186.58	186.89	186.2	186.77	10865962.0
2014-04-04 15:30:00	SPY	ETF	186.75	186.79	186.32	186.39	18051567.0
2014-04-04 16:00:00	SPY	ETF	186.41	188.6791	186.31	186.63	8632796.0
2014-04-04 16:30:00	SPY	ETF	186.62	189.0458	186.3628	186.69	1650212.0
2014-04-04 17:00:00	SPY	ETF	186.68	186.72	186.6	186.63	129076.0
2014-04-04 17:30:00	SPY	ETF	186.68	186.7	186.52	186.53	164678.0
2014-04-04 18:00:00	SPY	ETF	186.57	186.57	186.36	186.47	138034.0
2014-04-04 18:30:00	SPY	ETF	186.46	186.47	186.4	186.47	14664.0
2014-04-04 19:00:00	SPY	ETF	186.47	186.53	186.45	186.52	55169.0
2014-04-04 19:30:00	SPY	ETF	186.49	186.59	186.48	186.59	37251.0
2014-04-04 05:00:00	QQQ	ETF	88.94	88.95	88.94	88.95	500.0
2014-04-04 05:30:00	QQQ	ETF	88.98	88.98	88.97	88.97	2500.0
2014-04-04 06:30:00	QQQ	ETF	88.94	88.96	88.94	88.96	3025.0
2014-04-04 07:00:00	QQQ	ETF	88.97	89.03	88.97	89.0	23100.0
2014-04-04 07:30:00	QQQ	ETF	89.02	89.04	89.01	89.02	16300.0
2014-04-04 08:00:00	QQQ	ETF	89.02	89.08	88.98	89.05	234762.0
2014-04-04 08:30:00	QQQ	ETF	88.98	89.3	88.95	89.2	673272.0
2014-04-04 09:00:00	QQQ	ETF	89.19	89.3	89.14	89.29	227240.0
2014-04-04 09:30:00	QQQ	ETF	89.29	89.41	88.02	88.35	12237096.0
2014-04-04 10:00:00	QQQ	ETF	88.35	88.84	88.06	88.4	7835787.0
2014-04-04 10:30:00	QQQ	ETF	88.405	88.55	87.85	87.87	6518341.0
2014-04-04 11:00:00	QQQ	ETF	87.88	87.89	87.24	87.35	7229058.0
2014-04-04 11:30:00	QQQ	ETF	87.36	87.52	86.95	87.1499	6675143.0
2014-04-04 12:00:00	QQQ	ETF	87.14	87.15	86.58	86.92	9611321.0
2014-04-04 12:30:00	QQQ	ETF	86.92	87.02	86.5	86.62	4363134.0
2014-04-04 13:00:00	QQQ	ETF	86.6196	86.88	86.46	86.68	4818030.0
2014-04-04 13:30:00	QQQ	ETF	86.68	86.75	86.52	86.62	3397645.0
2014-04-04 14:00:00	QQQ	ETF	86.62	86.75	86.42	86.47	4804230.0

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

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