PREVIEW / etf_30min / 2011-07-22

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-22.parquet
  size:    278 KB
  rows:    9,322

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-22 04:00:00	SPY	ETF	134.88	135.01	134.88	135.01	1000.0
2011-07-22 04:30:00	SPY	ETF	135.0	135.16	135.0	135.16	1178.0
2011-07-22 05:00:00	SPY	ETF	135.13	135.13	135.1	135.13	930.0
2011-07-22 05:30:00	SPY	ETF	135.09	135.09	135.0	135.0	20400.0
2011-07-22 06:00:00	SPY	ETF	135.04	135.1	135.04	135.09	1550.0
2011-07-22 06:30:00	SPY	ETF	135.09	135.09	134.85	134.91	6700.0
2011-07-22 07:00:00	SPY	ETF	134.9	135.15	134.87	135.09	646600.0
2011-07-22 07:30:00	SPY	ETF	135.07	135.07	134.64	134.68	1022544.0
2011-07-22 08:00:00	SPY	ETF	134.71	134.93	134.64	134.65	1359932.0
2011-07-22 08:30:00	SPY	ETF	134.65	134.71	134.49	134.49	1409593.0
2011-07-22 09:00:00	SPY	ETF	134.48	134.59	134.36	134.52	1590276.0
2011-07-22 09:30:00	SPY	ETF	134.52	134.64	134.0	134.07	15619603.0
2011-07-22 10:00:00	SPY	ETF	134.07	134.29	133.76	133.96	14089602.0
2011-07-22 10:30:00	SPY	ETF	133.97	134.27	133.91	134.25	7815701.0
2011-07-22 11:00:00	SPY	ETF	134.25	134.39	134.17	134.22	6939724.0
2011-07-22 11:30:00	SPY	ETF	134.22	134.5	134.21	134.435	9778638.0
2011-07-22 12:00:00	SPY	ETF	134.435	134.68	134.34	134.54	9615800.0
2011-07-22 12:30:00	SPY	ETF	134.54	134.72	134.46	134.67	5887985.0
2011-07-22 13:00:00	SPY	ETF	134.68	134.7	134.54	134.6	2768267.0
2011-07-22 13:30:00	SPY	ETF	134.61	134.67	134.53	134.64	3672961.0
2011-07-22 14:00:00	SPY	ETF	134.645	134.67	134.48	134.56	6244042.0
2011-07-22 14:30:00	SPY	ETF	134.56	134.655	134.56	134.64	2856098.0
2011-07-22 15:00:00	SPY	ETF	134.64	134.72	134.48	134.5	5466055.0
2011-07-22 15:30:00	SPY	ETF	134.5	134.59	134.32	134.58	17389063.0
2011-07-22 16:00:00	SPY	ETF	134.58	134.71	134.2	134.52	8970577.0
2011-07-22 16:30:00	SPY	ETF	134.52	134.66	134.3713	134.6	360783.0
2011-07-22 17:00:00	SPY	ETF	134.62	134.66	134.59	134.6	35346.0
2011-07-22 17:30:00	SPY	ETF	134.59	134.6	134.53	134.6	35839.0
2011-07-22 18:00:00	SPY	ETF	134.52	134.61	133.9	134.11	399356.0
2011-07-22 18:30:00	SPY	ETF	134.07	134.11	133.81	133.85	267607.0
2011-07-22 19:00:00	SPY	ETF	133.86	133.94	133.77	133.9	50284.0
2011-07-22 19:30:00	SPY	ETF	133.95	134.12	133.88	134.07	92507.0
2011-07-22 04:00:00	QQQ	ETF	59.26	59.28	59.26	59.28	700.0
2011-07-22 04:30:00	QQQ	ETF	59.31	59.31	59.31	59.31	400.0
2011-07-22 06:00:00	QQQ	ETF	59.29	59.29	59.29	59.29	200.0
2011-07-22 06:30:00	QQQ	ETF	59.24	59.3	59.24	59.3	5200.0
2011-07-22 07:00:00	QQQ	ETF	59.21	59.28	59.21	59.28	6400.0
2011-07-22 07:30:00	QQQ	ETF	59.25	59.25	59.04	59.07	151199.0
2011-07-22 08:00:00	QQQ	ETF	59.06	59.14	59.06	59.09	100043.0
2011-07-22 08:30:00	QQQ	ETF	59.07	59.07	58.92	58.93	163766.0
2011-07-22 09:00:00	QQQ	ETF	58.92	58.98	58.88	58.97	186395.0
2011-07-22 09:30:00	QQQ	ETF	58.97	59.2681	58.96	59.02	6671195.0
2011-07-22 10:00:00	QQQ	ETF	59.01	59.14	58.92	59.03	3412245.0
2011-07-22 10:30:00	QQQ	ETF	59.02	59.17	59.02	59.16	1591416.0
2011-07-22 11:00:00	QQQ	ETF	59.17	59.21	59.11	59.13	1852399.0
2011-07-22 11:30:00	QQQ	ETF	59.129	59.27	59.12	59.2499	3484674.0
2011-07-22 12:00:00	QQQ	ETF	59.245	59.38	59.21	59.365	2515363.0
2011-07-22 12:30:00	QQQ	ETF	59.365	59.54	59.36	59.53	2871117.0
2011-07-22 13:00:00	QQQ	ETF	59.54	59.545	59.46	59.5033	1701879.0
2011-07-22 13:30:00	QQQ	ETF	59.51	59.63	59.49	59.62	2726588.0

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

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