PREVIEW / etf_30min / 2011-11-18

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-18.parquet
  size:    273 KB
  rows:    9,212

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-11-18 04:00:00	SPY	ETF	122.12	122.65	122.12	122.65	16925.0
2011-11-18 04:30:00	SPY	ETF	122.66	122.74	122.62	122.72	8160.0
2011-11-18 05:00:00	SPY	ETF	122.76	122.85	122.68	122.68	18154.0
2011-11-18 05:30:00	SPY	ETF	122.4	122.52	122.4	122.52	25200.0
2011-11-18 06:00:00	SPY	ETF	122.54	122.54	122.28	122.37	18965.0
2011-11-18 06:30:00	SPY	ETF	122.39	122.9	122.37	122.89	96760.0
2011-11-18 07:00:00	SPY	ETF	122.89	123.25	122.77	123.22	424327.0
2011-11-18 07:30:00	SPY	ETF	123.25	123.54	123.04	123.07	1407510.0
2011-11-18 08:00:00	SPY	ETF	123.07	123.5	122.72	122.87	956086.0
2011-11-18 08:30:00	SPY	ETF	122.87	123.05	122.81	122.99	1103134.0
2011-11-18 09:00:00	SPY	ETF	122.97	123.09	122.5	122.52	2563912.0
2011-11-18 09:30:00	SPY	ETF	122.5	122.65	121.86	122.34	31431666.0
2011-11-18 10:00:00	SPY	ETF	122.337	122.5205	121.73	121.9611	29557911.0
2011-11-18 10:30:00	SPY	ETF	122.01	122.75	121.95	122.49	16424363.0
2011-11-18 11:00:00	SPY	ETF	122.49	122.56	122.18	122.31	9388629.0
2011-11-18 11:30:00	SPY	ETF	122.31	122.39	121.9	121.99	9251985.0
2011-11-18 12:00:00	SPY	ETF	121.99	122.01	121.47	121.85	13842896.0
2011-11-18 12:30:00	SPY	ETF	121.84	122.07	121.82	121.85	6945927.0
2011-11-18 13:00:00	SPY	ETF	121.85	122.24	121.8	122.17	11590452.0
2011-11-18 13:30:00	SPY	ETF	122.17	122.48	122.16	122.26	8389316.0
2011-11-18 14:00:00	SPY	ETF	122.27	122.59	122.07	122.23	11645711.0
2011-11-18 14:30:00	SPY	ETF	122.23	122.44	122.0	122.07	8017293.0
2011-11-18 15:00:00	SPY	ETF	122.08	122.26	121.92	122.0398	10433226.0
2011-11-18 15:30:00	SPY	ETF	122.031	122.24	121.88	121.98	26559862.0
2011-11-18 16:00:00	SPY	ETF	121.98	122.4231	121.85	121.91	9993718.0
2011-11-18 16:30:00	SPY	ETF	121.9	122.0	121.8503	121.97	680790.0
2011-11-18 17:00:00	SPY	ETF	121.97	122.07	121.97	121.98	364714.0
2011-11-18 17:30:00	SPY	ETF	121.97	122.05	121.92	122.03	237739.0
2011-11-18 18:00:00	SPY	ETF	122.04	122.11	121.97	122.1	246771.0
2011-11-18 18:30:00	SPY	ETF	122.1	122.12	122.1	122.11	35402.0
2011-11-18 19:00:00	SPY	ETF	122.11	122.14	122.02	122.02	24821.0
2011-11-18 19:30:00	SPY	ETF	122.02	122.12	121.93	122.12	227544.0
2011-11-18 04:00:00	QQQ	ETF	55.83	55.9	55.83	55.9	2048.0
2011-11-18 04:30:00	QQQ	ETF	55.96	55.99	55.96	55.97	1970.0
2011-11-18 05:00:00	QQQ	ETF	55.98	55.98	55.98	55.98	100.0
2011-11-18 05:30:00	QQQ	ETF	55.92	55.92	55.83	55.83	3200.0
2011-11-18 06:00:00	QQQ	ETF	55.77	55.82	55.76	55.76	3351.0
2011-11-18 06:30:00	QQQ	ETF	55.84	56.05	55.84	56.05	26600.0
2011-11-18 07:00:00	QQQ	ETF	56.05	56.14	55.99	56.14	100090.0
2011-11-18 07:30:00	QQQ	ETF	56.2	56.32	56.1	56.1	102886.0
2011-11-18 08:00:00	QQQ	ETF	56.1	56.15	56.02	56.07	163749.0
2011-11-18 08:30:00	QQQ	ETF	56.06	56.14	56.04	56.12	349629.0
2011-11-18 09:00:00	QQQ	ETF	56.12	56.15	55.84	55.84	925447.0
2011-11-18 09:30:00	QQQ	ETF	55.84	55.9	55.54	55.68	7593198.0
2011-11-18 10:00:00	QQQ	ETF	55.68	55.77	55.44	55.55	6654942.0
2011-11-18 10:30:00	QQQ	ETF	55.55	55.9	55.53	55.8	4300895.0
2011-11-18 11:00:00	QQQ	ETF	55.8	55.87	55.72	55.75	2298269.0
2011-11-18 11:30:00	QQQ	ETF	55.75	55.79	55.51	55.55	3955923.0
2011-11-18 12:00:00	QQQ	ETF	55.552	55.56	55.3	55.53	3851505.0
2011-11-18 12:30:00	QQQ	ETF	55.53	55.65	55.51	55.55	3017051.0

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

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