PREVIEW / etf_30min / 2011-10-24

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-24.parquet
  size:    291 KB
  rows:    9,806

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-10-24 04:00:00	SPY	ETF	124.23	124.64	124.23	124.41	44307.0
2011-10-24 04:30:00	SPY	ETF	124.28	124.28	124.05	124.1	27993.0
2011-10-24 05:00:00	SPY	ETF	124.05	124.18	123.99	124.18	28970.0
2011-10-24 05:30:00	SPY	ETF	124.23	124.43	124.2	124.4	11600.0
2011-10-24 06:00:00	SPY	ETF	124.4	124.45	124.35	124.45	5451.0
2011-10-24 06:30:00	SPY	ETF	124.48	124.48	123.85	123.9	156890.0
2011-10-24 07:00:00	SPY	ETF	123.85	124.04	123.79	123.94	452619.0
2011-10-24 07:30:00	SPY	ETF	123.9	124.15	123.88	124.09	379753.0
2011-10-24 08:00:00	SPY	ETF	124.13	124.43	123.9	124.14	912368.0
2011-10-24 08:30:00	SPY	ETF	124.13	124.5	123.95	124.42	1148502.0
2011-10-24 09:00:00	SPY	ETF	124.43	124.44	124.09	124.18	1360673.0
2011-10-24 09:30:00	SPY	ETF	124.17	124.86	124.06	124.63	21880515.0
2011-10-24 10:00:00	SPY	ETF	124.63	125.16	124.46	125.045	16437573.0
2011-10-24 10:30:00	SPY	ETF	125.0499	125.17	124.85	124.9099	13342568.0
2011-10-24 11:00:00	SPY	ETF	124.91	125.52	124.909	125.46	15083349.0
2011-10-24 11:30:00	SPY	ETF	125.465	125.59	125.29	125.36	14398761.0
2011-10-24 12:00:00	SPY	ETF	125.36	125.44	125.25	125.41	9908110.0
2011-10-24 12:30:00	SPY	ETF	125.42	125.44	125.05	125.3	8820422.0
2011-10-24 13:00:00	SPY	ETF	125.3	125.5	125.205	125.43	5690185.0
2011-10-24 13:30:00	SPY	ETF	125.43	125.8	125.4	125.67	8023342.0
2011-10-24 14:00:00	SPY	ETF	125.67	125.73	125.24	125.41	9546055.0
2011-10-24 14:30:00	SPY	ETF	125.41	125.61	125.38	125.61	7764186.0
2011-10-24 15:00:00	SPY	ETF	125.595	125.78	125.12	125.175	19007681.0
2011-10-24 15:30:00	SPY	ETF	125.18	125.63	125.09	125.5114	28589727.0
2011-10-24 16:00:00	SPY	ETF	125.48	125.75	123.938	125.28	13308554.0
2011-10-24 16:30:00	SPY	ETF	125.27	125.32	125.15	125.27	1387112.0
2011-10-24 17:00:00	SPY	ETF	125.26	125.39	125.22	125.32	617533.0
2011-10-24 17:30:00	SPY	ETF	125.32	125.37	125.3	125.35	834133.0
2011-10-24 18:00:00	SPY	ETF	125.35	125.49	125.11	125.15	570777.0
2011-10-24 18:30:00	SPY	ETF	125.17	125.22	125.08	125.08	128804.0
2011-10-24 19:00:00	SPY	ETF	125.1	125.15	125.09	125.12	76800.0
2011-10-24 19:30:00	SPY	ETF	125.13	125.2	125.1	125.2	220847.0
2011-10-24 04:00:00	QQQ	ETF	57.48	57.62	57.48	57.59	750.0
2011-10-24 05:30:00	QQQ	ETF	57.66	57.66	57.66	57.66	500.0
2011-10-24 06:00:00	QQQ	ETF	57.55	57.6	57.55	57.6	2000.0
2011-10-24 06:30:00	QQQ	ETF	57.43	57.45	57.4	57.4	4800.0
2011-10-24 07:00:00	QQQ	ETF	57.43	57.44	57.41	57.41	3700.0
2011-10-24 07:30:00	QQQ	ETF	57.43	57.51	57.43	57.46	5595.0
2011-10-24 08:00:00	QQQ	ETF	57.5	57.7	57.45	57.49	79243.0
2011-10-24 08:30:00	QQQ	ETF	57.48	57.65	57.42	57.63	181896.0
2011-10-24 09:00:00	QQQ	ETF	57.61	57.62	57.46	57.51	381274.0
2011-10-24 09:30:00	QQQ	ETF	57.51	57.93	57.45	57.81	7221687.0
2011-10-24 10:00:00	QQQ	ETF	57.81	58.1	57.6999	58.02	5602003.0
2011-10-24 10:30:00	QQQ	ETF	58.03	58.24	58.0	58.1925	6291873.0
2011-10-24 11:00:00	QQQ	ETF	58.2	58.49	58.2	58.46	4321905.0
2011-10-24 11:30:00	QQQ	ETF	58.46	58.5	58.38	58.439	2043600.0
2011-10-24 12:00:00	QQQ	ETF	58.43	58.53	58.39	58.5	1708883.0
2011-10-24 12:30:00	QQQ	ETF	58.5	58.51	58.37	58.48	2388087.0
2011-10-24 13:00:00	QQQ	ETF	58.48	58.5	58.41	58.464	1250366.0
2011-10-24 13:30:00	QQQ	ETF	58.46	58.64	58.45	58.6	2055127.0

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

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