PREVIEW / etf_30min / 2012-04-04

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-04.parquet
  size:    290 KB
  rows:    9,837

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
2012-04-04 04:00:00	SPY	ETF	140.67	140.67	140.51	140.55	1690.0
2012-04-04 04:30:00	SPY	ETF	140.56	140.6	140.29	140.29	47370.0
2012-04-04 05:00:00	SPY	ETF	140.32	140.37	140.21	140.33	169700.0
2012-04-04 05:30:00	SPY	ETF	140.28	140.33	140.21	140.21	35060.0
2012-04-04 06:00:00	SPY	ETF	140.28	140.34	140.15	140.27	8250.0
2012-04-04 06:30:00	SPY	ETF	140.28	140.44	140.22	140.27	121150.0
2012-04-04 07:00:00	SPY	ETF	140.27	140.27	140.07	140.22	295345.0
2012-04-04 07:30:00	SPY	ETF	140.21	140.39	140.18	140.31	336887.0
2012-04-04 08:00:00	SPY	ETF	140.31	141.15	140.11	140.25	838964.0
2012-04-04 08:30:00	SPY	ETF	140.28	140.37	140.05	140.16	1036937.0
2012-04-04 09:00:00	SPY	ETF	140.14	140.26	140.06	140.19	1099280.0
2012-04-04 09:30:00	SPY	ETF	140.22	140.339	140.0	140.27	14505543.0
2012-04-04 10:00:00	SPY	ETF	140.278	140.29	139.69	139.8	16740436.0
2012-04-04 10:30:00	SPY	ETF	139.8	139.86	139.4	139.42	16865407.0
2012-04-04 11:00:00	SPY	ETF	139.43	139.74	139.41	139.55	12036342.0
2012-04-04 11:30:00	SPY	ETF	139.55	140.3099	139.54	139.7	9247076.0
2012-04-04 12:00:00	SPY	ETF	139.69	139.86	139.64	139.78	4505768.0
2012-04-04 12:30:00	SPY	ETF	139.77	139.79	139.62	139.68	4046644.0
2012-04-04 13:00:00	SPY	ETF	139.67	139.69	139.4	139.4	7006564.0
2012-04-04 13:30:00	SPY	ETF	139.4	139.79	139.34	139.754	6819549.0
2012-04-04 14:00:00	SPY	ETF	139.76	139.78	139.55	139.63	5025560.0
2012-04-04 14:30:00	SPY	ETF	139.63	140.0	139.59	139.8999	10085137.0
2012-04-04 15:00:00	SPY	ETF	139.89	140.09	139.81	139.9601	11205383.0
2012-04-04 15:30:00	SPY	ETF	139.97	140.14	139.85	139.88	17718736.0
2012-04-04 16:00:00	SPY	ETF	139.87	139.9985	139.74	139.78	5132311.0
2012-04-04 16:30:00	SPY	ETF	139.79	139.84	139.72	139.75	377388.0
2012-04-04 17:00:00	SPY	ETF	139.76	139.77	139.6	139.63	238013.0
2012-04-04 17:30:00	SPY	ETF	139.63	139.7	139.59	139.64	87951.0
2012-04-04 18:00:00	SPY	ETF	139.66	139.81	139.66	139.8	52194.0
2012-04-04 18:30:00	SPY	ETF	139.79	139.82	139.75	139.76	22345.0
2012-04-04 19:00:00	SPY	ETF	139.78	139.82	139.76	139.8	19905.0
2012-04-04 19:30:00	SPY	ETF	139.81	139.85	139.78	139.78	23941.0
2012-04-04 04:00:00	QQQ	ETF	67.92	67.92	67.92	67.92	100.0
2012-04-04 04:30:00	QQQ	ETF	67.85	67.85	67.85	67.85	100.0
2012-04-04 05:00:00	QQQ	ETF	67.75	67.78	67.75	67.78	350.0
2012-04-04 05:30:00	QQQ	ETF	67.76	67.76	67.76	67.76	100.0
2012-04-04 06:00:00	QQQ	ETF	67.74	67.85	67.74	67.85	25450.0
2012-04-04 06:30:00	QQQ	ETF	67.83	67.83	67.81	67.81	2100.0
2012-04-04 07:00:00	QQQ	ETF	67.77	67.77	67.67	67.75	85000.0
2012-04-04 07:30:00	QQQ	ETF	67.74	67.82	67.74	67.8	8595.0
2012-04-04 08:00:00	QQQ	ETF	67.77	68.0	67.59	67.77	156027.0
2012-04-04 08:30:00	QQQ	ETF	67.77	67.8	67.7	67.71	294620.0
2012-04-04 09:00:00	QQQ	ETF	67.71	67.75	67.67	67.72	118950.0
2012-04-04 09:30:00	QQQ	ETF	67.73	67.76	67.56	67.65	4596186.0
2012-04-04 10:00:00	QQQ	ETF	67.65	67.65	67.3	67.34	5614088.0
2012-04-04 10:30:00	QQQ	ETF	67.34	67.41	67.04	67.05	5492759.0
2012-04-04 11:00:00	QQQ	ETF	67.05	67.21	67.05	67.12	3500729.0
2012-04-04 11:30:00	QQQ	ETF	67.13	67.23	67.1001	67.11	2344924.0
2012-04-04 12:00:00	QQQ	ETF	67.12	67.1999	67.06	67.1519	1915054.0
2012-04-04 12:30:00	QQQ	ETF	67.15	67.15	67.05	67.079	2066217.0

> showing 50 of 9,837 rows — these rows as CSV

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