PREVIEW / etf_30min / 2011-09-16

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-16.parquet
  size:    271 KB
  rows:    9,041

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-16 04:00:00	SPY	ETF	120.6	120.6	120.15	120.18	16335.0
2011-09-16 04:30:00	SPY	ETF	120.12	120.33	120.12	120.15	5474.0
2011-09-16 05:00:00	SPY	ETF	120.36	120.57	120.36	120.55	12786.0
2011-09-16 05:30:00	SPY	ETF	120.47	120.7	120.47	120.68	1500.0
2011-09-16 06:00:00	SPY	ETF	120.61	120.61	120.3	120.5	40300.0
2011-09-16 06:30:00	SPY	ETF	120.5	120.98	120.5	120.65	72430.0
2011-09-16 07:00:00	SPY	ETF	120.65	120.78	120.45	120.62	899479.0
2011-09-16 07:30:00	SPY	ETF	120.61	120.7	120.23	120.52	532455.0
2011-09-16 08:00:00	SPY	ETF	120.52	120.63	120.22	120.47	1810420.0
2011-09-16 08:30:00	SPY	ETF	120.46	120.95	120.43	120.87	2108261.0
2011-09-16 09:00:00	SPY	ETF	120.87	121.41	120.76	121.29	4235246.0
2011-09-16 09:30:00	SPY	ETF	121.29	121.97	121.2	121.47	39784256.0
2011-09-16 10:00:00	SPY	ETF	121.48	121.94	121.12	121.18	26142035.0
2011-09-16 10:30:00	SPY	ETF	121.17	121.3	120.32	120.65	30342301.0
2011-09-16 11:00:00	SPY	ETF	120.64	121.0	120.49	120.67	18868239.0
2011-09-16 11:30:00	SPY	ETF	120.67	121.5714	120.38	121.16	17957240.0
2011-09-16 12:00:00	SPY	ETF	121.17	121.31	121.04	121.225	10963580.0
2011-09-16 12:30:00	SPY	ETF	121.21	121.63	121.16	121.4112	10778706.0
2011-09-16 13:00:00	SPY	ETF	121.4111	121.44	121.15	121.24	7721035.0
2011-09-16 13:30:00	SPY	ETF	121.24	121.24	120.8	121.05	10684802.0
2011-09-16 14:00:00	SPY	ETF	121.06	121.27	121.0	121.02	8612241.0
2011-09-16 14:30:00	SPY	ETF	121.02	121.43	121.02	121.42	10315708.0
2011-09-16 15:00:00	SPY	ETF	121.42	121.45	120.95	120.99	12498463.0
2011-09-16 15:30:00	SPY	ETF	120.98	121.58	120.96	121.52	41212025.0
2011-09-16 16:00:00	SPY	ETF	121.52	121.825	121.05	121.66	12926966.0
2011-09-16 16:30:00	SPY	ETF	121.65	121.78	120.823	121.7	11964446.0
2011-09-16 17:00:00	SPY	ETF	121.7	121.78	121.66	121.73	369368.0
2011-09-16 17:30:00	SPY	ETF	121.74	121.75	121.63	121.67	68049.0
2011-09-16 18:00:00	SPY	ETF	121.72	121.76	121.58	121.72	85407.0
2011-09-16 18:30:00	SPY	ETF	121.73	121.74	121.5	121.5	206854.0
2011-09-16 19:00:00	SPY	ETF	121.5	121.5	121.36	121.39	138372.0
2011-09-16 19:30:00	SPY	ETF	121.37	121.42	121.2	121.25	222899.0
2011-09-16 04:00:00	QQQ	ETF	56.05	56.05	55.9	55.9	1900.0
2011-09-16 05:00:00	QQQ	ETF	56.02	56.02	56.02	56.02	100.0
2011-09-16 05:30:00	QQQ	ETF	56.0	56.0	56.0	56.0	142.0
2011-09-16 06:00:00	QQQ	ETF	55.98	56.03	55.95	56.03	13815.0
2011-09-16 06:30:00	QQQ	ETF	56.16	56.16	56.16	56.16	800.0
2011-09-16 07:00:00	QQQ	ETF	56.08	56.1	55.99	56.06	10831.0
2011-09-16 07:30:00	QQQ	ETF	56.09	56.13	55.93	55.97	67396.0
2011-09-16 08:00:00	QQQ	ETF	56.02	56.04	55.92	55.98	198640.0
2011-09-16 08:30:00	QQQ	ETF	56.0	56.18	55.98	56.18	241856.0
2011-09-16 09:00:00	QQQ	ETF	56.17	56.29	56.11	56.26	1026348.0
2011-09-16 09:30:00	QQQ	ETF	56.26	56.52	56.16	56.36	22397978.0
2011-09-16 10:00:00	QQQ	ETF	56.36	56.65	56.3	56.39	7570004.0
2011-09-16 10:30:00	QQQ	ETF	56.38	56.46	56.09	56.2	6232912.0
2011-09-16 11:00:00	QQQ	ETF	56.21	56.38	56.17	56.27	3954563.0
2011-09-16 11:30:00	QQQ	ETF	56.27	56.52	56.17	56.4695	3111133.0
2011-09-16 12:00:00	QQQ	ETF	56.47	56.54	56.39	56.49	3883480.0
2011-09-16 12:30:00	QQQ	ETF	56.49	56.6201	56.475	56.53	2100797.0
2011-09-16 13:00:00	QQQ	ETF	56.53	56.54	56.41	56.47	2659507.0

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

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