PREVIEW / etf_30min / 2013-07-01

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-01.parquet
  size:    325 KB
  rows:    10,994

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
2013-07-01 04:00:00	SPY	ETF	161.2	161.26	160.68	160.7	16113.0
2013-07-01 04:30:00	SPY	ETF	160.7	160.86	160.7	160.7	4600.0
2013-07-01 05:00:00	SPY	ETF	160.74	161.08	160.7	161.08	25200.0
2013-07-01 05:30:00	SPY	ETF	161.1	161.35	161.1	161.31	83949.0
2013-07-01 06:00:00	SPY	ETF	161.31	161.38	161.05	161.07	40345.0
2013-07-01 06:30:00	SPY	ETF	161.1	161.17	160.98	161.06	26200.0
2013-07-01 07:00:00	SPY	ETF	161.03	161.15	160.96	161.01	95860.0
2013-07-01 07:30:00	SPY	ETF	161.06	161.22	161.05	161.1	127779.0
2013-07-01 08:00:00	SPY	ETF	161.06	161.24	160.05	161.08	596224.0
2013-07-01 08:30:00	SPY	ETF	161.07	161.15	160.42	161.05	251256.0
2013-07-01 09:00:00	SPY	ETF	161.05	161.31	161.02	161.26	673300.0
2013-07-01 09:30:00	SPY	ETF	161.26	161.97	161.16	161.85	18691697.0
2013-07-01 10:00:00	SPY	ETF	161.88	162.44	161.8	162.2	14108561.0
2013-07-01 10:30:00	SPY	ETF	162.2	162.29	162.02	162.0999	7503700.0
2013-07-01 11:00:00	SPY	ETF	162.1	162.39	162.08	162.27	5365614.0
2013-07-01 11:30:00	SPY	ETF	162.27	162.41	162.135	162.37	6246365.0
2013-07-01 12:00:00	SPY	ETF	162.38	162.48	162.08	162.12	6121256.0
2013-07-01 12:30:00	SPY	ETF	162.12	162.3	162.07	162.17	4051121.0
2013-07-01 13:00:00	SPY	ETF	162.17	162.27	162.06	162.2	4966283.0
2013-07-01 13:30:00	SPY	ETF	162.19	162.23	161.7	161.705	6424972.0
2013-07-01 14:00:00	SPY	ETF	161.7	161.92	161.51	161.7285	6960626.0
2013-07-01 14:30:00	SPY	ETF	161.72	161.92	161.56	161.83	5539433.0
2013-07-01 15:00:00	SPY	ETF	161.83	161.985	161.5	161.52	8665610.0
2013-07-01 15:30:00	SPY	ETF	161.51	161.88	161.08	161.35	20677592.0
2013-07-01 16:00:00	SPY	ETF	161.34	161.9497	161.07	161.11	3651996.0
2013-07-01 16:30:00	SPY	ETF	161.1	161.3124	161.03	161.11	1177607.0
2013-07-01 17:00:00	SPY	ETF	161.11	161.16	161.1	161.1	1082874.0
2013-07-01 17:30:00	SPY	ETF	161.1	161.16	161.08	161.1	30610.0
2013-07-01 18:00:00	SPY	ETF	161.1	161.21	161.1	161.1	54243.0
2013-07-01 18:30:00	SPY	ETF	161.1	161.24	161.1	161.22	28176.0
2013-07-01 19:00:00	SPY	ETF	161.19	161.21	161.17	161.2	10576.0
2013-07-01 19:30:00	SPY	ETF	161.2	161.25	161.15	161.2	203673.0
2013-07-01 04:00:00	QQQ	ETF	71.67	71.67	71.45	71.48	18400.0
2013-07-01 04:30:00	QQQ	ETF	71.51	71.52	71.48	71.48	3522.0
2013-07-01 05:00:00	QQQ	ETF	71.51	71.66	71.48	71.66	9600.0
2013-07-01 05:30:00	QQQ	ETF	71.69	71.79	71.69	71.77	3800.0
2013-07-01 06:00:00	QQQ	ETF	71.75	71.75	71.63	71.63	4000.0
2013-07-01 06:30:00	QQQ	ETF	71.62	71.65	71.6	71.64	2400.0
2013-07-01 07:00:00	QQQ	ETF	71.6	71.6	71.58	71.6	8950.0
2013-07-01 07:30:00	QQQ	ETF	71.63	71.69	71.63	71.64	7850.0
2013-07-01 08:00:00	QQQ	ETF	71.64	71.78	71.62	71.69	27088.0
2013-07-01 08:30:00	QQQ	ETF	71.69	71.72	71.62	71.65	19805.0
2013-07-01 09:00:00	QQQ	ETF	71.63	71.77	71.63	71.75	51797.0
2013-07-01 09:30:00	QQQ	ETF	71.75	72.14	71.74	72.11	5150895.0
2013-07-01 10:00:00	QQQ	ETF	72.12	72.3	72.1	72.1835	2931611.0
2013-07-01 10:30:00	QQQ	ETF	72.19	72.22	72.08	72.09	1736303.0
2013-07-01 11:00:00	QQQ	ETF	72.09	72.16	72.06	72.12	995088.0
2013-07-01 11:30:00	QQQ	ETF	72.1131	72.21	72.07	72.1917	974455.0
2013-07-01 12:00:00	QQQ	ETF	72.191	72.22	71.99	72.01	1064413.0
2013-07-01 12:30:00	QQQ	ETF	72.0101	72.1	71.98	72.04	1031098.0

> showing 50 of 10,994 rows — these rows as CSV

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