PREVIEW / etf_30min / 2013-09-05

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-09-05.parquet
  size:    309 KB
  rows:    10,600

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-09-05 04:00:00	SPY	ETF	166.13	166.13	165.94	165.94	6115.0
2013-09-05 04:30:00	SPY	ETF	165.97	166.02	165.71	165.88	22100.0
2013-09-05 05:00:00	SPY	ETF	165.85	165.93	165.74	165.77	9000.0
2013-09-05 05:30:00	SPY	ETF	165.79	165.79	165.65	165.77	51735.0
2013-09-05 06:00:00	SPY	ETF	165.75	165.91	165.72	165.9	16600.0
2013-09-05 06:30:00	SPY	ETF	165.91	166.02	165.91	165.94	25000.0
2013-09-05 07:00:00	SPY	ETF	165.92	166.02	165.79	165.83	99664.0
2013-09-05 07:30:00	SPY	ETF	165.86	165.95	165.82	165.84	114050.0
2013-09-05 08:00:00	SPY	ETF	165.95	166.02	165.85	165.87	169643.0
2013-09-05 08:30:00	SPY	ETF	165.91	166.17	165.88	165.98	447726.0
2013-09-05 09:00:00	SPY	ETF	165.98	166.03	165.81	165.85	902187.0
2013-09-05 09:30:00	SPY	ETF	165.85	166.4	165.73	166.311	11234809.0
2013-09-05 10:00:00	SPY	ETF	166.31	166.38	166.11	166.26	6165857.0
2013-09-05 10:30:00	SPY	ETF	166.25	166.28	165.86	165.89	6902023.0
2013-09-05 11:00:00	SPY	ETF	165.89	166.08	165.87	165.9799	3841844.0
2013-09-05 11:30:00	SPY	ETF	165.98	166.19	165.98	166.145	2775563.0
2013-09-05 12:00:00	SPY	ETF	166.1423	166.17	165.962	166.02	2510543.0
2013-09-05 12:30:00	SPY	ETF	166.02	166.09	165.96	166.03	1748783.0
2013-09-05 13:00:00	SPY	ETF	166.02	166.12	165.93	166.05	1870987.0
2013-09-05 13:30:00	SPY	ETF	166.06	166.22	165.97	165.98	2893735.0
2013-09-05 14:00:00	SPY	ETF	165.98	166.13	165.94	166.07	1953232.0
2013-09-05 14:30:00	SPY	ETF	166.07	166.26	166.05	166.17	2638631.0
2013-09-05 15:00:00	SPY	ETF	166.1699	166.19	166.01	166.06	3815220.0
2013-09-05 15:30:00	SPY	ETF	166.06	166.08	165.87	165.915	7856863.0
2013-09-05 16:00:00	SPY	ETF	165.92	166.04	165.84	165.93	1945600.0
2013-09-05 16:30:00	SPY	ETF	165.93	165.93	165.83	165.85	192893.0
2013-09-05 17:00:00	SPY	ETF	165.85	165.86	165.76	165.84	2012249.0
2013-09-05 17:30:00	SPY	ETF	165.83	165.86	165.83	165.84	92264.0
2013-09-05 18:00:00	SPY	ETF	165.83	166.0812	165.82	165.9	115395.0
2013-09-05 18:30:00	SPY	ETF	165.92	165.97	165.92	165.95	11035.0
2013-09-05 19:00:00	SPY	ETF	165.94	165.95	165.93	165.94	3109.0
2013-09-05 19:30:00	SPY	ETF	165.95	165.98	165.94	165.98	13125.0
2013-09-05 04:00:00	QQQ	ETF	76.94	76.94	76.89	76.89	11100.0
2013-09-05 04:30:00	QQQ	ETF	76.91	76.91	76.75	76.83	18700.0
2013-09-05 05:00:00	QQQ	ETF	76.85	76.87	76.79	76.79	7200.0
2013-09-05 05:30:00	QQQ	ETF	76.77	76.79	76.75	76.79	7700.0
2013-09-05 06:00:00	QQQ	ETF	76.81	76.87	76.79	76.85	8400.0
2013-09-05 06:30:00	QQQ	ETF	76.87	76.93	76.87	76.88	5800.0
2013-09-05 07:00:00	QQQ	ETF	76.86	76.88	76.81	76.85	48435.0
2013-09-05 07:30:00	QQQ	ETF	76.83	76.89	76.83	76.85	16720.0
2013-09-05 08:00:00	QQQ	ETF	76.87	76.92	76.87	76.88	141365.0
2013-09-05 08:30:00	QQQ	ETF	76.89	76.98	76.81	76.85	121924.0
2013-09-05 09:00:00	QQQ	ETF	76.85	76.86	76.71	76.74	159488.0
2013-09-05 09:30:00	QQQ	ETF	76.75	77.055	76.73	76.96	2778914.0
2013-09-05 10:00:00	QQQ	ETF	76.95	77.005	76.8001	76.96	1653060.0
2013-09-05 10:30:00	QQQ	ETF	76.95	76.97	76.74	76.76	1207703.0
2013-09-05 11:00:00	QQQ	ETF	76.765	76.88	76.75	76.8214	865606.0
2013-09-05 11:30:00	QQQ	ETF	76.83	76.94	76.8214	76.91	876084.0
2013-09-05 12:00:00	QQQ	ETF	76.9	76.92	76.76	76.77	630999.0
2013-09-05 12:30:00	QQQ	ETF	76.77	76.83	76.75	76.8	354700.0

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

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