PREVIEW / etf_30min / 2010-08-09

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-09.parquet
  size:    241 KB
  rows:    8,144

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
2010-08-09 04:00:00	SPY	ETF	112.71	112.87	112.71	112.8	1700.0
2010-08-09 04:30:00	SPY	ETF	112.9	112.9	112.85	112.9	1200.0
2010-08-09 05:00:00	SPY	ETF	112.91	112.91	112.91	112.91	600.0
2010-08-09 06:00:00	SPY	ETF	112.88	112.88	112.84	112.87	800.0
2010-08-09 06:30:00	SPY	ETF	112.84	112.89	112.83	112.89	25625.0
2010-08-09 07:00:00	SPY	ETF	112.87	112.92	112.8	112.85	297000.0
2010-08-09 07:30:00	SPY	ETF	112.85	113.01	112.82	112.97	368742.0
2010-08-09 08:00:00	SPY	ETF	112.97	113.05	112.92	112.98	526551.0
2010-08-09 08:30:00	SPY	ETF	112.98	113.0	112.91	112.93	373842.0
2010-08-09 09:00:00	SPY	ETF	112.94	112.98	112.83	112.92	802555.0
2010-08-09 09:30:00	SPY	ETF	112.92	112.95	112.32	112.47	17931946.0
2010-08-09 10:00:00	SPY	ETF	112.47	112.68	112.4	112.45	9958960.0
2010-08-09 10:30:00	SPY	ETF	112.45	112.75	112.45	112.71	6466355.0
2010-08-09 11:00:00	SPY	ETF	112.72	112.84	112.66	112.78	6426643.0
2010-08-09 11:30:00	SPY	ETF	112.77	112.96	112.77	112.82	7464963.0
2010-08-09 12:00:00	SPY	ETF	112.81	112.92	112.75	112.8	3174687.0
2010-08-09 12:30:00	SPY	ETF	112.81	112.85	112.72	112.78	2774690.0
2010-08-09 13:00:00	SPY	ETF	112.79	112.9	112.76	112.77	2809189.0
2010-08-09 13:30:00	SPY	ETF	112.77	112.92	112.72	112.84	3683788.0
2010-08-09 14:00:00	SPY	ETF	112.83	112.92	112.83	112.89	2455673.0
2010-08-09 14:30:00	SPY	ETF	112.89	113.18	112.88	113.18	8630673.0
2010-08-09 15:00:00	SPY	ETF	113.18	113.18	112.89	112.9801	7182745.0
2010-08-09 15:30:00	SPY	ETF	112.98	113.17	112.93	112.9801	14639687.0
2010-08-09 16:00:00	SPY	ETF	112.99	113.09	112.325	113.03	5602839.0
2010-08-09 16:30:00	SPY	ETF	113.04	113.06	113.01	113.04	69083.0
2010-08-09 17:00:00	SPY	ETF	113.04	113.05	113.0	113.04	106473.0
2010-08-09 17:30:00	SPY	ETF	113.03	113.1	113.01	113.04	265617.0
2010-08-09 18:00:00	SPY	ETF	113.05	113.07	113.01	113.07	47260.0
2010-08-09 18:30:00	SPY	ETF	113.06	113.08	113.05	113.08	4665.0
2010-08-09 19:00:00	SPY	ETF	113.08	113.09	113.0	113.03	14590.0
2010-08-09 19:30:00	SPY	ETF	113.01	113.04	113.0	113.0	22303.0
2010-08-09 04:30:00	QQQ	ETF	46.94	46.94	46.93	46.93	3000.0
2010-08-09 05:30:00	QQQ	ETF	46.97	46.97	46.97	46.97	100.0
2010-08-09 06:00:00	QQQ	ETF	46.96	46.97	46.96	46.97	600.0
2010-08-09 07:00:00	QQQ	ETF	46.95	47.0	46.94	46.94	19508.0
2010-08-09 07:30:00	QQQ	ETF	46.96	47.0	46.95	47.0	28084.0
2010-08-09 08:00:00	QQQ	ETF	47.0	47.0	46.96	46.98	53184.0
2010-08-09 08:30:00	QQQ	ETF	46.99	47.0	46.96	46.97	89668.0
2010-08-09 09:00:00	QQQ	ETF	46.97	47.01	46.94	47.01	198641.0
2010-08-09 09:30:00	QQQ	ETF	47.01	47.08	46.79	46.8772	5780405.0
2010-08-09 10:00:00	QQQ	ETF	46.88	47.03	46.86	46.9	2409058.0
2010-08-09 10:30:00	QQQ	ETF	46.91	46.9795	46.86	46.95	1162778.0
2010-08-09 11:00:00	QQQ	ETF	46.95	47.02	46.91	46.975	1135967.0
2010-08-09 11:30:00	QQQ	ETF	46.97	47.05	46.96	46.97	1834864.0
2010-08-09 12:00:00	QQQ	ETF	46.96	47.03	46.95	46.98	809570.0
2010-08-09 12:30:00	QQQ	ETF	46.975	47.005	46.9399	46.98	668289.0
2010-08-09 13:00:00	QQQ	ETF	46.9704	47.03	46.96	46.97	950038.0
2010-08-09 13:30:00	QQQ	ETF	46.97	47.04	46.95	47.01	815030.0
2010-08-09 14:00:00	QQQ	ETF	47.02	47.06	47.02	47.04	993322.0
2010-08-09 14:30:00	QQQ	ETF	47.0401	47.19	47.0401	47.18	1515839.0

> showing 50 of 8,144 rows — these rows as CSV

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