PREVIEW / etf_30min / 2011-05-04

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-04.parquet
  size:    289 KB
  rows:    9,529

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-04 04:00:00	SPY	ETF	135.57	135.6	135.4	135.6	1200.0
2011-05-04 04:30:00	SPY	ETF	135.67	135.87	135.47	135.87	900.0
2011-05-04 05:00:00	SPY	ETF	135.89	135.92	135.82	135.83	10200.0
2011-05-04 05:30:00	SPY	ETF	135.84	135.84	135.8	135.8	300.0
2011-05-04 06:00:00	SPY	ETF	135.86	135.86	135.66	135.66	82100.0
2011-05-04 06:30:00	SPY	ETF	135.65	135.65	135.41	135.41	109570.0
2011-05-04 07:00:00	SPY	ETF	135.46	135.55	135.4	135.4	692705.0
2011-05-04 07:30:00	SPY	ETF	135.39	135.51	135.38	135.43	276650.0
2011-05-04 08:00:00	SPY	ETF	135.44	135.74	135.33	135.73	1589740.0
2011-05-04 08:30:00	SPY	ETF	135.73	135.8	135.6	135.7	1274826.0
2011-05-04 09:00:00	SPY	ETF	135.7	135.84	135.6186	135.68	1088334.0
2011-05-04 09:30:00	SPY	ETF	135.67	135.73	135.04	135.19	15387804.0
2011-05-04 10:00:00	SPY	ETF	135.19	135.19	134.55	134.79	22953025.0
2011-05-04 10:30:00	SPY	ETF	134.8	134.93	134.51	134.83	20864096.0
2011-05-04 11:00:00	SPY	ETF	134.83	134.87	134.31	134.56	13081388.0
2011-05-04 11:30:00	SPY	ETF	134.55	134.63	134.42	134.62	5908233.0
2011-05-04 12:00:00	SPY	ETF	134.61	134.72	134.26	134.35	8218684.0
2011-05-04 12:30:00	SPY	ETF	134.35	134.46	134.23	134.44	9852578.0
2011-05-04 13:00:00	SPY	ETF	134.44	134.77	134.39	134.67	10913343.0
2011-05-04 13:30:00	SPY	ETF	134.68	134.9	134.67	134.85	11210264.0
2011-05-04 14:00:00	SPY	ETF	134.85	135.15	134.64	135.065	9672150.0
2011-05-04 14:30:00	SPY	ETF	135.06	135.22	134.91	134.96	8254633.0
2011-05-04 15:00:00	SPY	ETF	134.95	135.05	134.72	135.02	8982974.0
2011-05-04 15:30:00	SPY	ETF	135.02	135.07	134.74	134.84	20439728.0
2011-05-04 16:00:00	SPY	ETF	134.84	135.7867	134.68	134.81	8153868.0
2011-05-04 16:30:00	SPY	ETF	134.79	134.92	134.79	134.84	1447277.0
2011-05-04 17:00:00	SPY	ETF	134.84	135.7868	134.84	134.85	1876236.0
2011-05-04 17:30:00	SPY	ETF	134.85	134.87	134.85	134.85	13585.0
2011-05-04 18:00:00	SPY	ETF	134.85	134.97	134.85	134.91	197997.0
2011-05-04 18:30:00	SPY	ETF	134.91	134.94	134.9	134.92	7002.0
2011-05-04 19:00:00	SPY	ETF	134.95	134.95	134.9	134.9	10100.0
2011-05-04 19:30:00	SPY	ETF	134.9	135.04	134.9	134.94	44972.0
2011-05-04 04:00:00	QQQ	ETF	58.57	58.57	58.57	58.57	600.0
2011-05-04 06:00:00	QQQ	ETF	58.71	58.71	58.62	58.62	86800.0
2011-05-04 06:30:00	QQQ	ETF	58.62	58.63	58.52	58.55	57800.0
2011-05-04 07:00:00	QQQ	ETF	58.55	58.58	58.55	58.58	3400.0
2011-05-04 07:30:00	QQQ	ETF	58.57	58.59	58.57	58.57	119400.0
2011-05-04 08:00:00	QQQ	ETF	58.57	58.73	58.57	58.72	1296448.0
2011-05-04 08:30:00	QQQ	ETF	58.71	58.72	58.65	58.7	105500.0
2011-05-04 09:00:00	QQQ	ETF	58.71	58.75	58.66	58.72	215498.0
2011-05-04 09:30:00	QQQ	ETF	58.72	58.87	58.64	58.69	6502658.0
2011-05-04 10:00:00	QQQ	ETF	58.68	58.68	58.5	58.61	5015413.0
2011-05-04 10:30:00	QQQ	ETF	58.6	58.65	58.37	58.4791	5910710.0
2011-05-04 11:00:00	QQQ	ETF	58.48	58.51	58.18	58.26	4087212.0
2011-05-04 11:30:00	QQQ	ETF	58.2638	58.32	58.22	58.31	1818749.0
2011-05-04 12:00:00	QQQ	ETF	58.301	58.36	58.19	58.22	1896506.0
2011-05-04 12:30:00	QQQ	ETF	58.2201	58.26	58.11	58.2364	3544724.0
2011-05-04 13:00:00	QQQ	ETF	58.23	58.42	58.22	58.38	2139202.0
2011-05-04 13:30:00	QQQ	ETF	58.3899	58.55	58.38	58.52	3237801.0
2011-05-04 14:00:00	QQQ	ETF	58.52	58.75	58.45	58.73	3434294.0

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

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