PREVIEW / etf_30min / 2011-09-27

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-27.parquet
  size:    296 KB
  rows:    9,962

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-09-27 04:00:00	SPY	ETF	116.7	117.69	116.7	117.64	6282.0
2011-09-27 04:30:00	SPY	ETF	117.45	117.61	117.33	117.54	25850.0
2011-09-27 05:00:00	SPY	ETF	117.62	117.7	117.53	117.68	9760.0
2011-09-27 05:30:00	SPY	ETF	117.66	117.9	117.6	117.8	32236.0
2011-09-27 06:00:00	SPY	ETF	117.78	118.0	117.7	117.84	36667.0
2011-09-27 06:30:00	SPY	ETF	117.75	118.0	117.63	117.97	209190.0
2011-09-27 07:00:00	SPY	ETF	118.0	118.19	117.83	118.1	808204.0
2011-09-27 07:30:00	SPY	ETF	118.09	118.52	118.09	118.3	857801.0
2011-09-27 08:00:00	SPY	ETF	118.31	118.45	117.91	118.36	1179559.0
2011-09-27 08:30:00	SPY	ETF	118.37	118.4	118.1	118.39	1394602.0
2011-09-27 09:00:00	SPY	ETF	118.38	118.66	118.29	118.53	4078057.0
2011-09-27 09:30:00	SPY	ETF	118.53	118.95	118.18	118.84	34583504.0
2011-09-27 10:00:00	SPY	ETF	118.84	119.09	118.33	118.77	29333483.0
2011-09-27 10:30:00	SPY	ETF	118.78	119.26	118.52	119.23	16968894.0
2011-09-27 11:00:00	SPY	ETF	119.24	119.26	118.77	118.8505	14561172.0
2011-09-27 11:30:00	SPY	ETF	118.86	119.07	118.66	118.89	11278575.0
2011-09-27 12:00:00	SPY	ETF	118.88	119.28	118.83	119.04	11499951.0
2011-09-27 12:30:00	SPY	ETF	119.04	119.05	118.64	118.84	9391432.0
2011-09-27 13:00:00	SPY	ETF	118.84	119.13	118.72	119.0585	9706649.0
2011-09-27 13:30:00	SPY	ETF	119.05	119.4	118.82	119.3	11215241.0
2011-09-27 14:00:00	SPY	ETF	119.29	119.56	119.25	119.25	12078295.0
2011-09-27 14:30:00	SPY	ETF	119.25	119.43	118.98	119.05	13250017.0
2011-09-27 15:00:00	SPY	ETF	119.05	119.051	117.79	117.98	35551954.0
2011-09-27 15:30:00	SPY	ETF	117.975	118.2099	116.84	117.55	54986384.0
2011-09-27 16:00:00	SPY	ETF	117.56	118.8844	116.2357	117.5	30283510.0
2011-09-27 16:30:00	SPY	ETF	117.5	117.66	117.42	117.57	3568407.0
2011-09-27 17:00:00	SPY	ETF	117.55	117.65	117.44	117.58	166774.0
2011-09-27 17:30:00	SPY	ETF	117.54	117.69	117.54	117.56	37145.0
2011-09-27 18:00:00	SPY	ETF	117.55	117.6	117.36	117.39	212900.0
2011-09-27 18:30:00	SPY	ETF	117.4	117.44	117.35	117.39	92132.0
2011-09-27 19:00:00	SPY	ETF	117.38	117.44	117.34	117.44	58463.0
2011-09-27 19:30:00	SPY	ETF	117.46	117.56	117.34	117.42	158644.0
2011-09-27 04:00:00	QQQ	ETF	55.0	55.26	55.0	55.26	3285.0
2011-09-27 04:30:00	QQQ	ETF	55.21	55.29	55.21	55.29	1950.0
2011-09-27 05:00:00	QQQ	ETF	55.32	55.32	55.29	55.29	2100.0
2011-09-27 05:30:00	QQQ	ETF	55.34	55.37	55.34	55.37	1600.0
2011-09-27 06:00:00	QQQ	ETF	55.37	55.44	55.37	55.44	600.0
2011-09-27 06:30:00	QQQ	ETF	55.36	55.43	55.33	55.36	2088.0
2011-09-27 07:00:00	QQQ	ETF	55.41	55.54	55.4	55.53	177875.0
2011-09-27 07:30:00	QQQ	ETF	55.53	55.73	55.53	55.57	219249.0
2011-09-27 08:00:00	QQQ	ETF	55.58	55.66	55.55	55.64	130997.0
2011-09-27 08:30:00	QQQ	ETF	55.64	55.64	55.51	55.6	489020.0
2011-09-27 09:00:00	QQQ	ETF	55.6	55.76	55.59	55.7	776715.0
2011-09-27 09:30:00	QQQ	ETF	55.7	55.74	55.35	55.68	9880007.0
2011-09-27 10:00:00	QQQ	ETF	55.66	55.8	55.36	55.58	7816471.0
2011-09-27 10:30:00	QQQ	ETF	55.58	55.97	55.485	55.95	4309072.0
2011-09-27 11:00:00	QQQ	ETF	55.96	55.97	55.73	55.78	4637355.0
2011-09-27 11:30:00	QQQ	ETF	55.775	55.88	55.63	55.721	2469525.0
2011-09-27 12:00:00	QQQ	ETF	55.73	55.99	55.69	55.85	3877476.0
2011-09-27 12:30:00	QQQ	ETF	55.85	55.85	55.59	55.74	2720418.0

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

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