PREVIEW / etf_30min / 2011-01-31

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-31.parquet
  size:    280 KB
  rows:    9,408

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-01-31 04:00:00	SPY	ETF	127.32	127.47	127.31	127.39	2600.0
2011-01-31 04:30:00	SPY	ETF	127.47	127.5	127.45	127.5	900.0
2011-01-31 05:00:00	SPY	ETF	127.54	127.79	127.54	127.79	13088.0
2011-01-31 05:30:00	SPY	ETF	127.78	127.85	127.78	127.85	2600.0
2011-01-31 06:00:00	SPY	ETF	127.79	127.9	127.78	127.78	16600.0
2011-01-31 06:30:00	SPY	ETF	127.77	127.83	127.72	127.74	94150.0
2011-01-31 07:00:00	SPY	ETF	127.71	127.9	127.68	127.81	469192.0
2011-01-31 07:30:00	SPY	ETF	127.85	128.12	127.85	128.03	497968.0
2011-01-31 08:00:00	SPY	ETF	128.03	128.21	127.89	128.11	558589.0
2011-01-31 08:30:00	SPY	ETF	128.11	128.19	128.05	128.17	1089823.0
2011-01-31 09:00:00	SPY	ETF	128.16	128.23	128.04	128.08	1969150.0
2011-01-31 09:30:00	SPY	ETF	128.07	128.21	127.76	127.85	22810330.0
2011-01-31 10:00:00	SPY	ETF	127.84	128.18	127.75	128.141	12266245.0
2011-01-31 10:30:00	SPY	ETF	128.15	128.31	128.06	128.2401	7854770.0
2011-01-31 11:00:00	SPY	ETF	128.25	128.4	128.22	128.3	7537528.0
2011-01-31 11:30:00	SPY	ETF	128.31	128.41	128.21	128.3202	5755092.0
2011-01-31 12:00:00	SPY	ETF	128.32	128.78	128.32	128.75	12941465.0
2011-01-31 12:30:00	SPY	ETF	128.75	128.77	128.51	128.585	5016208.0
2011-01-31 13:00:00	SPY	ETF	128.585	128.72	128.57	128.59	4892344.0
2011-01-31 13:30:00	SPY	ETF	128.59	128.63	128.44	128.54	5347827.0
2011-01-31 14:00:00	SPY	ETF	128.5401	128.65	128.34	128.35	6071364.0
2011-01-31 14:30:00	SPY	ETF	128.35	128.45	127.9195	128.42	12962648.0
2011-01-31 15:00:00	SPY	ETF	128.41	128.6	128.385	128.44	9712008.0
2011-01-31 15:30:00	SPY	ETF	128.44	128.68	128.4	128.67	17217949.0
2011-01-31 16:00:00	SPY	ETF	128.68	128.76	127.8579	128.66	10508945.0
2011-01-31 16:30:00	SPY	ETF	128.65	128.69	128.3292	128.66	1452120.0
2011-01-31 17:00:00	SPY	ETF	128.66	128.7	128.61	128.64	145558.0
2011-01-31 17:30:00	SPY	ETF	128.63	128.63	128.58	128.61	76014.0
2011-01-31 18:00:00	SPY	ETF	128.62	128.67	128.56	128.61	62019.0
2011-01-31 18:30:00	SPY	ETF	128.61	128.68	128.6	128.68	53911.0
2011-01-31 19:00:00	SPY	ETF	128.68	128.79	128.68	128.72	10125.0
2011-01-31 19:30:00	SPY	ETF	128.77	128.85	128.75	128.83	27325.0
2011-01-31 04:00:00	QQQ	ETF	55.6	55.6	55.58	55.59	700.0
2011-01-31 04:30:00	QQQ	ETF	55.67	55.69	55.67	55.69	3100.0
2011-01-31 05:00:00	QQQ	ETF	55.82	55.82	55.82	55.82	390.0
2011-01-31 05:30:00	QQQ	ETF	55.83	55.83	55.83	55.83	100.0
2011-01-31 06:00:00	QQQ	ETF	55.86	55.86	55.84	55.84	3000.0
2011-01-31 06:30:00	QQQ	ETF	55.83	55.83	55.83	55.83	2500.0
2011-01-31 07:00:00	QQQ	ETF	55.81	55.83	55.77	55.8	14300.0
2011-01-31 07:30:00	QQQ	ETF	55.84	55.92	55.84	55.87	34402.0
2011-01-31 08:00:00	QQQ	ETF	55.88	55.92	55.81	55.91	965114.0
2011-01-31 08:30:00	QQQ	ETF	55.91	55.91	55.86	55.9	169027.0
2011-01-31 09:00:00	QQQ	ETF	55.9	55.94	55.79	55.8	242953.0
2011-01-31 09:30:00	QQQ	ETF	55.81	55.89	55.39	55.465	14106625.0
2011-01-31 10:00:00	QQQ	ETF	55.46	55.68	55.43	55.65	8073993.0
2011-01-31 10:30:00	QQQ	ETF	55.65	55.77	55.64	55.74	3437078.0
2011-01-31 11:00:00	QQQ	ETF	55.74	55.87	55.71	55.83	4264995.0
2011-01-31 11:30:00	QQQ	ETF	55.83	55.89	55.78	55.85	2317346.0
2011-01-31 12:00:00	QQQ	ETF	55.85	56.16	55.84	56.14	6270252.0
2011-01-31 12:30:00	QQQ	ETF	56.14	56.1499	55.94	55.98	2294823.0

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

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