PREVIEW / etf_30min / 2010-02-05

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-05.parquet
  size:    272 KB
  rows:    8,958

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-02-05 04:00:00	SPY	ETF	106.6	106.6	106.23	106.23	7700.0
2010-02-05 04:30:00	SPY	ETF	106.25	106.32	105.96	106.0	7200.0
2010-02-05 05:00:00	SPY	ETF	105.96	106.05	105.72	105.75	86516.0
2010-02-05 05:30:00	SPY	ETF	105.82	105.84	105.61	105.61	3350.0
2010-02-05 06:00:00	SPY	ETF	105.6	105.91	105.55	105.82	23300.0
2010-02-05 06:30:00	SPY	ETF	105.85	106.2	105.83	106.19	186200.0
2010-02-05 07:00:00	SPY	ETF	106.16	106.26	106.01	106.19	583961.0
2010-02-05 07:30:00	SPY	ETF	106.22	106.25	105.9	105.97	792701.0
2010-02-05 08:00:00	SPY	ETF	106.23	106.23	105.85	106.09	2941827.0
2010-02-05 08:30:00	SPY	ETF	106.18	106.87	105.61	106.84	14667350.0
2010-02-05 09:00:00	SPY	ETF	106.83	106.83	106.14	106.56	6930544.0
2010-02-05 09:30:00	SPY	ETF	106.56	106.88	105.92	106.01	52631187.0
2010-02-05 10:00:00	SPY	ETF	106.0	106.5	105.69	106.35	33962607.0
2010-02-05 10:30:00	SPY	ETF	106.36	106.78	105.49	106.41	28328772.0
2010-02-05 11:00:00	SPY	ETF	106.42	106.47	106.13	106.1401	22769073.0
2010-02-05 11:30:00	SPY	ETF	106.14	106.23	105.56	105.84	31046091.0
2010-02-05 12:00:00	SPY	ETF	105.85	106.49	105.79	106.05	16661352.0
2010-02-05 12:30:00	SPY	ETF	106.04	106.08	105.65	105.91	15952307.0
2010-02-05 13:00:00	SPY	ETF	105.908	105.9117	105.27	105.33	18060417.0
2010-02-05 13:30:00	SPY	ETF	105.33	105.4	104.58	104.64	37699079.0
2010-02-05 14:00:00	SPY	ETF	104.645	106.4641	104.64	105.24	33973488.0
2010-02-05 14:30:00	SPY	ETF	105.24	105.38	104.94	105.28	31566134.0
2010-02-05 15:00:00	SPY	ETF	105.28	106.6	105.2162	106.26	58501243.0
2010-02-05 15:30:00	SPY	ETF	106.265	106.865	106.11	106.75	49080655.0
2010-02-05 16:00:00	SPY	ETF	106.74	106.823	105.2834	106.49	20205371.0
2010-02-05 16:30:00	SPY	ETF	106.49	106.54	106.4635	106.52	13909570.0
2010-02-05 17:00:00	SPY	ETF	106.53	106.68	106.51	106.65	144841.0
2010-02-05 17:30:00	SPY	ETF	106.66	106.68	106.56	106.64	29074.0
2010-02-05 18:00:00	SPY	ETF	106.64	106.66	106.62	106.64	33892.0
2010-02-05 18:30:00	SPY	ETF	106.68	106.7	106.64	106.65	24139.0
2010-02-05 19:00:00	SPY	ETF	106.69	106.69	106.61	106.62	13000.0
2010-02-05 19:30:00	SPY	ETF	106.6	106.69	106.58	106.64	30853.0
2010-02-05 04:00:00	QQQ	ETF	42.79	42.79	42.79	42.79	1000.0
2010-02-05 05:00:00	QQQ	ETF	42.6	42.6	42.6	42.6	200.0
2010-02-05 05:30:00	QQQ	ETF	42.58	42.58	42.58	42.58	1100.0
2010-02-05 06:30:00	QQQ	ETF	42.57	42.73	42.57	42.73	52409.0
2010-02-05 07:00:00	QQQ	ETF	42.69	42.73	42.64	42.72	128024.0
2010-02-05 07:30:00	QQQ	ETF	42.73	42.75	42.63	42.64	320690.0
2010-02-05 08:00:00	QQQ	ETF	42.65	42.75	42.55	42.68	1639977.0
2010-02-05 08:30:00	QQQ	ETF	42.64	42.94	42.47	42.91	5266008.0
2010-02-05 09:00:00	QQQ	ETF	42.91	42.91	42.69	42.75	1554585.0
2010-02-05 09:30:00	QQQ	ETF	42.76	42.89	42.42	42.49	29008539.0
2010-02-05 10:00:00	QQQ	ETF	42.49	42.86	42.36	42.82	25635922.0
2010-02-05 10:30:00	QQQ	ETF	42.82	42.92	42.6703	42.75	13196314.0
2010-02-05 11:00:00	QQQ	ETF	42.75	42.77	42.61	42.67	8908913.0
2010-02-05 11:30:00	QQQ	ETF	42.67	42.725	42.45	42.5981	10155987.0
2010-02-05 12:00:00	QQQ	ETF	42.6	42.71	42.55	42.68	6300014.0
2010-02-05 12:30:00	QQQ	ETF	42.67	42.68	42.53	42.64	3851073.0
2010-02-05 13:00:00	QQQ	ETF	42.64	42.645	42.36	42.38	6828348.0
2010-02-05 13:30:00	QQQ	ETF	42.38	42.42	42.12	42.16	13514155.0

> showing 50 of 8,958 rows — these rows as CSV

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