PREVIEW / etf_30min / 2013-05-20

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-20.parquet
  size:    322 KB
  rows:    10,858

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-05-20 04:00:00	SPY	ETF	166.68	166.71	166.67	166.71	3997.0
2013-05-20 05:00:00	SPY	ETF	166.66	166.72	166.65	166.72	29227.0
2013-05-20 05:30:00	SPY	ETF	166.7	166.82	166.69	166.74	56200.0
2013-05-20 06:00:00	SPY	ETF	166.82	166.82	166.74	166.77	11600.0
2013-05-20 06:30:00	SPY	ETF	166.76	166.77	166.73	166.73	9200.0
2013-05-20 07:00:00	SPY	ETF	166.74	166.8	166.72	166.75	16821.0
2013-05-20 07:30:00	SPY	ETF	166.72	166.74	166.64	166.73	112536.0
2013-05-20 08:00:00	SPY	ETF	166.73	166.8	166.55	166.57	220158.0
2013-05-20 08:30:00	SPY	ETF	166.57	166.62	166.48	166.54	259263.0
2013-05-20 09:00:00	SPY	ETF	166.53	166.77	166.51	166.77	391003.0
2013-05-20 09:30:00	SPY	ETF	166.78	167.09	166.72	166.97	13262513.0
2013-05-20 10:00:00	SPY	ETF	166.97	167.18	166.949	167.031	6907788.0
2013-05-20 10:30:00	SPY	ETF	167.0399	167.17	167.0	167.08	5850978.0
2013-05-20 11:00:00	SPY	ETF	167.09	167.3	167.08	167.3	4491724.0
2013-05-20 11:30:00	SPY	ETF	167.31	167.52	167.289	167.47	5871893.0
2013-05-20 12:00:00	SPY	ETF	167.47	167.58	167.34	167.41	4626244.0
2013-05-20 12:30:00	SPY	ETF	167.4185	167.42	167.18	167.23	3082007.0
2013-05-20 13:00:00	SPY	ETF	167.23	167.31	166.87	166.9501	4969789.0
2013-05-20 13:30:00	SPY	ETF	166.96	167.05	166.7	166.93	6060073.0
2013-05-20 14:00:00	SPY	ETF	166.935	167.04	166.61	167.02	5170152.0
2013-05-20 14:30:00	SPY	ETF	167.02	167.1	166.85	166.92	3477879.0
2013-05-20 15:00:00	SPY	ETF	166.92	167.08	166.86	167.015	3965704.0
2013-05-20 15:30:00	SPY	ETF	167.015	167.05	166.76	166.93	11341884.0
2013-05-20 16:00:00	SPY	ETF	166.94	167.025	166.82	166.93	3871310.0
2013-05-20 16:30:00	SPY	ETF	166.92	166.94	166.89	166.89	307773.0
2013-05-20 17:00:00	SPY	ETF	166.9	166.93	166.8644	166.88	266307.0
2013-05-20 17:30:00	SPY	ETF	166.92	166.92	166.88	166.88	18803.0
2013-05-20 18:00:00	SPY	ETF	166.88	166.92	166.83	166.88	25970.0
2013-05-20 18:30:00	SPY	ETF	166.88	166.91	166.86	166.86	13184.0
2013-05-20 19:00:00	SPY	ETF	166.86	166.89	166.83	166.85	8524.0
2013-05-20 19:30:00	SPY	ETF	166.85	166.93	166.85	166.93	18069.0
2013-05-20 04:00:00	QQQ	ETF	74.12	74.12	74.12	74.12	100.0
2013-05-20 04:30:00	QQQ	ETF	74.11	74.13	74.11	74.13	200.0
2013-05-20 05:00:00	QQQ	ETF	74.12	74.12	74.12	74.12	1000.0
2013-05-20 05:30:00	QQQ	ETF	74.13	74.13	74.13	74.13	100.0
2013-05-20 06:00:00	QQQ	ETF	74.18	74.18	74.18	74.18	1000.0
2013-05-20 06:30:00	QQQ	ETF	74.16	74.16	74.16	74.16	400.0
2013-05-20 07:00:00	QQQ	ETF	74.16	74.17	74.14	74.14	1450.0
2013-05-20 07:30:00	QQQ	ETF	74.12	74.13	74.1	74.1	9009.0
2013-05-20 08:00:00	QQQ	ETF	74.15	74.15	74.035	74.035	30393.0
2013-05-20 08:30:00	QQQ	ETF	74.04	74.04	74.0	74.02	52212.0
2013-05-20 09:00:00	QQQ	ETF	74.01	74.09	74.01	74.09	118924.0
2013-05-20 09:30:00	QQQ	ETF	74.09	74.3	74.08	74.27	3442714.0
2013-05-20 10:00:00	QQQ	ETF	74.28	74.4	74.26	74.33	1688861.0
2013-05-20 10:30:00	QQQ	ETF	74.33	74.3551	74.2	74.2422	1526846.0
2013-05-20 11:00:00	QQQ	ETF	74.25	74.37	74.248	74.35	923131.0
2013-05-20 11:30:00	QQQ	ETF	74.35	74.425	74.33	74.39	863555.0
2013-05-20 12:00:00	QQQ	ETF	74.39	74.42	74.23	74.2799	1111495.0
2013-05-20 12:30:00	QQQ	ETF	74.27	74.28	74.13	74.18	1003480.0
2013-05-20 13:00:00	QQQ	ETF	74.18	74.25	74.01	74.035	1490214.0

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

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