PREVIEW / etf_30min / 2011-05-31

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-31.parquet
  size:    287 KB
  rows:    9,634

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
2011-05-31 04:00:00	SPY	ETF	134.31	134.9	134.31	134.86	9761.0
2011-05-31 04:30:00	SPY	ETF	134.84	134.87	134.77	134.87	2500.0
2011-05-31 05:00:00	SPY	ETF	134.74	134.84	134.73	134.8	36960.0
2011-05-31 05:30:00	SPY	ETF	134.82	134.85	134.82	134.85	1100.0
2011-05-31 06:00:00	SPY	ETF	134.81	134.87	134.81	134.85	1400.0
2011-05-31 06:30:00	SPY	ETF	134.75	134.76	134.7	134.76	16375.0
2011-05-31 07:00:00	SPY	ETF	134.79	134.8	134.69	134.72	323871.0
2011-05-31 07:30:00	SPY	ETF	134.75	134.78	134.57	134.58	211262.0
2011-05-31 08:00:00	SPY	ETF	134.59	134.67	134.49	134.62	443754.0
2011-05-31 08:30:00	SPY	ETF	134.61	134.66	134.57	134.63	559987.0
2011-05-31 09:00:00	SPY	ETF	134.62	134.8	134.62	134.78	1201444.0
2011-05-31 09:30:00	SPY	ETF	134.77	134.89	134.42	134.44	18672998.0
2011-05-31 10:00:00	SPY	ETF	134.44	134.559	134.13	134.278	14558753.0
2011-05-31 10:30:00	SPY	ETF	134.28	134.3	134.09	134.13	9618258.0
2011-05-31 11:00:00	SPY	ETF	134.13	134.26	134.07	134.16	15914101.0
2011-05-31 11:30:00	SPY	ETF	134.17	134.32	133.99	134.04	6411151.0
2011-05-31 12:00:00	SPY	ETF	134.04	134.14	133.91	134.06	6518332.0
2011-05-31 12:30:00	SPY	ETF	134.05	134.1439	133.84	134.0	6387127.0
2011-05-31 13:00:00	SPY	ETF	134.0	134.26	133.98	134.17	8012568.0
2011-05-31 13:30:00	SPY	ETF	134.17	134.4	134.16	134.33	5868795.0
2011-05-31 14:00:00	SPY	ETF	134.33	134.4	134.27	134.28	3926460.0
2011-05-31 14:30:00	SPY	ETF	134.29	134.37	134.2	134.32	6872104.0
2011-05-31 15:00:00	SPY	ETF	134.31	134.47	134.19	134.42	8661204.0
2011-05-31 15:30:00	SPY	ETF	134.42	134.91	134.3	134.89	29728528.0
2011-05-31 16:00:00	SPY	ETF	134.9	135.09	134.12	135.0	13957892.0
2011-05-31 16:30:00	SPY	ETF	134.99	135.01	134.2687	134.93	2966776.0
2011-05-31 17:00:00	SPY	ETF	134.91	134.97	134.89	134.93	178857.0
2011-05-31 17:30:00	SPY	ETF	134.94	135.01	134.5	134.97	94512.0
2011-05-31 18:00:00	SPY	ETF	134.96	135.01	134.89	134.89	171992.0
2011-05-31 18:30:00	SPY	ETF	135.0	135.12	135.0	135.11	70168.0
2011-05-31 19:00:00	SPY	ETF	135.11	135.26	135.1	135.25	97005.0
2011-05-31 19:30:00	SPY	ETF	135.23	135.26	135.18	135.21	46411.0
2011-05-31 04:00:00	QQQ	ETF	57.66	57.81	57.66	57.81	8913.0
2011-05-31 04:30:00	QQQ	ETF	58.0	58.02	58.0	58.02	3335.0
2011-05-31 06:00:00	QQQ	ETF	57.98	57.98	57.98	57.98	200.0
2011-05-31 07:00:00	QQQ	ETF	57.89	57.95	57.89	57.92	31300.0
2011-05-31 07:30:00	QQQ	ETF	57.92	57.95	57.86	57.87	23900.0
2011-05-31 08:00:00	QQQ	ETF	57.88	57.89	57.84	57.88	161553.0
2011-05-31 08:30:00	QQQ	ETF	57.88	57.91	57.87	57.88	223332.0
2011-05-31 09:00:00	QQQ	ETF	57.88	57.97	57.88	57.97	485753.0
2011-05-31 09:30:00	QQQ	ETF	57.97	58.07	57.91	57.96	5611323.0
2011-05-31 10:00:00	QQQ	ETF	57.96	57.97	57.76	57.82	5137799.0
2011-05-31 10:30:00	QQQ	ETF	57.81	57.83	57.73	57.75	1608184.0
2011-05-31 11:00:00	QQQ	ETF	57.74	57.81	57.73	57.7875	1717080.0
2011-05-31 11:30:00	QQQ	ETF	57.79	57.85	57.7	57.74	1994288.0
2011-05-31 12:00:00	QQQ	ETF	57.745	57.82	57.67	57.8	1281008.0
2011-05-31 12:30:00	QQQ	ETF	57.8	57.8084	57.7	57.77	861838.0
2011-05-31 13:00:00	QQQ	ETF	57.77	57.9	57.765	57.85	1039589.0
2011-05-31 13:30:00	QQQ	ETF	57.86	58.02	57.84	57.98	2276889.0
2011-05-31 14:00:00	QQQ	ETF	57.9792	58.025	57.95	57.98	899794.0

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

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