PREVIEW / etf_30min / 2012-01-09

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-09.parquet
  size:    275 KB
  rows:    9,384

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-01-09 04:00:00	SPY	ETF	127.82	127.9	127.82	127.9	600.0
2012-01-09 04:30:00	SPY	ETF	127.75	127.97	127.75	127.97	450.0
2012-01-09 05:00:00	SPY	ETF	127.78	127.89	127.77	127.89	62000.0
2012-01-09 05:30:00	SPY	ETF	127.8	127.89	127.8	127.89	8000.0
2012-01-09 06:00:00	SPY	ETF	127.76	127.76	127.76	127.76	4000.0
2012-01-09 06:30:00	SPY	ETF	127.9	128.11	127.62	127.62	10300.0
2012-01-09 07:00:00	SPY	ETF	127.85	127.96	127.68	127.88	46026.0
2012-01-09 07:30:00	SPY	ETF	127.83	128.24	127.83	128.02	154650.0
2012-01-09 08:00:00	SPY	ETF	128.02	128.18	127.75	128.08	630792.0
2012-01-09 08:30:00	SPY	ETF	128.08	128.12	127.87	128.12	526474.0
2012-01-09 09:00:00	SPY	ETF	128.13	128.15	127.93	128.0	1051759.0
2012-01-09 09:30:00	SPY	ETF	128.0	128.05	127.66	127.799	13019958.0
2012-01-09 10:00:00	SPY	ETF	127.81	128.14	127.58	128.13	10402627.0
2012-01-09 10:30:00	SPY	ETF	128.12	128.17	127.65	127.74	7387531.0
2012-01-09 11:00:00	SPY	ETF	127.74	127.78	127.41	127.6	9097917.0
2012-01-09 11:30:00	SPY	ETF	127.6	127.8299	127.52	127.71	6624867.0
2012-01-09 12:00:00	SPY	ETF	127.7	127.9	127.62	127.88	4914889.0
2012-01-09 12:30:00	SPY	ETF	127.88	127.93	127.81	127.87	3329758.0
2012-01-09 13:00:00	SPY	ETF	127.87	127.98	127.84	127.96	3739983.0
2012-01-09 13:30:00	SPY	ETF	127.95	128.02	127.83	127.99	3947467.0
2012-01-09 14:00:00	SPY	ETF	127.985	128.1	127.98	128.031	3928345.0
2012-01-09 14:30:00	SPY	ETF	128.04	128.18	127.94	127.98	4211450.0
2012-01-09 15:00:00	SPY	ETF	127.98	128.11	127.94	128.0	4380754.0
2012-01-09 15:30:00	SPY	ETF	128.0	128.18	127.96	128.0	12092446.0
2012-01-09 16:00:00	SPY	ETF	128.0	128.08	127.7536	127.99	6804607.0
2012-01-09 16:30:00	SPY	ETF	127.98	128.02	127.92	127.95	237199.0
2012-01-09 17:00:00	SPY	ETF	127.95	128.01	127.93	128.0	29134.0
2012-01-09 17:30:00	SPY	ETF	128.0	128.05	128.0	128.04	18680.0
2012-01-09 18:00:00	SPY	ETF	128.02	128.04	127.98	128.04	56787.0
2012-01-09 18:30:00	SPY	ETF	128.04	128.17	128.04	128.17	64471.0
2012-01-09 19:00:00	SPY	ETF	128.18	128.34	128.18	128.25	129339.0
2012-01-09 19:30:00	SPY	ETF	128.26	128.28	128.17	128.22	54313.0
2012-01-09 04:30:00	QQQ	ETF	57.9	57.9	57.9	57.9	100.0
2012-01-09 07:00:00	QQQ	ETF	57.86	57.93	57.86	57.89	4958.0
2012-01-09 07:30:00	QQQ	ETF	57.95	58.07	57.92	57.96	28160.0
2012-01-09 08:00:00	QQQ	ETF	57.96	58.02	57.89	57.97	115381.0
2012-01-09 08:30:00	QQQ	ETF	57.98	58.0	57.93	58.0	120051.0
2012-01-09 09:00:00	QQQ	ETF	58.0	58.01	57.91	57.96	113269.0
2012-01-09 09:30:00	QQQ	ETF	57.95	57.98	57.7	57.78	3605017.0
2012-01-09 10:00:00	QQQ	ETF	57.785	57.89	57.7	57.84	2202541.0
2012-01-09 10:30:00	QQQ	ETF	57.85	57.85	57.55	57.625	3045222.0
2012-01-09 11:00:00	QQQ	ETF	57.625	57.625	57.431	57.5781	2955022.0
2012-01-09 11:30:00	QQQ	ETF	57.58	57.71	57.53	57.58	3993405.0
2012-01-09 12:00:00	QQQ	ETF	57.59	57.669	57.51	57.661	2044912.0
2012-01-09 12:30:00	QQQ	ETF	57.65	57.69	57.64	57.66	1728332.0
2012-01-09 13:00:00	QQQ	ETF	57.67	57.72	57.625	57.71	2303220.0
2012-01-09 13:30:00	QQQ	ETF	57.71	57.74	57.64	57.7	1876465.0
2012-01-09 14:00:00	QQQ	ETF	57.7	57.8	57.69	57.76	1715411.0
2012-01-09 14:30:00	QQQ	ETF	57.76	57.83	57.68	57.73	2360524.0
2012-01-09 15:00:00	QQQ	ETF	57.725	57.78	57.67	57.72	1917752.0

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

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