PREVIEW / etf_30min / 2011-03-01

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-01.parquet
  size:    288 KB
  rows:    9,470

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-03-01 04:00:00	SPY	ETF	133.9	134.01	133.8	133.82	33132.0
2011-03-01 04:30:00	SPY	ETF	133.8	133.81	133.73	133.8	1850.0
2011-03-01 05:00:00	SPY	ETF	133.71	133.81	133.7	133.8	3600.0
2011-03-01 06:00:00	SPY	ETF	133.76	133.76	133.6	133.61	16300.0
2011-03-01 06:30:00	SPY	ETF	133.59	133.65	133.57	133.62	86974.0
2011-03-01 07:00:00	SPY	ETF	133.64	133.64	133.25	133.25	596758.0
2011-03-01 07:30:00	SPY	ETF	133.26	133.46	133.2	133.46	470827.0
2011-03-01 08:00:00	SPY	ETF	133.46	133.54	133.3	133.54	845100.0
2011-03-01 08:30:00	SPY	ETF	133.54	133.54	133.15	133.51	1105591.0
2011-03-01 09:00:00	SPY	ETF	133.51	133.59	133.15	133.57	906440.0
2011-03-01 09:30:00	SPY	ETF	133.57	133.69	132.97	133.07	18897808.0
2011-03-01 10:00:00	SPY	ETF	133.06	133.25	132.35	132.35	23331356.0
2011-03-01 10:30:00	SPY	ETF	132.3625	132.83	132.2	132.78	15408755.0
2011-03-01 11:00:00	SPY	ETF	132.78	132.93	132.41	132.43	10928599.0
2011-03-01 11:30:00	SPY	ETF	132.43	132.48	131.96	132.01	15168747.0
2011-03-01 12:00:00	SPY	ETF	132.01	132.07	131.7	131.79	11559724.0
2011-03-01 12:30:00	SPY	ETF	131.8	132.12	131.75	131.94	7872024.0
2011-03-01 13:00:00	SPY	ETF	131.93	131.99	131.51	131.61	11431723.0
2011-03-01 13:30:00	SPY	ETF	131.61	131.77	131.44	131.64	8705968.0
2011-03-01 14:00:00	SPY	ETF	131.645	131.65	131.1	131.14	15646062.0
2011-03-01 14:30:00	SPY	ETF	131.14	131.409	131.02	131.17	12634653.0
2011-03-01 15:00:00	SPY	ETF	131.17	131.37	130.95	131.18	15146146.0
2011-03-01 15:30:00	SPY	ETF	131.18	131.36	130.92	130.92	22790628.0
2011-03-01 16:00:00	SPY	ETF	130.94	133.08	130.52	130.57	13028921.0
2011-03-01 16:30:00	SPY	ETF	130.6	133.0608	130.26	130.31	11943347.0
2011-03-01 17:00:00	SPY	ETF	130.31	130.31	130.14	130.18	12786832.0
2011-03-01 17:30:00	SPY	ETF	130.19	130.24	130.16	130.23	15656187.0
2011-03-01 18:00:00	SPY	ETF	130.23	130.97	130.23	130.51	655324.0
2011-03-01 18:30:00	SPY	ETF	130.5	130.6	130.3	130.52	76325.0
2011-03-01 19:00:00	SPY	ETF	130.5	130.66	130.5	130.66	118274.0
2011-03-01 19:30:00	SPY	ETF	130.6	130.6	130.38	130.47	92287.0
2011-03-01 04:00:00	QQQ	ETF	58.03	58.25	58.03	58.25	1300.0
2011-03-01 05:00:00	QQQ	ETF	58.14	58.14	58.14	58.14	100.0
2011-03-01 06:00:00	QQQ	ETF	58.1	58.1	58.07	58.07	1500.0
2011-03-01 06:30:00	QQQ	ETF	58.06	58.1	58.06	58.1	10500.0
2011-03-01 07:00:00	QQQ	ETF	58.07	58.09	57.89	57.9	334670.0
2011-03-01 07:30:00	QQQ	ETF	57.9	57.97	57.86	57.97	214210.0
2011-03-01 08:00:00	QQQ	ETF	57.97	58.02	57.89	58.01	90167.0
2011-03-01 08:30:00	QQQ	ETF	58.0	58.0	57.94	57.98	148154.0
2011-03-01 09:00:00	QQQ	ETF	57.98	58.03	57.94	57.98	253039.0
2011-03-01 09:30:00	QQQ	ETF	57.99	58.02	57.67	57.75	8839126.0
2011-03-01 10:00:00	QQQ	ETF	57.75	57.84	57.39	57.39	7265855.0
2011-03-01 10:30:00	QQQ	ETF	57.39	57.67	57.3	57.64	5705863.0
2011-03-01 11:00:00	QQQ	ETF	57.64	57.71	57.45	57.45	3009500.0
2011-03-01 11:30:00	QQQ	ETF	57.45	57.47	57.19	57.22	5493207.0
2011-03-01 12:00:00	QQQ	ETF	57.22	57.24	57.06	57.085	5070796.0
2011-03-01 12:30:00	QQQ	ETF	57.09	57.23	57.06	57.1495	2126113.0
2011-03-01 13:00:00	QQQ	ETF	57.14	57.19	56.98	57.04	2590561.0
2011-03-01 13:30:00	QQQ	ETF	57.03	57.15	56.98	57.09	4963823.0
2011-03-01 14:00:00	QQQ	ETF	57.09	57.093	56.77	56.78	10508307.0

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

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