PREVIEW / etf_30min / 2009-06-04

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-04.parquet
  size:    223 KB
  rows:    7,385

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
2009-06-04 04:00:00	SPY	ETF	94.16	94.19	94.14	94.14	2905.0
2009-06-04 04:30:00	SPY	ETF	94.22	94.22	94.04	94.04	850.0
2009-06-04 05:00:00	SPY	ETF	94.07	94.13	94.04	94.07	11050.0
2009-06-04 05:30:00	SPY	ETF	94.09	94.27	94.09	94.27	40250.0
2009-06-04 06:00:00	SPY	ETF	94.15	94.3	94.15	94.16	9000.0
2009-06-04 06:30:00	SPY	ETF	94.11	94.18	94.02	94.1	21250.0
2009-06-04 07:00:00	SPY	ETF	94.09	94.09	93.86	93.91	104650.0
2009-06-04 07:30:00	SPY	ETF	93.85	93.91	93.56	93.56	743136.0
2009-06-04 08:00:00	SPY	ETF	93.59	93.78	93.46	93.7	1148098.0
2009-06-04 08:30:00	SPY	ETF	93.72	94.11	93.63	93.99	4106857.0
2009-06-04 09:00:00	SPY	ETF	94.01	94.3	93.93	93.98	1051524.0
2009-06-04 09:30:00	SPY	ETF	94.0	94.05	93.49	93.75	22985501.0
2009-06-04 10:00:00	SPY	ETF	93.74	93.9	93.3	93.82	20325852.0
2009-06-04 10:30:00	SPY	ETF	93.81	94.25	93.67	94.15	13963961.0
2009-06-04 11:00:00	SPY	ETF	94.15	94.27	94.01	94.08	15639346.0
2009-06-04 11:30:00	SPY	ETF	94.08	94.12	93.92	93.92	11131279.0
2009-06-04 12:00:00	SPY	ETF	93.92	94.1	93.76	94.1	10260477.0
2009-06-04 12:30:00	SPY	ETF	94.1	94.28	94.04	94.15	9247987.0
2009-06-04 13:00:00	SPY	ETF	94.1401	94.44	94.09	94.35	10882379.0
2009-06-04 13:30:00	SPY	ETF	94.35	94.59	94.3401	94.49	10969721.0
2009-06-04 14:00:00	SPY	ETF	94.4901	94.63	94.41	94.54	10561136.0
2009-06-04 14:30:00	SPY	ETF	94.54	94.62	94.37	94.42	15106057.0
2009-06-04 15:00:00	SPY	ETF	94.42	94.5	94.26	94.4706	13473850.0
2009-06-04 15:30:00	SPY	ETF	94.47	94.67	94.32	94.55	28556398.0
2009-06-04 16:00:00	SPY	ETF	94.57	94.62	94.45	94.57	5572647.0
2009-06-04 16:30:00	SPY	ETF	94.57	94.6529	93.5806	94.64	1601097.0
2009-06-04 17:00:00	SPY	ETF	94.63	94.64	94.54	94.56	59593.0
2009-06-04 17:30:00	SPY	ETF	94.57	94.64	94.57	94.62	135240.0
2009-06-04 18:00:00	SPY	ETF	94.58	94.6	94.55	94.6	147305.0
2009-06-04 18:30:00	SPY	ETF	94.63	94.64	94.61	94.61	8450.0
2009-06-04 19:00:00	SPY	ETF	94.62	94.64	94.6	94.62	8950.0
2009-06-04 19:30:00	SPY	ETF	94.61	94.65	94.59	94.65	64540.0
2009-06-04 04:30:00	QQQ	ETF	36.55	36.55	36.55	36.55	100.0
2009-06-04 05:30:00	QQQ	ETF	36.55	36.58	36.55	36.58	10100.0
2009-06-04 06:00:00	QQQ	ETF	36.54	36.54	36.53	36.53	600.0
2009-06-04 06:30:00	QQQ	ETF	36.47	36.47	36.45	36.45	200.0
2009-06-04 07:00:00	QQQ	ETF	36.44	36.47	36.38	36.41	2600.0
2009-06-04 07:30:00	QQQ	ETF	36.4	36.4	36.33	36.33	102260.0
2009-06-04 08:00:00	QQQ	ETF	36.33	36.45	36.31	36.42	871437.0
2009-06-04 08:30:00	QQQ	ETF	36.43	36.47	36.4	36.44	524433.0
2009-06-04 09:00:00	QQQ	ETF	36.44	36.47	36.39	36.4	619079.0
2009-06-04 09:30:00	QQQ	ETF	36.4	36.67	36.34	36.61	13902946.0
2009-06-04 10:00:00	QQQ	ETF	36.62	36.62	36.38	36.49	8404059.0
2009-06-04 10:30:00	QQQ	ETF	36.49	36.61	36.4385	36.57	6463274.0
2009-06-04 11:00:00	QQQ	ETF	36.56	36.59	36.49	36.52	4285736.0
2009-06-04 11:30:00	QQQ	ETF	36.508	36.56	36.48	36.48	5924475.0
2009-06-04 12:00:00	QQQ	ETF	36.49	36.55	36.41	36.54	3856395.0
2009-06-04 12:30:00	QQQ	ETF	36.548	36.62	36.52	36.57	2904094.0
2009-06-04 13:00:00	QQQ	ETF	36.56	36.69	36.54	36.6601	3612099.0
2009-06-04 13:30:00	QQQ	ETF	36.66	36.74	36.5	36.67	3776249.0

> showing 50 of 7,385 rows — these rows as CSV

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