PREVIEW / etf_30min / 2011-05-13

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-13.parquet
  size:    282 KB
  rows:    9,232

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-13 06:00:00	SPY	ETF	135.32	135.73	135.32	135.43	34296.0
2011-05-13 06:30:00	SPY	ETF	135.43	135.5	135.38	135.5	43446.0
2011-05-13 07:00:00	SPY	ETF	135.49	135.49	135.35	135.39	62217.0
2011-05-13 07:30:00	SPY	ETF	135.38	135.48	135.38	135.45	32689.0
2011-05-13 08:00:00	SPY	ETF	135.45	135.58	135.04	135.51	564975.0
2011-05-13 08:30:00	SPY	ETF	135.5	135.73	135.27	135.39	1249941.0
2011-05-13 09:00:00	SPY	ETF	135.38	135.41	135.05	135.16	2009727.0
2011-05-13 09:30:00	SPY	ETF	135.15	135.34	134.83	134.91	15611674.0
2011-05-13 10:00:00	SPY	ETF	134.9	135.05	134.57	134.95	14354259.0
2011-05-13 10:30:00	SPY	ETF	134.94	135.19	134.79	134.84	7870959.0
2011-05-13 11:00:00	SPY	ETF	134.84	134.84	134.27	134.38	16199243.0
2011-05-13 11:30:00	SPY	ETF	134.37	134.51	134.08	134.16	7851063.0
2011-05-13 12:00:00	SPY	ETF	134.15	134.24	133.56	133.92	19368854.0
2011-05-13 12:30:00	SPY	ETF	133.92	134.06	133.82	133.89	9846550.0
2011-05-13 13:00:00	SPY	ETF	133.89	134.13	133.8	133.96	6016539.0
2011-05-13 13:30:00	SPY	ETF	133.96	134.0622	133.76	133.89	4693209.0
2011-05-13 14:00:00	SPY	ETF	133.89	134.3399	133.835	134.25	6356319.0
2011-05-13 14:30:00	SPY	ETF	134.25	134.34	134.05	134.0908	6717361.0
2011-05-13 15:00:00	SPY	ETF	134.09	134.27	133.88	133.97	8045842.0
2011-05-13 15:30:00	SPY	ETF	133.97	135.1069	133.88	134.03	18087613.0
2011-05-13 16:00:00	SPY	ETF	134.02	134.8847	133.78	133.81	9630039.0
2011-05-13 16:30:00	SPY	ETF	133.82	133.92	133.82	133.91	368616.0
2011-05-13 17:00:00	SPY	ETF	133.93	134.0	133.63	133.95	374103.0
2011-05-13 17:30:00	SPY	ETF	133.95	134.06	133.95	134.01	46998.0
2011-05-13 18:00:00	SPY	ETF	134.02	134.04	133.93	133.95	76774.0
2011-05-13 18:30:00	SPY	ETF	133.97	133.97	133.84	133.84	18453.0
2011-05-13 19:00:00	SPY	ETF	133.9	133.9	133.85	133.85	2779.0
2011-05-13 19:30:00	SPY	ETF	133.87	133.87	133.8	133.84	10631.0
2011-05-13 04:00:00	QQQ	ETF	59.25	59.25	59.25	59.25	100.0
2011-05-13 05:00:00	QQQ	ETF	59.2	59.2	59.2	59.2	1000.0
2011-05-13 05:30:00	QQQ	ETF	59.12	59.18	59.12	59.18	27500.0
2011-05-13 06:30:00	QQQ	ETF	59.2	59.2	59.16	59.16	3400.0
2011-05-13 07:00:00	QQQ	ETF	59.19	59.19	59.19	59.19	200.0
2011-05-13 07:30:00	QQQ	ETF	59.22	59.22	59.21	59.21	1573.0
2011-05-13 08:00:00	QQQ	ETF	59.22	59.26	59.18	59.24	46150.0
2011-05-13 08:30:00	QQQ	ETF	59.23	59.3	59.1	59.15	259529.0
2011-05-13 09:00:00	QQQ	ETF	59.15	59.15	58.97	58.98	776147.0
2011-05-13 09:30:00	QQQ	ETF	58.98	59.04	58.84	58.8999	5933185.0
2011-05-13 10:00:00	QQQ	ETF	58.89	59.01	58.75	58.97	4696069.0
2011-05-13 10:30:00	QQQ	ETF	58.971	59.07	58.91	58.9294	2083979.0
2011-05-13 11:00:00	QQQ	ETF	58.92	58.92	58.55	58.61	7537728.0
2011-05-13 11:30:00	QQQ	ETF	58.61	58.71	58.55	58.595	2851652.0
2011-05-13 12:00:00	QQQ	ETF	58.605	58.65	58.39	58.5262	9144528.0
2011-05-13 12:30:00	QQQ	ETF	58.5284	58.58	58.46	58.47	4127242.0
2011-05-13 13:00:00	QQQ	ETF	58.48	58.58	58.45	58.5	1714623.0
2011-05-13 13:30:00	QQQ	ETF	58.5	58.5201	58.43	58.48	1095207.0
2011-05-13 14:00:00	QQQ	ETF	58.48	58.64	58.46	58.6	1833287.0
2011-05-13 14:30:00	QQQ	ETF	58.609	58.66	58.52	58.54	2656492.0
2011-05-13 15:00:00	QQQ	ETF	58.55	58.61	58.4	58.44	2556766.0
2011-05-13 15:30:00	QQQ	ETF	58.44	58.5199	58.39	58.41	5202771.0

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

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