PREVIEW / etf_30min / 2011-07-05

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-05.parquet
  size:    276 KB
  rows:    9,338

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-07-05 04:00:00	SPY	ETF	133.85	133.97	133.8	133.95	1300.0
2011-07-05 04:30:00	SPY	ETF	133.89	133.89	133.87	133.87	500.0
2011-07-05 05:00:00	SPY	ETF	133.82	133.9	133.8	133.9	1800.0
2011-07-05 05:30:00	SPY	ETF	133.9	134.05	133.9	134.05	3200.0
2011-07-05 06:00:00	SPY	ETF	134.1	134.2	134.1	134.1	8100.0
2011-07-05 06:30:00	SPY	ETF	134.0	134.0	134.0	134.0	25000.0
2011-07-05 07:00:00	SPY	ETF	134.0	134.09	133.9	133.94	346527.0
2011-07-05 07:30:00	SPY	ETF	133.9	133.98	133.7	133.7	354660.0
2011-07-05 08:00:00	SPY	ETF	133.71	133.75	133.6	133.68	808376.0
2011-07-05 08:30:00	SPY	ETF	133.66	133.76	133.57	133.76	524118.0
2011-07-05 09:00:00	SPY	ETF	133.76	133.81	133.7	133.77	765465.0
2011-07-05 09:30:00	SPY	ETF	133.78	133.8	133.48	133.7	14238753.0
2011-07-05 10:00:00	SPY	ETF	133.71	133.98	133.455	133.62	13171139.0
2011-07-05 10:30:00	SPY	ETF	133.62	133.785	133.47	133.53	6426365.0
2011-07-05 11:00:00	SPY	ETF	133.54	133.68	133.39	133.61	8191899.0
2011-07-05 11:30:00	SPY	ETF	133.61	133.81	133.56	133.76	6837479.0
2011-07-05 12:00:00	SPY	ETF	133.77	133.9	133.73	133.84	3594567.0
2011-07-05 12:30:00	SPY	ETF	133.85	133.93	133.8	133.85	3219527.0
2011-07-05 13:00:00	SPY	ETF	133.86	133.96	133.84	133.9	4719923.0
2011-07-05 13:30:00	SPY	ETF	133.9	134.08	133.87	134.05	4438610.0
2011-07-05 14:00:00	SPY	ETF	134.06	134.08	133.41	133.48	20019362.0
2011-07-05 14:30:00	SPY	ETF	133.47	133.77	133.4	133.74	12766701.0
2011-07-05 15:00:00	SPY	ETF	133.73	134.04	133.63	134.0	22072707.0
2011-07-05 15:30:00	SPY	ETF	134.01	134.07	133.67	133.78	24790466.0
2011-07-05 16:00:00	SPY	ETF	133.77	134.17	133.67	134.06	7593060.0
2011-07-05 16:30:00	SPY	ETF	134.07	134.13	133.9455	134.0	4209330.0
2011-07-05 17:00:00	SPY	ETF	134.01	134.05	133.98	133.99	234222.0
2011-07-05 17:30:00	SPY	ETF	133.99	134.03	133.97	134.03	20960.0
2011-07-05 18:00:00	SPY	ETF	134.02	134.06	133.71	134.03	144726.0
2011-07-05 18:30:00	SPY	ETF	134.04	134.04	134.0	134.01	4938.0
2011-07-05 19:00:00	SPY	ETF	134.0	134.03	134.0	134.03	17397.0
2011-07-05 19:30:00	SPY	ETF	134.03	134.03	134.0	134.01	34253.0
2011-07-05 04:00:00	QQQ	ETF	57.92	58.04	57.92	58.04	200.0
2011-07-05 05:00:00	QQQ	ETF	58.0	58.02	58.0	58.02	800.0
2011-07-05 05:30:00	QQQ	ETF	58.05	58.14	58.05	58.14	300.0
2011-07-05 06:00:00	QQQ	ETF	58.18	58.2	58.1	58.1	500.0
2011-07-05 06:30:00	QQQ	ETF	58.05	58.05	58.05	58.05	200.0
2011-07-05 07:00:00	QQQ	ETF	58.06	58.08	58.02	58.02	28000.0
2011-07-05 07:30:00	QQQ	ETF	58.05	58.06	57.95	57.95	42700.0
2011-07-05 08:00:00	QQQ	ETF	57.95	57.99	57.91	57.94	203138.0
2011-07-05 08:30:00	QQQ	ETF	57.92	57.96	57.9	57.95	120093.0
2011-07-05 09:00:00	QQQ	ETF	57.95	57.98	57.93	57.95	193872.0
2011-07-05 09:30:00	QQQ	ETF	57.95	58.0	57.91	57.97	5897630.0
2011-07-05 10:00:00	QQQ	ETF	57.97	58.09	57.83	57.88	4894111.0
2011-07-05 10:30:00	QQQ	ETF	57.88	58.06	57.87	57.94	2953113.0
2011-07-05 11:00:00	QQQ	ETF	57.94	58.065	57.9	58.06	3254524.0
2011-07-05 11:30:00	QQQ	ETF	58.065	58.1699	58.04	58.095	3089755.0
2011-07-05 12:00:00	QQQ	ETF	58.0997	58.12	58.06	58.11	1343879.0
2011-07-05 12:30:00	QQQ	ETF	58.11	58.16	58.1	58.15	1478369.0
2011-07-05 13:00:00	QQQ	ETF	58.15	58.2	58.14	58.19	1241959.0

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

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