PREVIEW / etf_30min / 2010-09-24

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-24.parquet
  size:    264 KB
  rows:    8,754

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-09-24 04:00:00	SPY	ETF	112.9	113.05	112.9	113.04	14900.0
2010-09-24 04:30:00	SPY	ETF	112.99	113.0	112.75	112.91	4400.0
2010-09-24 05:00:00	SPY	ETF	112.86	112.94	112.86	112.94	700.0
2010-09-24 06:00:00	SPY	ETF	112.73	112.79	112.69	112.78	13250.0
2010-09-24 06:30:00	SPY	ETF	112.76	112.81	112.76	112.76	17800.0
2010-09-24 07:00:00	SPY	ETF	112.82	113.02	112.82	112.91	120736.0
2010-09-24 07:30:00	SPY	ETF	112.92	113.0	112.89	112.96	136925.0
2010-09-24 08:00:00	SPY	ETF	112.96	113.27	112.93	113.13	1524426.0
2010-09-24 08:30:00	SPY	ETF	113.24	113.89	113.23	113.76	4433598.0
2010-09-24 09:00:00	SPY	ETF	113.77	113.83	112.5	113.74	2273883.0
2010-09-24 09:30:00	SPY	ETF	113.75	114.34	113.65	114.2475	24369496.0
2010-09-24 10:00:00	SPY	ETF	114.25	114.64	114.08	114.57	24270353.0
2010-09-24 10:30:00	SPY	ETF	114.58	114.71	114.45	114.53	13787347.0
2010-09-24 11:00:00	SPY	ETF	114.52	114.76	114.48	114.61	11980791.0
2010-09-24 11:30:00	SPY	ETF	114.61	114.66	114.43	114.6	8032134.0
2010-09-24 12:00:00	SPY	ETF	114.61	114.61	114.5	114.6	4942095.0
2010-09-24 12:30:00	SPY	ETF	114.6	114.79	114.55	114.73	7945446.0
2010-09-24 13:00:00	SPY	ETF	114.73	114.78	114.65	114.77	3214636.0
2010-09-24 13:30:00	SPY	ETF	114.77	114.89	114.66	114.6881	11004309.0
2010-09-24 14:00:00	SPY	ETF	114.68	114.74	114.55	114.67	7532436.0
2010-09-24 14:30:00	SPY	ETF	114.67	114.89	114.65	114.78	12679709.0
2010-09-24 15:00:00	SPY	ETF	114.78	114.8	114.61	114.66	10677403.0
2010-09-24 15:30:00	SPY	ETF	114.65	114.9	114.62	114.8	24127193.0
2010-09-24 16:00:00	SPY	ETF	114.8	114.85	112.462	114.76	11325526.0
2010-09-24 16:30:00	SPY	ETF	114.76	114.89	114.6526	114.85	17226462.0
2010-09-24 17:00:00	SPY	ETF	114.85	114.85	114.75	114.77	5239926.0
2010-09-24 17:30:00	SPY	ETF	114.76	114.88	114.76	114.86	33565.0
2010-09-24 18:00:00	SPY	ETF	114.87	114.87	114.81	114.86	12558.0
2010-09-24 18:30:00	SPY	ETF	114.85	114.87	114.77	114.86	10846.0
2010-09-24 19:00:00	SPY	ETF	114.84	114.88	114.84	114.86	6200.0
2010-09-24 19:30:00	SPY	ETF	114.85	114.92	114.79	114.88	44292.0
2010-09-24 04:00:00	QQQ	ETF	48.97	49.0	48.91	48.95	5138.0
2010-09-24 04:30:00	QQQ	ETF	48.94	48.94	48.85	48.92	800.0
2010-09-24 05:00:00	QQQ	ETF	48.92	48.94	48.92	48.94	200.0
2010-09-24 05:30:00	QQQ	ETF	48.96	48.96	48.96	48.96	401.0
2010-09-24 06:00:00	QQQ	ETF	48.9	48.9	48.9	48.9	100.0
2010-09-24 06:30:00	QQQ	ETF	48.89	48.89	48.89	48.89	100.0
2010-09-24 07:00:00	QQQ	ETF	48.95	48.99	48.93	48.94	38996.0
2010-09-24 07:30:00	QQQ	ETF	48.95	48.98	48.93	48.95	93833.0
2010-09-24 08:00:00	QQQ	ETF	48.96	49.09	48.96	49.08	310128.0
2010-09-24 08:30:00	QQQ	ETF	49.1	49.36	49.09	49.25	1345693.0
2010-09-24 09:00:00	QQQ	ETF	49.26	49.28	49.18	49.23	655755.0
2010-09-24 09:30:00	QQQ	ETF	49.22	49.42	49.15	49.371	8727527.0
2010-09-24 10:00:00	QQQ	ETF	49.38	49.55	49.32	49.47	8268469.0
2010-09-24 10:30:00	QQQ	ETF	49.47	49.5699	49.43	49.515	4761666.0
2010-09-24 11:00:00	QQQ	ETF	49.52	49.65	49.49	49.58	5972363.0
2010-09-24 11:30:00	QQQ	ETF	49.58	49.62	49.51	49.61	2633079.0
2010-09-24 12:00:00	QQQ	ETF	49.6	49.6005	49.54	49.59	1213249.0
2010-09-24 12:30:00	QQQ	ETF	49.59	49.69	49.56	49.64	3159443.0
2010-09-24 13:00:00	QQQ	ETF	49.64	49.6504	49.58	49.65	2613459.0

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

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