PREVIEW / etf_30min / 2011-05-18

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-18.parquet
  size:    278 KB
  rows:    9,179

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-18 04:00:00	SPY	ETF	133.3	133.62	133.3	133.52	1300.0
2011-05-18 04:30:00	SPY	ETF	133.57	133.63	133.57	133.63	500.0
2011-05-18 05:00:00	SPY	ETF	133.45	133.45	133.37	133.45	4950.0
2011-05-18 05:30:00	SPY	ETF	133.42	133.42	133.39	133.42	3600.0
2011-05-18 06:00:00	SPY	ETF	133.37	133.42	133.36	133.42	2250.0
2011-05-18 06:30:00	SPY	ETF	133.48	133.5	133.34	133.4	187250.0
2011-05-18 07:00:00	SPY	ETF	133.35	133.42	133.28	133.35	105150.0
2011-05-18 07:30:00	SPY	ETF	133.35	133.36	133.11	133.23	197465.0
2011-05-18 08:00:00	SPY	ETF	133.22	133.35	132.96	133.07	1289218.0
2011-05-18 08:30:00	SPY	ETF	133.05	133.25	132.99	133.23	1360193.0
2011-05-18 09:00:00	SPY	ETF	133.22	133.31	133.14	133.24	689435.0
2011-05-18 09:30:00	SPY	ETF	133.24	133.49	132.95	133.26	15675664.0
2011-05-18 10:00:00	SPY	ETF	133.255	133.55	133.22	133.51	7516448.0
2011-05-18 10:30:00	SPY	ETF	133.51	133.88	133.51	133.75	12352367.0
2011-05-18 11:00:00	SPY	ETF	133.75	133.93	133.65	133.74	6937252.0
2011-05-18 11:30:00	SPY	ETF	133.74	133.84	133.7	133.78	4875631.0
2011-05-18 12:00:00	SPY	ETF	133.785	133.88	133.67	133.88	4985930.0
2011-05-18 12:30:00	SPY	ETF	133.88	133.95	133.83	133.88	4306265.0
2011-05-18 13:00:00	SPY	ETF	133.88	134.19	133.87	134.04	6818771.0
2011-05-18 13:30:00	SPY	ETF	134.03	134.39	134.01	134.32	6788458.0
2011-05-18 14:00:00	SPY	ETF	134.32	134.49	134.03	134.1	11986189.0
2011-05-18 14:30:00	SPY	ETF	134.1	134.25	133.97	134.02	8361456.0
2011-05-18 15:00:00	SPY	ETF	134.02	134.4	133.99	134.39	7010412.0
2011-05-18 15:30:00	SPY	ETF	134.39	134.5	134.28	134.37	14776849.0
2011-05-18 16:00:00	SPY	ETF	134.37	134.52	133.2073	134.35	14456812.0
2011-05-18 16:30:00	SPY	ETF	134.34	134.42	133.9735	134.4	164531.0
2011-05-18 17:00:00	SPY	ETF	134.42	134.5	133.2073	134.43	1601037.0
2011-05-18 17:30:00	SPY	ETF	134.45	134.52	134.43	134.49	37985.0
2011-05-18 18:00:00	SPY	ETF	134.47	134.49	134.38	134.48	129713.0
2011-05-18 18:30:00	SPY	ETF	134.49	134.54	134.46	134.46	23873.0
2011-05-18 19:00:00	SPY	ETF	134.43	134.5	134.43	134.5	16215.0
2011-05-18 19:30:00	SPY	ETF	134.51	134.51	134.41	134.43	34941.0
2011-05-18 06:30:00	QQQ	ETF	57.64	57.64	57.6	57.6	1800.0
2011-05-18 07:00:00	QQQ	ETF	57.59	57.59	57.54	57.54	8400.0
2011-05-18 07:30:00	QQQ	ETF	57.56	57.57	57.43	57.46	80357.0
2011-05-18 08:00:00	QQQ	ETF	57.49	57.49	57.36	57.43	276854.0
2011-05-18 08:30:00	QQQ	ETF	57.43	57.49	57.38	57.49	87370.0
2011-05-18 09:00:00	QQQ	ETF	57.49	57.52	57.45	57.5	79506.0
2011-05-18 09:30:00	QQQ	ETF	57.49	57.64	57.41	57.495	4937792.0
2011-05-18 10:00:00	QQQ	ETF	57.51	57.66	57.485	57.635	2527496.0
2011-05-18 10:30:00	QQQ	ETF	57.635	57.73	57.63	57.66	3089319.0
2011-05-18 11:00:00	QQQ	ETF	57.665	57.76	57.66	57.72	1645966.0
2011-05-18 11:30:00	QQQ	ETF	57.715	57.72	57.68	57.7099	842381.0
2011-05-18 12:00:00	QQQ	ETF	57.71	57.76	57.64	57.75	1800245.0
2011-05-18 12:30:00	QQQ	ETF	57.76	57.82	57.7515	57.78	1590518.0
2011-05-18 13:00:00	QQQ	ETF	57.77	57.91	57.77	57.86	2233507.0
2011-05-18 13:30:00	QQQ	ETF	57.8585	58.04	57.8413	58.0	1437191.0
2011-05-18 14:00:00	QQQ	ETF	58.0	58.14	57.96	58.03	3234135.0
2011-05-18 14:30:00	QQQ	ETF	58.025	58.08	57.97	58.0	1223039.0
2011-05-18 15:00:00	QQQ	ETF	58.0	58.1	57.98	58.1	1200095.0

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

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