PREVIEW / etf_30min / 2011-05-05

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-05.parquet
  size:    291 KB
  rows:    9,771

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-05 04:00:00	SPY	ETF	135.08	135.19	135.08	135.14	400.0
2011-05-05 04:30:00	SPY	ETF	134.92	134.92	134.79	134.79	3500.0
2011-05-05 05:00:00	SPY	ETF	134.82	134.9	134.82	134.9	15200.0
2011-05-05 05:30:00	SPY	ETF	134.63	134.63	134.54	134.55	9800.0
2011-05-05 06:00:00	SPY	ETF	134.55	134.57	134.22	134.42	35850.0
2011-05-05 06:30:00	SPY	ETF	134.39	134.42	134.01	134.2	184180.0
2011-05-05 07:00:00	SPY	ETF	134.25	134.35	134.11	134.14	287226.0
2011-05-05 07:30:00	SPY	ETF	134.15	134.35	134.11	134.31	398955.0
2011-05-05 08:00:00	SPY	ETF	134.33	134.34	134.181	134.3	662367.0
2011-05-05 08:30:00	SPY	ETF	134.3	134.3	133.76	133.98	3430523.0
2011-05-05 09:00:00	SPY	ETF	133.98	134.12	133.68	134.08	1916944.0
2011-05-05 09:30:00	SPY	ETF	134.08	134.35	133.75	134.24	19484262.0
2011-05-05 10:00:00	SPY	ETF	134.25	134.5	133.99	134.12	15695517.0
2011-05-05 10:30:00	SPY	ETF	134.12	134.38	133.95	134.16	9472986.0
2011-05-05 11:00:00	SPY	ETF	134.17	134.24	133.69	134.05	18403268.0
2011-05-05 11:30:00	SPY	ETF	134.05	134.7	134.03	134.62	13358550.0
2011-05-05 12:00:00	SPY	ETF	134.62	134.95	134.62	134.87	9903055.0
2011-05-05 12:30:00	SPY	ETF	134.86	134.93	134.51	134.6	6242939.0
2011-05-05 13:00:00	SPY	ETF	134.6	134.8	134.58	134.66	5055069.0
2011-05-05 13:30:00	SPY	ETF	134.66	134.7	134.35	134.51	6316018.0
2011-05-05 14:00:00	SPY	ETF	134.51	134.63	134.21	134.61	5827983.0
2011-05-05 14:30:00	SPY	ETF	134.62	134.75	134.17	134.19	7675672.0
2011-05-05 15:00:00	SPY	ETF	134.18	134.22	133.02	133.04	37489817.0
2011-05-05 15:30:00	SPY	ETF	133.04	133.75	133.02	133.64	36929534.0
2011-05-05 16:00:00	SPY	ETF	133.65	134.8639	133.638	133.89	13690459.0
2011-05-05 16:30:00	SPY	ETF	133.89	134.8639	133.81	133.98	12255885.0
2011-05-05 17:00:00	SPY	ETF	133.99	134.1	133.94	134.1	136618.0
2011-05-05 17:30:00	SPY	ETF	134.08	134.08	134.03	134.06	36215.0
2011-05-05 18:00:00	SPY	ETF	134.06	134.17	133.63	134.08	154295.0
2011-05-05 18:30:00	SPY	ETF	134.08	134.11	134.02	134.03	23110.0
2011-05-05 19:00:00	SPY	ETF	134.04	134.06	133.82	133.88	74459.0
2011-05-05 19:30:00	SPY	ETF	133.85	133.89	133.77	133.88	67174.0
2011-05-05 06:30:00	QQQ	ETF	58.4	58.4	58.33	58.39	1500.0
2011-05-05 07:00:00	QQQ	ETF	58.39	58.43	58.34	58.34	2600.0
2011-05-05 07:30:00	QQQ	ETF	58.33	58.44	58.33	58.43	72850.0
2011-05-05 08:00:00	QQQ	ETF	58.42	58.46	58.4	58.46	89426.0
2011-05-05 08:30:00	QQQ	ETF	58.45	58.45	58.21	58.31	518323.0
2011-05-05 09:00:00	QQQ	ETF	58.31	58.32	58.15	58.31	713544.0
2011-05-05 09:30:00	QQQ	ETF	58.31	58.61	58.31	58.575	7647167.0
2011-05-05 10:00:00	QQQ	ETF	58.5726	58.73	58.47	58.52	5286000.0
2011-05-05 10:30:00	QQQ	ETF	58.52	58.72	58.43	58.59	3980780.0
2011-05-05 11:00:00	QQQ	ETF	58.58	58.65	58.355	58.58	6914584.0
2011-05-05 11:30:00	QQQ	ETF	58.575	58.84	58.57	58.81	4627287.0
2011-05-05 12:00:00	QQQ	ETF	58.81	58.97	58.81	58.941	3187193.0
2011-05-05 12:30:00	QQQ	ETF	58.92	58.92	58.655	58.729	4135076.0
2011-05-05 13:00:00	QQQ	ETF	58.73	58.84	58.7	58.79	1345434.0
2011-05-05 13:30:00	QQQ	ETF	58.79	58.81	58.66	58.78	1370864.0
2011-05-05 14:00:00	QQQ	ETF	58.78	58.86	58.635	58.82	3005363.0
2011-05-05 14:30:00	QQQ	ETF	58.82	58.88	58.54	58.55	3502974.0
2011-05-05 15:00:00	QQQ	ETF	58.55	58.58	58.09	58.0938	8671285.0

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

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