PREVIEW / etf_30min / 2012-09-20

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-20.parquet
  size:    288 KB
  rows:    9,793

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
2012-09-20 04:00:00	SPY	ETF	146.19	146.19	146.0	146.0	3116.0
2012-09-20 04:30:00	SPY	ETF	146.19	146.19	146.12	146.14	500.0
2012-09-20 05:00:00	SPY	ETF	146.15	146.15	145.98	146.03	31520.0
2012-09-20 05:30:00	SPY	ETF	146.09	146.15	146.09	146.15	4000.0
2012-09-20 06:00:00	SPY	ETF	146.15	146.2	146.14	146.18	26100.0
2012-09-20 06:30:00	SPY	ETF	146.21	146.25	146.18	146.19	53739.0
2012-09-20 07:00:00	SPY	ETF	146.17	146.3	146.17	146.21	99266.0
2012-09-20 07:30:00	SPY	ETF	146.21	146.21	146.1	146.18	193800.0
2012-09-20 08:00:00	SPY	ETF	146.18	146.21	146.08	146.15	279176.0
2012-09-20 08:30:00	SPY	ETF	146.15	146.15	145.86	146.01	918094.0
2012-09-20 09:00:00	SPY	ETF	146.02	146.08	145.96	146.03	845996.0
2012-09-20 09:30:00	SPY	ETF	146.03	146.15	145.63	145.72	23574322.0
2012-09-20 10:00:00	SPY	ETF	145.73	146.16	145.7	146.059	12199412.0
2012-09-20 10:30:00	SPY	ETF	146.059	146.41	146.04	146.38	9567685.0
2012-09-20 11:00:00	SPY	ETF	146.37	146.51	146.19	146.27	6089959.0
2012-09-20 11:30:00	SPY	ETF	146.27	146.47	146.23	146.44	5673825.0
2012-09-20 12:00:00	SPY	ETF	146.445	146.55	146.25	146.27	5401559.0
2012-09-20 12:30:00	SPY	ETF	146.27	146.34	146.15	146.25	5968655.0
2012-09-20 13:00:00	SPY	ETF	146.25	146.4	146.18	146.39	6677301.0
2012-09-20 13:30:00	SPY	ETF	146.4	146.54	146.36	146.41	5544527.0
2012-09-20 14:00:00	SPY	ETF	146.41	146.62	146.36	146.53	7881460.0
2012-09-20 14:30:00	SPY	ETF	146.53	146.62	146.47	146.54	7055410.0
2012-09-20 15:00:00	SPY	ETF	146.54	146.79	146.525	146.72	6624590.0
2012-09-20 15:30:00	SPY	ETF	146.73	146.75	146.45	146.72	15443087.0
2012-09-20 16:00:00	SPY	ETF	146.72	146.7631	146.0	146.71	6899829.0
2012-09-20 16:30:00	SPY	ETF	146.72	146.85	146.53	146.84	9465739.0
2012-09-20 17:00:00	SPY	ETF	146.83	146.85	146.77	146.82	229165.0
2012-09-20 17:30:00	SPY	ETF	146.81	146.85	146.79	146.84	4524852.0
2012-09-20 18:00:00	SPY	ETF	146.85	146.94	146.84	146.87	62362.0
2012-09-20 18:30:00	SPY	ETF	146.87	146.87	146.84	146.86	15265.0
2012-09-20 19:00:00	SPY	ETF	146.86	146.92	146.85	146.91	11787.0
2012-09-20 19:30:00	SPY	ETF	146.88	146.9	146.85	146.85	27355.0
2012-09-20 04:00:00	QQQ	ETF	70.04	70.04	70.04	70.04	100.0
2012-09-20 05:00:00	QQQ	ETF	70.02	70.02	70.02	70.02	200.0
2012-09-20 05:30:00	QQQ	ETF	70.06	70.06	70.06	70.06	150.0
2012-09-20 07:00:00	QQQ	ETF	70.15	70.15	70.15	70.15	600.0
2012-09-20 07:30:00	QQQ	ETF	70.11	70.12	70.07	70.12	800.0
2012-09-20 08:00:00	QQQ	ETF	70.1	70.13	70.08	70.11	30026.0
2012-09-20 08:30:00	QQQ	ETF	70.11	70.11	69.95	70.06	278521.0
2012-09-20 09:00:00	QQQ	ETF	70.06	70.06	70.03	70.06	174822.0
2012-09-20 09:30:00	QQQ	ETF	70.07	70.15	69.87	69.91	4089619.0
2012-09-20 10:00:00	QQQ	ETF	69.91	70.12	69.89	70.1	2070384.0
2012-09-20 10:30:00	QQQ	ETF	70.1	70.25	70.07	70.23	3121499.0
2012-09-20 11:00:00	QQQ	ETF	70.23	70.28	70.18	70.2	1715478.0
2012-09-20 11:30:00	QQQ	ETF	70.2	70.24	70.15	70.23	705008.0
2012-09-20 12:00:00	QQQ	ETF	70.23	70.2617	70.11	70.12	935603.0
2012-09-20 12:30:00	QQQ	ETF	70.1101	70.15	70.07	70.132	1029579.0
2012-09-20 13:00:00	QQQ	ETF	70.13	70.24	70.11	70.23	618162.0
2012-09-20 13:30:00	QQQ	ETF	70.23	70.29	70.2	70.2108	665850.0
2012-09-20 14:00:00	QQQ	ETF	70.22	70.325	70.182	70.2801	832405.0

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

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