PREVIEW / etf_30min / 2010-09-17

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-17.parquet
  size:    246 KB
  rows:    8,528

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-17 04:00:00	SPY	ETF	113.12	113.72	113.12	113.7	10942.0
2010-09-17 04:30:00	SPY	ETF	113.67	113.71	113.55	113.61	8390.0
2010-09-17 05:00:00	SPY	ETF	113.64	113.66	113.59	113.6	2075.0
2010-09-17 05:30:00	SPY	ETF	113.69	113.69	113.55	113.55	16400.0
2010-09-17 06:00:00	SPY	ETF	113.54	113.57	113.5	113.55	5084.0
2010-09-17 06:30:00	SPY	ETF	113.5	113.5	113.35	113.44	43400.0
2010-09-17 07:00:00	SPY	ETF	113.45	113.6	113.33	113.34	330016.0
2010-09-17 07:30:00	SPY	ETF	113.35	113.35	112.98	113.1	546132.0
2010-09-17 08:00:00	SPY	ETF	113.13	113.59	112.85	113.1	2255922.0
2010-09-17 08:30:00	SPY	ETF	113.11	113.17	112.89	112.91	1693279.0
2010-09-17 09:00:00	SPY	ETF	112.92	113.16	112.8	113.03	2527834.0
2010-09-17 09:30:00	SPY	ETF	113.04	113.15	112.29	112.41	39902320.0
2010-09-17 10:00:00	SPY	ETF	112.42	112.52	112.18	112.3999	20832062.0
2010-09-17 10:30:00	SPY	ETF	112.4	112.65	112.25	112.54	19218866.0
2010-09-17 11:00:00	SPY	ETF	112.5461	112.79	112.46	112.52	13662354.0
2010-09-17 11:30:00	SPY	ETF	112.515	112.54	112.34	112.42	7152732.0
2010-09-17 12:00:00	SPY	ETF	112.41	112.6	112.41	112.6	3523081.0
2010-09-17 12:30:00	SPY	ETF	112.6	112.66	112.36	112.42	5183503.0
2010-09-17 13:00:00	SPY	ETF	112.42	112.5	112.31	112.45	6077046.0
2010-09-17 13:30:00	SPY	ETF	112.44	112.57	112.4	112.5199	5640659.0
2010-09-17 14:00:00	SPY	ETF	112.52	112.62	112.46	112.5799	9656728.0
2010-09-17 14:30:00	SPY	ETF	112.57	112.74	112.54	112.64	9784212.0
2010-09-17 15:00:00	SPY	ETF	112.64	112.6699	112.35	112.355	10164433.0
2010-09-17 15:30:00	SPY	ETF	112.35	112.62	112.35	112.49	21688378.0
2010-09-17 16:00:00	SPY	ETF	112.49	113.015	112.34	112.44	9287515.0
2010-09-17 16:30:00	SPY	ETF	112.46	112.5187	112.28	112.39	2613318.0
2010-09-17 17:00:00	SPY	ETF	112.36	112.49	112.25	112.25	1231620.0
2010-09-17 17:30:00	SPY	ETF	112.26	112.35	112.23	112.32	105323.0
2010-09-17 18:00:00	SPY	ETF	112.33	112.34	112.28	112.29	7875.0
2010-09-17 18:30:00	SPY	ETF	112.31	112.34	112.25	112.32	9717.0
2010-09-17 19:00:00	SPY	ETF	112.3	112.31	112.23	112.3	64322.0
2010-09-17 19:30:00	SPY	ETF	112.3	112.3	112.23	112.28	8853.0
2010-09-17 04:30:00	QQQ	ETF	48.36	48.37	48.36	48.37	11435.0
2010-09-17 05:30:00	QQQ	ETF	48.3	48.3	48.26	48.26	650.0
2010-09-17 06:00:00	QQQ	ETF	48.23	48.23	48.2	48.21	700.0
2010-09-17 06:30:00	QQQ	ETF	48.17	48.17	48.14	48.14	2300.0
2010-09-17 07:00:00	QQQ	ETF	48.18	48.24	48.14	48.14	96314.0
2010-09-17 07:30:00	QQQ	ETF	48.14	48.16	48.01	48.04	271142.0
2010-09-17 08:00:00	QQQ	ETF	48.04	48.13	47.97	48.11	1141807.0
2010-09-17 08:30:00	QQQ	ETF	48.09	48.18	48.05	48.08	2415590.0
2010-09-17 09:00:00	QQQ	ETF	48.09	48.18	48.05	48.14	989576.0
2010-09-17 09:30:00	QQQ	ETF	48.14	48.14	47.75	47.84	18199306.0
2010-09-17 10:00:00	QQQ	ETF	47.85	47.965	47.77	47.91	9135897.0
2010-09-17 10:30:00	QQQ	ETF	47.91	48.0	47.84	47.98	4241378.0
2010-09-17 11:00:00	QQQ	ETF	47.98	48.09	47.91	47.9301	5748275.0
2010-09-17 11:30:00	QQQ	ETF	47.93	47.99	47.9	47.95	2233792.0
2010-09-17 12:00:00	QQQ	ETF	47.95	48.05	47.94	48.04	1496584.0
2010-09-17 12:30:00	QQQ	ETF	48.04	48.08	47.93	47.97	1954290.0
2010-09-17 13:00:00	QQQ	ETF	47.9775	48.01	47.89	47.95	2287676.0
2010-09-17 13:30:00	QQQ	ETF	47.95	48.04	47.92	48.02	1416905.0

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

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