PREVIEW / etf_30min / 2012-08-30

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-30.parquet
  size:    270 KB
  rows:    9,217

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
2012-08-30 04:00:00	SPY	ETF	141.02	141.11	141.0	141.0	5900.0
2012-08-30 04:30:00	SPY	ETF	140.96	140.97	140.96	140.97	3600.0
2012-08-30 05:00:00	SPY	ETF	141.08	141.08	141.08	141.08	100.0
2012-08-30 05:30:00	SPY	ETF	141.01	141.01	141.0	141.0	512.0
2012-08-30 06:00:00	SPY	ETF	140.99	140.99	140.83	140.87	76662.0
2012-08-30 06:30:00	SPY	ETF	140.86	140.89	140.82	140.83	8200.0
2012-08-30 07:00:00	SPY	ETF	140.82	140.91	140.8	140.86	106383.0
2012-08-30 07:30:00	SPY	ETF	140.84	140.91	140.82	140.84	106856.0
2012-08-30 08:00:00	SPY	ETF	140.84	141.02	140.8	141.02	245703.0
2012-08-30 08:30:00	SPY	ETF	141.01	141.03	140.79	140.8	548843.0
2012-08-30 09:00:00	SPY	ETF	140.8	140.91	140.77	140.89	562754.0
2012-08-30 09:30:00	SPY	ETF	140.9	140.94	140.64	140.72	12169137.0
2012-08-30 10:00:00	SPY	ETF	140.72	140.83	140.36	140.45	11401385.0
2012-08-30 10:30:00	SPY	ETF	140.44	140.5	140.19	140.39	10397432.0
2012-08-30 11:00:00	SPY	ETF	140.38	140.64	140.35	140.63	7330443.0
2012-08-30 11:30:00	SPY	ETF	140.63	140.64	140.48	140.49	6410102.0
2012-08-30 12:00:00	SPY	ETF	140.5	140.5	140.36	140.385	3522491.0
2012-08-30 12:30:00	SPY	ETF	140.39	140.6	140.38	140.58	4696699.0
2012-08-30 13:00:00	SPY	ETF	140.57	140.6	140.37	140.46	2488450.0
2012-08-30 13:30:00	SPY	ETF	140.4687	140.56	140.42	140.55	2147455.0
2012-08-30 14:00:00	SPY	ETF	140.56	140.7	140.52	140.57	3477825.0
2012-08-30 14:30:00	SPY	ETF	140.58	140.71	140.52	140.699	3135063.0
2012-08-30 15:00:00	SPY	ETF	140.7	140.78	140.65	140.74	4056755.0
2012-08-30 15:30:00	SPY	ETF	140.74	140.89	140.44	140.47	15838983.0
2012-08-30 16:00:00	SPY	ETF	140.48	140.5602	140.29	140.36	7194129.0
2012-08-30 16:30:00	SPY	ETF	140.36	140.36	140.22	140.3	285106.0
2012-08-30 17:00:00	SPY	ETF	140.3	140.35	140.3	140.31	16660.0
2012-08-30 17:30:00	SPY	ETF	140.31	140.33	140.26	140.28	33151.0
2012-08-30 18:00:00	SPY	ETF	140.31	140.34	140.28	140.3	57593.0
2012-08-30 18:30:00	SPY	ETF	140.31	140.31	140.23	140.23	22948.0
2012-08-30 19:00:00	SPY	ETF	140.26	140.3	140.26	140.27	5386.0
2012-08-30 19:30:00	SPY	ETF	140.28	140.29	140.22	140.29	34966.0
2012-08-30 04:00:00	QQQ	ETF	68.18	68.2	68.18	68.2	300.0
2012-08-30 06:00:00	QQQ	ETF	68.19	68.19	68.11	68.11	200.0
2012-08-30 06:30:00	QQQ	ETF	68.07	68.07	68.07	68.07	1000.0
2012-08-30 07:00:00	QQQ	ETF	68.11	68.11	68.06	68.06	950.0
2012-08-30 07:30:00	QQQ	ETF	68.13	68.13	68.09	68.09	900.0
2012-08-30 08:00:00	QQQ	ETF	68.08	68.14	68.05	68.14	54770.0
2012-08-30 08:30:00	QQQ	ETF	68.12	68.35	68.04	68.1	49377.0
2012-08-30 09:00:00	QQQ	ETF	68.1	68.16	68.1	68.11	102518.0
2012-08-30 09:30:00	QQQ	ETF	68.11	68.13	67.94	67.98	4595159.0
2012-08-30 10:00:00	QQQ	ETF	67.97	68.01	67.75	67.78	2794236.0
2012-08-30 10:30:00	QQQ	ETF	67.79	67.8	67.6	67.71	2490488.0
2012-08-30 11:00:00	QQQ	ETF	67.72	67.845	67.71	67.835	1670145.0
2012-08-30 11:30:00	QQQ	ETF	67.84	67.84	67.74	67.755	1180894.0
2012-08-30 12:00:00	QQQ	ETF	67.74	67.76	67.66	67.66	550686.0
2012-08-30 12:30:00	QQQ	ETF	67.67	67.77	67.67	67.74	461128.0
2012-08-30 13:00:00	QQQ	ETF	67.74	67.745	67.61	67.6699	1004154.0
2012-08-30 13:30:00	QQQ	ETF	67.67	67.7484	67.65	67.735	699621.0
2012-08-30 14:00:00	QQQ	ETF	67.74	67.84	67.728	67.78	1285186.0

> showing 50 of 9,217 rows — these rows as CSV

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