PREVIEW / etf_30min / 2010-08-27

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-27.parquet
  size:    257 KB
  rows:    8,532

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-27 04:00:00	SPY	ETF	105.14	105.21	105.12	105.12	1800.0
2010-08-27 04:30:00	SPY	ETF	105.2	105.2	105.13	105.13	200.0
2010-08-27 05:00:00	SPY	ETF	105.12	105.2	105.07	105.2	1517.0
2010-08-27 05:30:00	SPY	ETF	105.2	105.3	105.2	105.27	6900.0
2010-08-27 06:00:00	SPY	ETF	105.34	105.35	105.19	105.2	2200.0
2010-08-27 06:30:00	SPY	ETF	105.23	105.47	105.23	105.47	4800.0
2010-08-27 07:00:00	SPY	ETF	105.4	105.49	105.36	105.44	445452.0
2010-08-27 07:30:00	SPY	ETF	105.46	105.46	105.3	105.31	210750.0
2010-08-27 08:00:00	SPY	ETF	105.3	105.81	105.28	105.55	1170019.0
2010-08-27 08:30:00	SPY	ETF	105.61	106.0	105.55	105.83	4409922.0
2010-08-27 09:00:00	SPY	ETF	105.82	105.98	105.65	105.88	1461436.0
2010-08-27 09:30:00	SPY	ETF	105.89	105.97	105.0	105.05	26350066.0
2010-08-27 10:00:00	SPY	ETF	105.05	105.67	104.31	105.59	53386460.0
2010-08-27 10:30:00	SPY	ETF	105.59	105.92	105.43	105.59	21862541.0
2010-08-27 11:00:00	SPY	ETF	105.6	106.44	105.58	106.39	19923249.0
2010-08-27 11:30:00	SPY	ETF	106.38	106.47	106.14	106.22	10503999.0
2010-08-27 12:00:00	SPY	ETF	106.21	106.5	106.15	106.4	8572599.0
2010-08-27 12:30:00	SPY	ETF	106.4	106.49	106.0	106.06	7070060.0
2010-08-27 13:00:00	SPY	ETF	106.0501	106.33	105.98	106.33	8194169.0
2010-08-27 13:30:00	SPY	ETF	106.33	106.63	106.28	106.63	11680155.0
2010-08-27 14:00:00	SPY	ETF	106.62	106.69	106.35	106.57	14790010.0
2010-08-27 14:30:00	SPY	ETF	106.56	106.84	106.55	106.63	12204069.0
2010-08-27 15:00:00	SPY	ETF	106.64	106.9	106.45	106.849	15215514.0
2010-08-27 15:30:00	SPY	ETF	106.84	106.97	106.68	106.86	27270238.0
2010-08-27 16:00:00	SPY	ETF	106.86	106.99	104.835	106.84	13831673.0
2010-08-27 16:30:00	SPY	ETF	106.85	106.97	105.1439	106.95	2907400.0
2010-08-27 17:00:00	SPY	ETF	106.95	107.07	106.82	107.04	445734.0
2010-08-27 17:30:00	SPY	ETF	107.05	107.18	107.01	107.16	330086.0
2010-08-27 18:00:00	SPY	ETF	107.13	107.13	106.82	107.09	339918.0
2010-08-27 18:30:00	SPY	ETF	107.09	107.09	106.98	106.98	17895.0
2010-08-27 19:00:00	SPY	ETF	107.01	107.05	106.99	107.01	11046.0
2010-08-27 19:30:00	SPY	ETF	107.04	107.13	106.99	107.05	26984.0
2010-08-27 04:00:00	QQQ	ETF	43.52	43.52	43.52	43.52	18150.0
2010-08-27 04:30:00	QQQ	ETF	43.49	43.49	43.49	43.49	100.0
2010-08-27 05:00:00	QQQ	ETF	43.56	43.56	43.56	43.56	100.0
2010-08-27 06:00:00	QQQ	ETF	43.64	43.65	43.64	43.65	2500.0
2010-08-27 06:30:00	QQQ	ETF	43.65	43.69	43.65	43.68	28000.0
2010-08-27 07:00:00	QQQ	ETF	43.67	43.7	43.67	43.7	10788.0
2010-08-27 07:30:00	QQQ	ETF	43.71	43.72	43.65	43.65	14152.0
2010-08-27 08:00:00	QQQ	ETF	43.64	43.79	43.61	43.68	304620.0
2010-08-27 08:30:00	QQQ	ETF	43.7	43.95	43.7	43.87	837902.0
2010-08-27 09:00:00	QQQ	ETF	43.87	43.92	43.8	43.85	381922.0
2010-08-27 09:30:00	QQQ	ETF	43.86	43.93	43.3	43.33	11203279.0
2010-08-27 10:00:00	QQQ	ETF	43.32	43.78	42.97	43.7	43457674.0
2010-08-27 10:30:00	QQQ	ETF	43.7	43.8	43.48	43.56	9276799.0
2010-08-27 11:00:00	QQQ	ETF	43.55	43.99	43.545	43.96	5180767.0
2010-08-27 11:30:00	QQQ	ETF	43.96	43.99	43.81	43.84	2929804.0
2010-08-27 12:00:00	QQQ	ETF	43.84	44.01	43.81	43.95	2176736.0
2010-08-27 12:30:00	QQQ	ETF	43.96	44.0	43.76	43.79	2078076.0
2010-08-27 13:00:00	QQQ	ETF	43.79	43.95	43.75	43.94	4438200.0

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

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