PREVIEW / etf_30min / 2009-02-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-09.parquet
  size:    202 KB
  rows:    6,727

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-02-09 04:00:00	SPY	ETF	85.8	86.1	85.8	86.1	43519.0
2009-02-09 05:00:00	SPY	ETF	86.3	86.3	86.3	86.3	800.0
2009-02-09 05:30:00	SPY	ETF	86.15	86.15	86.15	86.15	25000.0
2009-02-09 06:00:00	SPY	ETF	86.3	86.5	86.3	86.5	5500.0
2009-02-09 06:30:00	SPY	ETF	86.52	86.54	86.43	86.49	27400.0
2009-02-09 07:00:00	SPY	ETF	86.5	86.64	86.48	86.52	215728.0
2009-02-09 07:30:00	SPY	ETF	86.53	86.58	86.22	86.27	377647.0
2009-02-09 08:00:00	SPY	ETF	86.29	86.71	86.26	86.52	1741367.0
2009-02-09 08:30:00	SPY	ETF	86.53	86.74	86.335	86.71	1461464.0
2009-02-09 09:00:00	SPY	ETF	86.72	87.03	86.71	86.98	1409907.0
2009-02-09 09:30:00	SPY	ETF	86.96	87.09	86.6	86.92	23819579.0
2009-02-09 10:00:00	SPY	ETF	86.93	86.94	86.32	86.65	20324269.0
2009-02-09 10:30:00	SPY	ETF	86.66	87.74	86.57	87.68	25498394.0
2009-02-09 11:00:00	SPY	ETF	87.68	87.7	87.19	87.27	14532005.0
2009-02-09 11:30:00	SPY	ETF	87.27	87.32	86.91	87.11	12148479.0
2009-02-09 12:00:00	SPY	ETF	87.11	87.37	86.94	87.34	8860381.0
2009-02-09 12:30:00	SPY	ETF	87.34	87.5	87.08	87.42	10433211.0
2009-02-09 13:00:00	SPY	ETF	87.42	87.56	87.24	87.25	9486066.0
2009-02-09 13:30:00	SPY	ETF	87.26	87.26	86.78	87.13	18093263.0
2009-02-09 14:00:00	SPY	ETF	87.1399	87.2	86.53	86.63	14405045.0
2009-02-09 14:30:00	SPY	ETF	86.63	86.85	86.48	86.77	13747702.0
2009-02-09 15:00:00	SPY	ETF	86.76	87.55	86.58	87.35	18155076.0
2009-02-09 15:30:00	SPY	ETF	87.34	87.49	86.98	87.159	25692032.0
2009-02-09 16:00:00	SPY	ETF	87.15	87.19	86.86	86.92	6061185.0
2009-02-09 16:30:00	SPY	ETF	86.9	87.1	86.65	86.7	270450.0
2009-02-09 17:00:00	SPY	ETF	86.68	86.75	86.56	86.69	127045.0
2009-02-09 17:30:00	SPY	ETF	86.75	86.8	86.58	86.6	162268.0
2009-02-09 18:00:00	SPY	ETF	86.6	86.75	86.47	86.54	142636.0
2009-02-09 18:30:00	SPY	ETF	86.55	86.67	86.53	86.59	100669.0
2009-02-09 19:00:00	SPY	ETF	86.59	86.63	86.13	86.17	170148.0
2009-02-09 19:30:00	SPY	ETF	86.18	86.18	85.84	85.99	268076.0
2009-02-09 04:30:00	QQQ	ETF	31.17	31.17	31.17	31.17	323.0
2009-02-09 06:30:00	QQQ	ETF	31.31	31.35	31.31	31.34	107913.0
2009-02-09 07:00:00	QQQ	ETF	31.35	31.37	31.34	31.35	69500.0
2009-02-09 07:30:00	QQQ	ETF	31.35	31.35	31.19	31.26	215594.0
2009-02-09 08:00:00	QQQ	ETF	31.25	31.39	31.22	31.3	933134.0
2009-02-09 08:30:00	QQQ	ETF	31.29	31.35	31.24	31.31	1334024.0
2009-02-09 09:00:00	QQQ	ETF	31.32	31.42	31.32	31.39	809715.0
2009-02-09 09:30:00	QQQ	ETF	31.39	31.47	31.22	31.38	9834657.0
2009-02-09 10:00:00	QQQ	ETF	31.39	31.39	31.19	31.25	7249321.0
2009-02-09 10:30:00	QQQ	ETF	31.26	31.67	31.22	31.64	17908714.0
2009-02-09 11:00:00	QQQ	ETF	31.65	31.65	31.46	31.52	5072305.0
2009-02-09 11:30:00	QQQ	ETF	31.51	31.53	31.4	31.47	3931351.0
2009-02-09 12:00:00	QQQ	ETF	31.47	31.58	31.42	31.56	2762176.0
2009-02-09 12:30:00	QQQ	ETF	31.56	31.61	31.48	31.58	2992927.0
2009-02-09 13:00:00	QQQ	ETF	31.5717	31.62	31.52	31.53	3268673.0
2009-02-09 13:30:00	QQQ	ETF	31.52	31.53	31.37	31.52	4316195.0
2009-02-09 14:00:00	QQQ	ETF	31.51	31.54	31.28	31.3201	5845170.0
2009-02-09 14:30:00	QQQ	ETF	31.3295	31.39	31.26	31.35	6776876.0
2009-02-09 15:00:00	QQQ	ETF	31.35	31.55	31.3	31.54	7684935.0

> showing 50 of 6,727 rows — these rows as CSV

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