PREVIEW / etf_30min / 2011-04-21

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-21.parquet
  size:    273 KB
  rows:    9,297

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-04-21 04:00:00	SPY	ETF	133.9	134.06	133.89	133.89	5500.0
2011-04-21 04:30:00	SPY	ETF	134.01	134.01	133.87	133.87	5000.0
2011-04-21 05:00:00	SPY	ETF	133.96	134.09	133.96	134.09	1500.0
2011-04-21 05:30:00	SPY	ETF	134.05	134.05	133.96	133.96	26120.0
2011-04-21 06:00:00	SPY	ETF	133.96	134.15	133.93	134.02	135100.0
2011-04-21 06:30:00	SPY	ETF	134.12	134.16	133.96	134.15	71600.0
2011-04-21 07:00:00	SPY	ETF	134.13	134.21	134.08	134.16	120400.0
2011-04-21 07:30:00	SPY	ETF	134.14	134.14	134.0	134.03	343726.0
2011-04-21 08:00:00	SPY	ETF	134.04	134.13	133.87	134.0	774275.0
2011-04-21 08:30:00	SPY	ETF	133.97	133.98	133.66	133.79	2739811.0
2011-04-21 09:00:00	SPY	ETF	133.79	133.91	133.71	133.79	1903079.0
2011-04-21 09:30:00	SPY	ETF	133.79	133.79	133.5	133.6	18266493.0
2011-04-21 10:00:00	SPY	ETF	133.6	133.68	133.35	133.571	18011593.0
2011-04-21 10:30:00	SPY	ETF	133.56	133.69	133.41	133.61	8367188.0
2011-04-21 11:00:00	SPY	ETF	133.6108	133.7	133.54	133.7	5546847.0
2011-04-21 11:30:00	SPY	ETF	133.69	133.81	133.69	133.775	6449350.0
2011-04-21 12:00:00	SPY	ETF	133.775	133.8	133.71	133.75	2823940.0
2011-04-21 12:30:00	SPY	ETF	133.75	133.84	133.7	133.77	5413153.0
2011-04-21 13:00:00	SPY	ETF	133.76	133.81	133.68	133.71	2446972.0
2011-04-21 13:30:00	SPY	ETF	133.71	133.73	133.6	133.66	2918706.0
2011-04-21 14:00:00	SPY	ETF	133.6601	133.77	133.61	133.73	3795409.0
2011-04-21 14:30:00	SPY	ETF	133.73	133.76	133.6	133.621	6185922.0
2011-04-21 15:00:00	SPY	ETF	133.62	133.67	133.57	133.6	4875525.0
2011-04-21 15:30:00	SPY	ETF	133.59	133.8	133.59	133.75	15146367.0
2011-04-21 16:00:00	SPY	ETF	133.76	133.8082	133.1054	133.68	20792197.0
2011-04-21 16:30:00	SPY	ETF	133.65	133.7984	133.52	133.68	6305924.0
2011-04-21 17:00:00	SPY	ETF	133.68	133.88	133.65	133.88	370261.0
2011-04-21 17:30:00	SPY	ETF	133.85	133.94	133.78	133.8	85516.0
2011-04-21 18:00:00	SPY	ETF	133.81	133.81	133.74	133.76	48366.0
2011-04-21 18:30:00	SPY	ETF	133.76	133.81	133.75	133.81	9672.0
2011-04-21 19:00:00	SPY	ETF	133.83	133.83	133.78	133.81	2650.0
2011-04-21 19:30:00	SPY	ETF	133.77	133.83	133.72	133.83	17143.0
2011-04-21 04:00:00	QQQ	ETF	58.35	58.35	58.31	58.31	200.0
2011-04-21 04:30:00	QQQ	ETF	58.38	58.38	58.38	58.38	100.0
2011-04-21 05:00:00	QQQ	ETF	58.42	58.42	58.42	58.42	200.0
2011-04-21 05:30:00	QQQ	ETF	58.44	58.44	58.44	58.44	100.0
2011-04-21 06:00:00	QQQ	ETF	58.47	58.49	58.47	58.49	813.0
2011-04-21 06:30:00	QQQ	ETF	58.48	58.52	58.48	58.52	1313.0
2011-04-21 07:00:00	QQQ	ETF	58.53	58.56	58.52	58.52	90847.0
2011-04-21 07:30:00	QQQ	ETF	58.55	58.55	58.47	58.5	92907.0
2011-04-21 08:00:00	QQQ	ETF	58.5	58.52	58.44	58.52	160785.0
2011-04-21 08:30:00	QQQ	ETF	58.52	58.52	58.31	58.36	1965116.0
2011-04-21 09:00:00	QQQ	ETF	58.37	58.49	58.36	58.48	727584.0
2011-04-21 09:30:00	QQQ	ETF	58.47	58.47	58.2	58.36	8938692.0
2011-04-21 10:00:00	QQQ	ETF	58.3598	58.38	58.22	58.27	4793440.0
2011-04-21 10:30:00	QQQ	ETF	58.27	58.335	58.16	58.33	3425240.0
2011-04-21 11:00:00	QQQ	ETF	58.33	58.35	58.27	58.34	1688224.0
2011-04-21 11:30:00	QQQ	ETF	58.35	58.44	58.345	58.43	1836521.0
2011-04-21 12:00:00	QQQ	ETF	58.43	58.44	58.38	58.38	1002874.0
2011-04-21 12:30:00	QQQ	ETF	58.38	58.435	58.35	58.3901	967878.0

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

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