PREVIEW / etf_30min / 2011-06-01

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-01.parquet
  size:    293 KB
  rows:    9,550

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-06-01 04:00:00	SPY	ETF	135.0	135.03	134.85	135.03	600.0
2011-06-01 04:30:00	SPY	ETF	134.9	135.04	134.9	135.04	400.0
2011-06-01 05:00:00	SPY	ETF	134.84	134.88	134.84	134.88	1600.0
2011-06-01 05:30:00	SPY	ETF	134.8	134.97	134.8	134.81	4035.0
2011-06-01 06:00:00	SPY	ETF	134.82	134.88	134.5	134.69	6110.0
2011-06-01 06:30:00	SPY	ETF	134.72	134.75	134.67	134.72	57100.0
2011-06-01 07:00:00	SPY	ETF	134.77	134.81	134.65	134.78	186268.0
2011-06-01 07:30:00	SPY	ETF	134.83	134.86	134.79	134.84	105554.0
2011-06-01 08:00:00	SPY	ETF	134.84	134.87	134.27	134.46	2607635.0
2011-06-01 08:30:00	SPY	ETF	134.46	134.89	134.31	134.41	1478765.0
2011-06-01 09:00:00	SPY	ETF	134.4	134.89	134.31	134.5	1187141.0
2011-06-01 09:30:00	SPY	ETF	134.51	134.6	134.25	134.28	17483954.0
2011-06-01 10:00:00	SPY	ETF	134.28	134.28	133.66	133.69	26357912.0
2011-06-01 10:30:00	SPY	ETF	133.7	133.77	133.2	133.5	16655591.0
2011-06-01 11:00:00	SPY	ETF	133.49	133.67	133.44	133.66	8919284.0
2011-06-01 11:30:00	SPY	ETF	133.66	133.71	133.36	133.395	8249380.0
2011-06-01 12:00:00	SPY	ETF	133.38	134.9234	132.82	132.95	17878634.0
2011-06-01 12:30:00	SPY	ETF	132.95	133.16	132.92	132.98	6474001.0
2011-06-01 13:00:00	SPY	ETF	132.99	134.9234	132.5	132.62	14095407.0
2011-06-01 13:30:00	SPY	ETF	132.62	132.87	132.51	132.84	8491067.0
2011-06-01 14:00:00	SPY	ETF	132.83	132.83	132.53	132.56	8968763.0
2011-06-01 14:30:00	SPY	ETF	132.55	132.57	132.24	132.55	17747206.0
2011-06-01 15:00:00	SPY	ETF	132.55	132.64	132.09	132.26	15176575.0
2011-06-01 15:30:00	SPY	ETF	132.25	132.32	131.76	131.86	28672303.0
2011-06-01 16:00:00	SPY	ETF	131.86	131.88	131.65	131.8	16340854.0
2011-06-01 16:30:00	SPY	ETF	131.83	132.427	131.74	131.81	11432079.0
2011-06-01 17:00:00	SPY	ETF	131.8	131.84	131.59	131.61	245691.0
2011-06-01 17:30:00	SPY	ETF	131.62	131.69	131.61	131.64	41513.0
2011-06-01 18:00:00	SPY	ETF	131.64	131.85	131.5	131.55	393456.0
2011-06-01 18:30:00	SPY	ETF	131.54	131.73	131.54	131.73	31069.0
2011-06-01 19:00:00	SPY	ETF	131.73	131.84	131.73	131.81	62340.0
2011-06-01 19:30:00	SPY	ETF	131.8	131.9	131.75	131.75	155748.0
2011-06-01 04:00:00	QQQ	ETF	58.34	58.34	58.28	58.28	2565.0
2011-06-01 04:30:00	QQQ	ETF	58.18	58.18	58.18	58.18	100.0
2011-06-01 06:00:00	QQQ	ETF	58.17	58.17	58.15	58.16	700.0
2011-06-01 06:30:00	QQQ	ETF	58.16	58.16	58.16	58.16	450.0
2011-06-01 07:00:00	QQQ	ETF	58.17	58.22	58.14	58.22	140600.0
2011-06-01 07:30:00	QQQ	ETF	58.23	58.27	58.21	58.27	29264.0
2011-06-01 08:00:00	QQQ	ETF	58.27	58.36	58.01	58.1	1344549.0
2011-06-01 08:30:00	QQQ	ETF	58.11	58.11	58.06	58.09	103734.0
2011-06-01 09:00:00	QQQ	ETF	58.09	58.22	58.06	58.2	291835.0
2011-06-01 09:30:00	QQQ	ETF	58.21	58.36	58.18	58.23	3144193.0
2011-06-01 10:00:00	QQQ	ETF	58.22	58.22	58.01	58.05	6650113.0
2011-06-01 10:30:00	QQQ	ETF	58.0589	58.08	57.8813	57.96	3016631.0
2011-06-01 11:00:00	QQQ	ETF	57.96	57.97	57.81	57.9	2200679.0
2011-06-01 11:30:00	QQQ	ETF	57.91	57.91	57.78	57.7999	1383037.0
2011-06-01 12:00:00	QQQ	ETF	57.79	57.84	57.55	57.6	3364891.0
2011-06-01 12:30:00	QQQ	ETF	57.6	57.71	57.6	57.695	1158101.0
2011-06-01 13:00:00	QQQ	ETF	57.6901	57.765	57.47	57.505	3727107.0
2011-06-01 13:30:00	QQQ	ETF	57.51	57.6098	57.44	57.57	2232254.0

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

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