PREVIEW / etf_30min / 2011-04-26

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-26.parquet
  size:    283 KB
  rows:    9,496

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-26 04:00:00	SPY	ETF	133.76	133.92	133.76	133.86	3500.0
2011-04-26 04:30:00	SPY	ETF	133.91	134.03	133.91	134.03	1300.0
2011-04-26 05:00:00	SPY	ETF	133.94	134.18	133.94	134.18	4600.0
2011-04-26 05:30:00	SPY	ETF	134.12	134.12	134.1	134.11	700.0
2011-04-26 06:00:00	SPY	ETF	134.09	134.09	133.99	133.99	900.0
2011-04-26 06:30:00	SPY	ETF	133.98	134.02	133.98	134.0	112770.0
2011-04-26 07:00:00	SPY	ETF	134.01	134.02	133.9	133.96	44215.0
2011-04-26 07:30:00	SPY	ETF	133.99	134.16	133.95	134.16	261825.0
2011-04-26 08:00:00	SPY	ETF	134.13	134.16	134.02	134.09	714646.0
2011-04-26 08:30:00	SPY	ETF	134.07	134.14	134.03	134.08	525136.0
2011-04-26 09:00:00	SPY	ETF	134.08	134.18	134.05	134.05	912341.0
2011-04-26 09:30:00	SPY	ETF	134.05	134.26	133.91	134.14	15656123.0
2011-04-26 10:00:00	SPY	ETF	134.14	134.41	133.96	134.33	12592168.0
2011-04-26 10:30:00	SPY	ETF	134.32	134.66	134.32	134.65	10527993.0
2011-04-26 11:00:00	SPY	ETF	134.65	134.8	134.61	134.74	7158698.0
2011-04-26 11:30:00	SPY	ETF	134.75	134.94	134.745	134.93	8211686.0
2011-04-26 12:00:00	SPY	ETF	134.93	135.06	134.84	134.867	9533522.0
2011-04-26 12:30:00	SPY	ETF	134.87	134.93	134.81	134.86	5336074.0
2011-04-26 13:00:00	SPY	ETF	134.86	134.87	134.72	134.7501	7078920.0
2011-04-26 13:30:00	SPY	ETF	134.75	134.76	134.61	134.7	5532149.0
2011-04-26 14:00:00	SPY	ETF	134.71	134.85	134.65	134.845	4096360.0
2011-04-26 14:30:00	SPY	ETF	134.84	134.86	134.79	134.84	6593020.0
2011-04-26 15:00:00	SPY	ETF	134.845	134.99	134.77	134.77	8131126.0
2011-04-26 15:30:00	SPY	ETF	134.78	134.82	134.7	134.78	20179458.0
2011-04-26 16:00:00	SPY	ETF	134.79	134.8156	133.5941	134.62	16148873.0
2011-04-26 16:30:00	SPY	ETF	134.61	134.75	134.47	134.66	3562855.0
2011-04-26 17:00:00	SPY	ETF	134.66	134.85	134.6	134.66	138204.0
2011-04-26 17:30:00	SPY	ETF	134.7	134.7	134.65	134.7	48006.0
2011-04-26 18:00:00	SPY	ETF	134.66	134.79	134.62	134.7	152164.0
2011-04-26 18:30:00	SPY	ETF	134.69	134.72	134.68	134.72	12889.0
2011-04-26 19:00:00	SPY	ETF	134.71	134.72	134.71	134.71	7500.0
2011-04-26 19:30:00	SPY	ETF	134.72	134.77	134.7	134.77	15794.0
2011-04-26 04:30:00	QQQ	ETF	58.6	58.6	58.6	58.6	100.0
2011-04-26 05:00:00	QQQ	ETF	58.62	58.69	58.62	58.69	200.0
2011-04-26 05:30:00	QQQ	ETF	58.64	58.64	58.64	58.64	100.0
2011-04-26 06:00:00	QQQ	ETF	58.62	58.62	58.62	58.62	400.0
2011-04-26 06:30:00	QQQ	ETF	58.6	58.6	58.6	58.6	300.0
2011-04-26 07:00:00	QQQ	ETF	58.62	58.62	58.57	58.58	10700.0
2011-04-26 07:30:00	QQQ	ETF	58.64	58.66	58.63	58.66	4013.0
2011-04-26 08:00:00	QQQ	ETF	58.65	58.66	58.62	58.63	25462.0
2011-04-26 08:30:00	QQQ	ETF	58.63	58.65	58.61	58.63	45310.0
2011-04-26 09:00:00	QQQ	ETF	58.63	58.68	58.62	58.65	128933.0
2011-04-26 09:30:00	QQQ	ETF	58.65	58.73	58.51	58.69	5738802.0
2011-04-26 10:00:00	QQQ	ETF	58.69	58.72	58.57	58.669	3500946.0
2011-04-26 10:30:00	QQQ	ETF	58.67	58.9	58.65	58.9	3771112.0
2011-04-26 11:00:00	QQQ	ETF	58.9	58.92	58.835	58.885	1439222.0
2011-04-26 11:30:00	QQQ	ETF	58.89	58.95	58.87	58.95	1457037.0
2011-04-26 12:00:00	QQQ	ETF	58.95	59.03	58.91	58.92	3929173.0
2011-04-26 12:30:00	QQQ	ETF	58.92	58.94	58.84	58.8402	1518381.0
2011-04-26 13:00:00	QQQ	ETF	58.843	58.85	58.72	58.74	1224288.0

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

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