PREVIEW / etf_30min / 2010-09-20

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-20.parquet
  size:    263 KB
  rows:    8,605

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-20 04:00:00	SPY	ETF	112.5	112.88	112.5	112.88	5329.0
2010-09-20 04:30:00	SPY	ETF	112.89	112.91	112.89	112.91	4075.0
2010-09-20 05:00:00	SPY	ETF	112.92	112.95	112.9	112.95	1400.0
2010-09-20 05:30:00	SPY	ETF	113.01	113.11	113.01	113.06	3800.0
2010-09-20 06:00:00	SPY	ETF	113.06	113.12	113.05	113.1	14400.0
2010-09-20 06:30:00	SPY	ETF	113.12	113.12	113.05	113.07	14600.0
2010-09-20 07:00:00	SPY	ETF	113.0	113.05	112.91	113.05	110497.0
2010-09-20 07:30:00	SPY	ETF	113.05	113.05	112.94	112.94	557862.0
2010-09-20 08:00:00	SPY	ETF	112.92	113.0773	112.92	113.03	497521.0
2010-09-20 08:30:00	SPY	ETF	113.01	113.01	112.74	112.78	2047478.0
2010-09-20 09:00:00	SPY	ETF	112.78	112.92	112.72	112.89	1197565.0
2010-09-20 09:30:00	SPY	ETF	112.88	113.05	112.62	112.94	17258077.0
2010-09-20 10:00:00	SPY	ETF	112.94	113.61	112.84	113.46	25301033.0
2010-09-20 10:30:00	SPY	ETF	113.46	113.77	113.43	113.73	17284118.0
2010-09-20 11:00:00	SPY	ETF	113.74	113.79	113.61	113.72	11642117.0
2010-09-20 11:30:00	SPY	ETF	113.71	113.84	113.61	113.6504	8282939.0
2010-09-20 12:00:00	SPY	ETF	113.6504	113.7	113.47	113.49	6844268.0
2010-09-20 12:30:00	SPY	ETF	113.5	113.73	113.45	113.68	7716211.0
2010-09-20 13:00:00	SPY	ETF	113.6786	113.73	113.53	113.7	5267117.0
2010-09-20 13:30:00	SPY	ETF	113.7	113.79	113.61	113.73	5674139.0
2010-09-20 14:00:00	SPY	ETF	113.74	113.95	113.66	113.9201	9894376.0
2010-09-20 14:30:00	SPY	ETF	113.93	114.18	113.91	114.14	12618617.0
2010-09-20 15:00:00	SPY	ETF	114.14	114.32	114.07	114.2	17808220.0
2010-09-20 15:30:00	SPY	ETF	114.2	114.46	114.15	114.22	32206528.0
2010-09-20 16:00:00	SPY	ETF	114.23	114.25	112.5215	114.12	15978621.0
2010-09-20 16:30:00	SPY	ETF	114.12	114.23	114.0	114.05	4585358.0
2010-09-20 17:00:00	SPY	ETF	114.04	114.21	114.02	114.06	3142928.0
2010-09-20 17:30:00	SPY	ETF	114.08	114.1	114.04	114.08	27727.0
2010-09-20 18:00:00	SPY	ETF	114.07	114.23	114.04	114.04	68725.0
2010-09-20 18:30:00	SPY	ETF	114.05	114.08	114.04	114.06	24927.0
2010-09-20 19:00:00	SPY	ETF	114.09	114.11	114.04	114.1	130525.0
2010-09-20 19:30:00	SPY	ETF	114.09	114.15	114.08	114.1	45886.0
2010-09-20 04:30:00	QQQ	ETF	48.23	48.23	48.23	48.23	100.0
2010-09-20 05:00:00	QQQ	ETF	48.24	48.24	48.24	48.24	100.0
2010-09-20 05:30:00	QQQ	ETF	48.25	48.25	48.25	48.25	200.0
2010-09-20 06:00:00	QQQ	ETF	48.27	48.27	48.27	48.27	2000.0
2010-09-20 06:30:00	QQQ	ETF	48.22	48.27	48.22	48.23	5000.0
2010-09-20 07:00:00	QQQ	ETF	48.22	48.25	48.19	48.24	19160.0
2010-09-20 07:30:00	QQQ	ETF	48.23	48.25	48.21	48.21	46287.0
2010-09-20 08:00:00	QQQ	ETF	48.19	48.23	48.15	48.21	108695.0
2010-09-20 08:30:00	QQQ	ETF	48.2	48.2	48.12	48.14	132490.0
2010-09-20 09:00:00	QQQ	ETF	48.14	48.18	48.11	48.18	317700.0
2010-09-20 09:30:00	QQQ	ETF	48.18	48.32	48.1101	48.26	9155910.0
2010-09-20 10:00:00	QQQ	ETF	48.26	48.6601	48.2	48.5895	10124968.0
2010-09-20 10:30:00	QQQ	ETF	48.59	48.63	48.53	48.61	4521001.0
2010-09-20 11:00:00	QQQ	ETF	48.61	48.65	48.5	48.5661	3903788.0
2010-09-20 11:30:00	QQQ	ETF	48.56	48.62	48.5	48.52	2873046.0
2010-09-20 12:00:00	QQQ	ETF	48.52	48.53	48.43	48.43	2448228.0
2010-09-20 12:30:00	QQQ	ETF	48.44	48.57	48.4105	48.53	5366385.0
2010-09-20 13:00:00	QQQ	ETF	48.53	48.57	48.46	48.54	2492590.0

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

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