PREVIEW / etf_30min / 2013-06-06

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-06.parquet
  size:    333 KB
  rows:    11,052

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-06-06 04:00:00	SPY	ETF	161.9	161.95	161.81	161.81	14800.0
2013-06-06 04:30:00	SPY	ETF	161.87	161.95	161.86	161.89	8700.0
2013-06-06 05:00:00	SPY	ETF	161.95	161.98	161.89	161.92	39500.0
2013-06-06 05:30:00	SPY	ETF	161.92	161.93	161.82	161.82	15715.0
2013-06-06 06:00:00	SPY	ETF	161.81	161.97	161.79	161.9	58280.0
2013-06-06 06:30:00	SPY	ETF	161.95	161.98	161.83	161.87	29506.0
2013-06-06 07:00:00	SPY	ETF	161.9	161.94	161.79	161.84	273002.0
2013-06-06 07:30:00	SPY	ETF	161.84	162.19	161.84	162.09	451478.0
2013-06-06 08:00:00	SPY	ETF	162.12	162.23	161.7	162.04	929416.0
2013-06-06 08:30:00	SPY	ETF	162.02	162.05	161.47	161.62	1450309.0
2013-06-06 09:00:00	SPY	ETF	161.59	161.62	161.1	161.2	2334552.0
2013-06-06 09:30:00	SPY	ETF	161.2	161.82	160.94	161.7081	23439108.0
2013-06-06 10:00:00	SPY	ETF	161.7	161.96	161.1401	161.3999	16834995.0
2013-06-06 10:30:00	SPY	ETF	161.4	161.69	161.14	161.68	11365046.0
2013-06-06 11:00:00	SPY	ETF	161.68	161.7601	161.4	161.53	6416186.0
2013-06-06 11:30:00	SPY	ETF	161.54	161.87	161.11	161.2	9040039.0
2013-06-06 12:00:00	SPY	ETF	161.19	161.28	160.25	160.61	18181308.0
2013-06-06 12:30:00	SPY	ETF	160.61	160.87	160.38	160.57	15633418.0
2013-06-06 13:00:00	SPY	ETF	160.57	161.31	160.56	160.96	13115241.0
2013-06-06 13:30:00	SPY	ETF	160.97	161.54	160.921	161.41	8084951.0
2013-06-06 14:00:00	SPY	ETF	161.41	161.9	161.12	161.9	9321300.0
2013-06-06 14:30:00	SPY	ETF	161.9	162.24	161.64	161.95	9291451.0
2013-06-06 15:00:00	SPY	ETF	161.96	162.24	161.72	162.18	8726361.0
2013-06-06 15:30:00	SPY	ETF	162.18	162.74	162.18	162.7	20669709.0
2013-06-06 16:00:00	SPY	ETF	162.71	162.97	161.3654	162.87	8285386.0
2013-06-06 16:30:00	SPY	ETF	162.89	162.95	162.64	162.89	4997119.0
2013-06-06 17:00:00	SPY	ETF	162.88	162.88	162.75	162.83	7078260.0
2013-06-06 17:30:00	SPY	ETF	162.8	162.84	162.77	162.78	14827.0
2013-06-06 18:00:00	SPY	ETF	162.78	162.81	162.73	162.79	57550.0
2013-06-06 18:30:00	SPY	ETF	162.76	162.8	162.76	162.78	20300.0
2013-06-06 19:00:00	SPY	ETF	162.8	162.82	162.75	162.82	25105.0
2013-06-06 19:30:00	SPY	ETF	162.81	162.82	162.74	162.79	83091.0
2013-06-06 04:00:00	QQQ	ETF	72.3	72.31	72.26	72.26	2800.0
2013-06-06 04:30:00	QQQ	ETF	72.28	72.3	72.28	72.3	800.0
2013-06-06 05:00:00	QQQ	ETF	72.3	72.32	72.29	72.32	600.0
2013-06-06 05:30:00	QQQ	ETF	72.3	72.3	72.28	72.28	800.0
2013-06-06 06:00:00	QQQ	ETF	72.3	72.32	72.28	72.3	2000.0
2013-06-06 06:30:00	QQQ	ETF	72.32	72.32	72.28	72.3	2400.0
2013-06-06 07:00:00	QQQ	ETF	72.3	72.32	72.27	72.29	5000.0
2013-06-06 07:30:00	QQQ	ETF	72.3	72.38	72.3	72.38	7191.0
2013-06-06 08:00:00	QQQ	ETF	72.38	72.43	72.28	72.38	43092.0
2013-06-06 08:30:00	QQQ	ETF	72.4	72.4	72.24	72.27	108930.0
2013-06-06 09:00:00	QQQ	ETF	72.26	72.28	72.13	72.14	65143.0
2013-06-06 09:30:00	QQQ	ETF	72.15	72.39	72.07	72.19	5964486.0
2013-06-06 10:00:00	QQQ	ETF	72.2	72.3	72.0	72.06	3644266.0
2013-06-06 10:30:00	QQQ	ETF	72.07	72.16	71.96	72.13	5234989.0
2013-06-06 11:00:00	QQQ	ETF	72.12	72.15	72.0	72.05	3860037.0
2013-06-06 11:30:00	QQQ	ETF	72.045	72.15	71.83	71.88	3127805.0
2013-06-06 12:00:00	QQQ	ETF	71.88	71.92	71.47	71.6	4530329.0
2013-06-06 12:30:00	QQQ	ETF	71.59	71.72	71.47	71.525	4272929.0

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

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