PREVIEW / etf_30min / 2010-11-10

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-10.parquet
  size:    277 KB
  rows:    9,117

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
2010-11-10 04:00:00	SPY	ETF	121.67	121.71	121.62	121.64	1700.0
2010-11-10 04:30:00	SPY	ETF	121.6	121.72	121.59	121.71	1900.0
2010-11-10 05:00:00	SPY	ETF	121.75	121.76	121.67	121.67	16500.0
2010-11-10 05:30:00	SPY	ETF	121.67	121.67	121.49	121.49	3700.0
2010-11-10 06:00:00	SPY	ETF	121.52	121.56	121.47	121.56	25625.0
2010-11-10 06:30:00	SPY	ETF	121.63	121.63	121.62	121.62	200.0
2010-11-10 07:00:00	SPY	ETF	121.66	121.71	121.54	121.62	110100.0
2010-11-10 07:30:00	SPY	ETF	121.65	121.66	121.39	121.4	208590.0
2010-11-10 08:00:00	SPY	ETF	121.73	121.73	121.29	121.52	830958.0
2010-11-10 08:30:00	SPY	ETF	121.52	121.8	121.42	121.66	1794790.0
2010-11-10 09:00:00	SPY	ETF	121.67	121.78	121.53	121.58	1374590.0
2010-11-10 09:30:00	SPY	ETF	121.58	121.7	120.9	120.995	31028191.0
2010-11-10 10:00:00	SPY	ETF	121.0	121.07	120.66	120.73	23306521.0
2010-11-10 10:30:00	SPY	ETF	120.74	121.19	120.73	121.085	17080897.0
2010-11-10 11:00:00	SPY	ETF	121.085	121.22	120.9	121.2	13772958.0
2010-11-10 11:30:00	SPY	ETF	121.19	121.65	121.19	121.59	17905656.0
2010-11-10 12:00:00	SPY	ETF	121.585	121.69	121.34	121.42	9050960.0
2010-11-10 12:30:00	SPY	ETF	121.42	121.56	121.35	121.475	5676975.0
2010-11-10 13:00:00	SPY	ETF	121.48	121.9	121.2	121.78	18540818.0
2010-11-10 13:30:00	SPY	ETF	121.77	121.93	121.65	121.77	8398887.0
2010-11-10 14:00:00	SPY	ETF	121.77	122.16	121.76	122.04	16934771.0
2010-11-10 14:30:00	SPY	ETF	122.04	122.05	121.85	121.99	14959210.0
2010-11-10 15:00:00	SPY	ETF	121.99	122.05	121.78	121.97	13072723.0
2010-11-10 15:30:00	SPY	ETF	121.97	122.12	121.87	122.0701	17902253.0
2010-11-10 16:00:00	SPY	ETF	122.07	122.11	121.035	121.87	4690444.0
2010-11-10 16:30:00	SPY	ETF	121.85	121.86	121.47	121.49	1065765.0
2010-11-10 17:00:00	SPY	ETF	121.49	121.51	121.08	121.12	1423660.0
2010-11-10 17:30:00	SPY	ETF	121.12	121.24	121.02	121.15	322948.0
2010-11-10 18:00:00	SPY	ETF	121.15	122.09	121.14	121.18	285836.0
2010-11-10 18:30:00	SPY	ETF	121.19	121.42	121.18	121.4	271437.0
2010-11-10 19:00:00	SPY	ETF	121.4	121.4	121.2	121.25	147818.0
2010-11-10 19:30:00	SPY	ETF	121.29	121.33	121.21	121.31	99966.0
2010-11-10 05:30:00	QQQ	ETF	53.55	53.55	53.5	53.5	15000.0
2010-11-10 06:30:00	QQQ	ETF	53.52	53.54	53.52	53.54	7600.0
2010-11-10 07:00:00	QQQ	ETF	53.56	53.56	53.5	53.52	5960.0
2010-11-10 07:30:00	QQQ	ETF	53.49	53.5	53.45	53.45	19100.0
2010-11-10 08:00:00	QQQ	ETF	53.5	53.52	53.42	53.52	404028.0
2010-11-10 08:30:00	QQQ	ETF	53.52	53.65	53.48	53.58	327679.0
2010-11-10 09:00:00	QQQ	ETF	53.57	53.61	53.49	53.525	517423.0
2010-11-10 09:30:00	QQQ	ETF	53.53	53.59	53.15	53.25	11441146.0
2010-11-10 10:00:00	QQQ	ETF	53.25	53.28	53.11	53.12	5885203.0
2010-11-10 10:30:00	QQQ	ETF	53.13	53.28	53.1	53.27	4647606.0
2010-11-10 11:00:00	QQQ	ETF	53.27	53.39	53.24	53.38	4726237.0
2010-11-10 11:30:00	QQQ	ETF	53.375	53.6	53.37	53.5745	4351724.0
2010-11-10 12:00:00	QQQ	ETF	53.58	53.63	53.51	53.5399	2413428.0
2010-11-10 12:30:00	QQQ	ETF	53.54	53.58	53.48	53.53	1513617.0
2010-11-10 13:00:00	QQQ	ETF	53.54	53.7	53.41	53.659	5208642.0
2010-11-10 13:30:00	QQQ	ETF	53.66	53.7001	53.58	53.62	3002177.0
2010-11-10 14:00:00	QQQ	ETF	53.611	53.77	53.611	53.73	4775323.0
2010-11-10 14:30:00	QQQ	ETF	53.74	53.74	53.67	53.725	2618908.0

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

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