PREVIEW / etf_30min / 2011-10-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-07.parquet
  size:    286 KB
  rows:    9,533

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-10-07 04:00:00	SPY	ETF	116.4	116.55	116.38	116.55	700.0
2011-10-07 04:30:00	SPY	ETF	116.5	116.5	115.97	115.97	14750.0
2011-10-07 05:00:00	SPY	ETF	116.03	116.03	115.9	115.95	3600.0
2011-10-07 05:30:00	SPY	ETF	116.1	116.15	116.01	116.13	62250.0
2011-10-07 06:00:00	SPY	ETF	115.99	116.16	115.93	116.16	13850.0
2011-10-07 06:30:00	SPY	ETF	116.08	116.13	115.96	116.08	37220.0
2011-10-07 07:00:00	SPY	ETF	116.17	116.32	115.91	115.93	907510.0
2011-10-07 07:30:00	SPY	ETF	115.95	116.05	115.88	115.99	794028.0
2011-10-07 08:00:00	SPY	ETF	116.08	116.32	115.9	116.0	4418760.0
2011-10-07 08:30:00	SPY	ETF	116.17	117.95	116.1	117.37	14502487.0
2011-10-07 09:00:00	SPY	ETF	117.39	117.48	116.95	117.17	4548215.0
2011-10-07 09:30:00	SPY	ETF	117.17	117.23	116.34	116.87	31230614.0
2011-10-07 10:00:00	SPY	ETF	116.86	117.245	116.4	117.01	25766436.0
2011-10-07 10:30:00	SPY	ETF	117.0	117.16	116.4	116.42	18125315.0
2011-10-07 11:00:00	SPY	ETF	116.42	116.49	115.9	116.34	18852957.0
2011-10-07 11:30:00	SPY	ETF	116.34	116.57	116.1	116.55	11417451.0
2011-10-07 12:00:00	SPY	ETF	116.56	116.64	115.37	115.8	27308866.0
2011-10-07 12:30:00	SPY	ETF	115.8	115.94	115.24	115.37	16882046.0
2011-10-07 13:00:00	SPY	ETF	115.37	115.75	115.09	115.55	14182710.0
2011-10-07 13:30:00	SPY	ETF	115.55	115.74	115.06	115.629	9910267.0
2011-10-07 14:00:00	SPY	ETF	115.63	116.2	115.46	115.76	13981425.0
2011-10-07 14:30:00	SPY	ETF	115.76	116.14	115.63	116.02	13866994.0
2011-10-07 15:00:00	SPY	ETF	116.02	116.97	115.82	116.92	20126053.0
2011-10-07 15:30:00	SPY	ETF	116.92	117.03	115.46	115.68	39621766.0
2011-10-07 16:00:00	SPY	ETF	115.7	116.683	115.5949	116.08	14189430.0
2011-10-07 16:30:00	SPY	ETF	116.08	116.11	115.86	116.01	7311631.0
2011-10-07 17:00:00	SPY	ETF	116.02	116.02	115.82	115.93	676936.0
2011-10-07 17:30:00	SPY	ETF	115.93	115.93	115.81	115.85	150071.0
2011-10-07 18:00:00	SPY	ETF	115.84	115.9	115.75	115.9	324536.0
2011-10-07 18:30:00	SPY	ETF	115.85	116.01	115.85	115.96	132279.0
2011-10-07 19:00:00	SPY	ETF	115.93	116.02	115.93	115.94	36805.0
2011-10-07 19:30:00	SPY	ETF	115.94	116.0	115.87	115.95	23846.0
2011-10-07 05:00:00	QQQ	ETF	54.09	54.09	54.0	54.0	800.0
2011-10-07 05:30:00	QQQ	ETF	54.14	54.14	54.14	54.14	1500.0
2011-10-07 06:00:00	QQQ	ETF	54.14	54.14	54.14	54.14	100.0
2011-10-07 06:30:00	QQQ	ETF	54.12	54.12	54.1	54.1	600.0
2011-10-07 07:00:00	QQQ	ETF	54.21	54.22	54.04	54.04	47574.0
2011-10-07 07:30:00	QQQ	ETF	54.03	54.07	54.03	54.07	60585.0
2011-10-07 08:00:00	QQQ	ETF	54.07	54.15	53.9	54.03	1990198.0
2011-10-07 08:30:00	QQQ	ETF	54.03	54.77	54.03	54.56	3035789.0
2011-10-07 09:00:00	QQQ	ETF	54.58	54.59	54.32	54.41	438847.0
2011-10-07 09:30:00	QQQ	ETF	54.41	54.42	54.1	54.35	6728886.0
2011-10-07 10:00:00	QQQ	ETF	54.34	54.49	54.1201	54.39	5679081.0
2011-10-07 10:30:00	QQQ	ETF	54.38	54.49	54.14	54.1548	4320877.0
2011-10-07 11:00:00	QQQ	ETF	54.16	54.16	53.72	53.97	6301423.0
2011-10-07 11:30:00	QQQ	ETF	53.975	54.21	53.9301	54.21	3992288.0
2011-10-07 12:00:00	QQQ	ETF	54.21	54.27	53.735	53.99	9491413.0
2011-10-07 12:30:00	QQQ	ETF	53.98	54.03	53.8	53.85	3935859.0
2011-10-07 13:00:00	QQQ	ETF	53.84	54.08	53.76	53.98	2360896.0
2011-10-07 13:30:00	QQQ	ETF	53.9835	54.15	53.8299	54.1	1706396.0

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

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