PREVIEW / etf_30min / 2011-01-19

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-19.parquet
  size:    282 KB
  rows:    9,312

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-19 04:00:00	SPY	ETF	129.65	129.69	129.59	129.59	3000.0
2011-01-19 04:30:00	SPY	ETF	129.74	129.74	129.68	129.68	1844.0
2011-01-19 05:00:00	SPY	ETF	129.66	129.66	129.57	129.57	500.0
2011-01-19 05:30:00	SPY	ETF	129.75	129.75	129.75	129.75	500.0
2011-01-19 06:00:00	SPY	ETF	129.69	129.72	129.62	129.62	2500.0
2011-01-19 06:30:00	SPY	ETF	129.62	129.7	129.59	129.7	19700.0
2011-01-19 07:00:00	SPY	ETF	129.7	129.8	129.69	129.73	22045.0
2011-01-19 07:30:00	SPY	ETF	129.78	129.92	129.76	129.9	208824.0
2011-01-19 08:00:00	SPY	ETF	129.89	129.89	129.44	129.54	1922322.0
2011-01-19 08:30:00	SPY	ETF	129.52	129.62	129.35	129.42	726527.0
2011-01-19 09:00:00	SPY	ETF	129.42	129.44	129.3	129.41	824114.0
2011-01-19 09:30:00	SPY	ETF	129.41	129.5	128.99	129.08	17902005.0
2011-01-19 10:00:00	SPY	ETF	129.08	129.21	128.76	128.81	11638246.0
2011-01-19 10:30:00	SPY	ETF	128.82	128.85	128.56	128.74	11493214.0
2011-01-19 11:00:00	SPY	ETF	128.75	128.77	128.54	128.64	6573776.0
2011-01-19 11:30:00	SPY	ETF	128.64	128.78	128.62	128.695	5680586.0
2011-01-19 12:00:00	SPY	ETF	128.69	128.75	128.56	128.621	4285761.0
2011-01-19 12:30:00	SPY	ETF	128.63	128.63	128.29	128.41	10179061.0
2011-01-19 13:00:00	SPY	ETF	128.42	128.62	128.29	128.61	6849697.0
2011-01-19 13:30:00	SPY	ETF	128.61	128.7	128.45	128.555	5999757.0
2011-01-19 14:00:00	SPY	ETF	128.56	128.57	128.24	128.34	7212946.0
2011-01-19 14:30:00	SPY	ETF	128.34	128.4	127.96	128.14	11635350.0
2011-01-19 15:00:00	SPY	ETF	128.14	128.26	127.91	128.14	11484272.0
2011-01-19 15:30:00	SPY	ETF	128.135	128.26	127.91	128.26	22968410.0
2011-01-19 16:00:00	SPY	ETF	128.26	128.38	128.2258	128.33	6260088.0
2011-01-19 16:30:00	SPY	ETF	128.33	129.5357	128.2	128.22	4001052.0
2011-01-19 17:00:00	SPY	ETF	128.21	128.23	128.18	128.2	516827.0
2011-01-19 17:30:00	SPY	ETF	128.19	128.26	128.19	128.2	217037.0
2011-01-19 18:00:00	SPY	ETF	128.21	128.27	128.19	128.19	124811.0
2011-01-19 18:30:00	SPY	ETF	128.2	128.22	128.16	128.19	82021.0
2011-01-19 19:00:00	SPY	ETF	128.2	128.2	128.12	128.14	23575.0
2011-01-19 19:30:00	SPY	ETF	128.11	128.4	128.11	128.4	115067.0
2011-01-19 04:00:00	QQQ	ETF	57.26	57.26	57.26	57.26	600.0
2011-01-19 04:30:00	QQQ	ETF	57.27	57.27	57.27	57.27	100.0
2011-01-19 05:00:00	QQQ	ETF	57.24	57.24	57.21	57.22	400.0
2011-01-19 06:00:00	QQQ	ETF	57.22	57.22	57.22	57.22	500.0
2011-01-19 06:30:00	QQQ	ETF	57.21	57.21	57.2	57.2	14500.0
2011-01-19 07:00:00	QQQ	ETF	57.21	57.26	57.21	57.25	104648.0
2011-01-19 07:30:00	QQQ	ETF	57.26	57.35	57.26	57.33	71220.0
2011-01-19 08:00:00	QQQ	ETF	57.32	57.34	57.15	57.21	287870.0
2011-01-19 08:30:00	QQQ	ETF	57.21	57.31	57.15	57.23	718996.0
2011-01-19 09:00:00	QQQ	ETF	57.24	57.32	57.2	57.23	749988.0
2011-01-19 09:30:00	QQQ	ETF	57.23	57.26	56.97	57.0	10910762.0
2011-01-19 10:00:00	QQQ	ETF	56.99	57.11	56.82	56.8699	5252089.0
2011-01-19 10:30:00	QQQ	ETF	56.87	56.88	56.76	56.86	4254320.0
2011-01-19 11:00:00	QQQ	ETF	56.865	56.88	56.72	56.79	3777925.0
2011-01-19 11:30:00	QQQ	ETF	56.79	56.9	56.77	56.79	3579402.0
2011-01-19 12:00:00	QQQ	ETF	56.791	56.825	56.74	56.77	1199580.0
2011-01-19 12:30:00	QQQ	ETF	56.77	56.77	56.61	56.69	3246451.0
2011-01-19 13:00:00	QQQ	ETF	56.69	56.77	56.61	56.745	1603888.0

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

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