PREVIEW / etf_30min / 2010-02-12

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-02-12.parquet
  size:    244 KB
  rows:    8,192

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-12 04:00:00	SPY	ETF	108.09	108.09	108.09	108.09	100.0
2010-02-12 04:30:00	SPY	ETF	107.96	107.96	107.8	107.84	7666.0
2010-02-12 05:00:00	SPY	ETF	107.65	107.65	107.24	107.24	28051.0
2010-02-12 05:30:00	SPY	ETF	107.17	107.45	107.12	107.39	60724.0
2010-02-12 06:00:00	SPY	ETF	107.34	107.38	107.18	107.24	91800.0
2010-02-12 06:30:00	SPY	ETF	107.18	107.5	107.14	107.45	132984.0
2010-02-12 07:00:00	SPY	ETF	107.4	107.5	107.37	107.45	277095.0
2010-02-12 07:30:00	SPY	ETF	107.45	107.49	107.27	107.32	643537.0
2010-02-12 08:00:00	SPY	ETF	107.36	107.53	107.23	107.33	1794584.0
2010-02-12 08:30:00	SPY	ETF	107.35	107.66	107.09	107.46	3548788.0
2010-02-12 09:00:00	SPY	ETF	107.47	107.55	106.79	106.99	4905673.0
2010-02-12 09:30:00	SPY	ETF	106.99	107.06	106.51	106.9	41574137.0
2010-02-12 10:00:00	SPY	ETF	106.9	107.19	106.51	107.08	26193116.0
2010-02-12 10:30:00	SPY	ETF	107.08	107.21	106.71	106.92	13011368.0
2010-02-12 11:00:00	SPY	ETF	106.92	107.27	106.74	107.11	14305116.0
2010-02-12 11:30:00	SPY	ETF	107.1	107.2	106.98	107.13	8479914.0
2010-02-12 12:00:00	SPY	ETF	107.12	108.1012	107.12	107.81	26746243.0
2010-02-12 12:30:00	SPY	ETF	107.81	107.88	107.62	107.71	11532386.0
2010-02-12 13:00:00	SPY	ETF	107.7099	107.7157	107.03	107.2	20124612.0
2010-02-12 13:30:00	SPY	ETF	107.2	107.45	107.03	107.35	14792524.0
2010-02-12 14:00:00	SPY	ETF	107.34	108.07	107.27	107.91	19480316.0
2010-02-12 14:30:00	SPY	ETF	107.92	107.98	107.58	107.622	14106067.0
2010-02-12 15:00:00	SPY	ETF	107.62	107.65	107.36	107.45	13687964.0
2010-02-12 15:30:00	SPY	ETF	107.45	108.05	107.28	108.02	37983358.0
2010-02-12 16:00:00	SPY	ETF	108.01	108.39	106.85	108.31	15059124.0
2010-02-12 16:30:00	SPY	ETF	108.31	108.4	107.35	108.35	12991190.0
2010-02-12 17:00:00	SPY	ETF	108.34	108.34	108.1015	108.33	1342162.0
2010-02-12 17:30:00	SPY	ETF	108.33	108.35	108.0616	108.29	343500.0
2010-02-12 18:00:00	SPY	ETF	108.29	108.35	108.04	108.17	242995.0
2010-02-12 18:30:00	SPY	ETF	108.15	108.26	108.15	108.25	19500.0
2010-02-12 19:00:00	SPY	ETF	108.21	108.28	108.2	108.28	6000.0
2010-02-12 19:30:00	SPY	ETF	108.25	108.35	108.23	108.32	17992.0
2010-02-12 04:30:00	QQQ	ETF	43.63	43.63	43.52	43.52	5655.0
2010-02-12 05:00:00	QQQ	ETF	43.5	43.5	43.4	43.4	6987.0
2010-02-12 05:30:00	QQQ	ETF	43.36	43.37	43.36	43.37	5000.0
2010-02-12 06:00:00	QQQ	ETF	43.33	43.34	43.31	43.31	15042.0
2010-02-12 06:30:00	QQQ	ETF	43.34	43.38	43.33	43.37	156350.0
2010-02-12 07:00:00	QQQ	ETF	43.37	43.41	43.34	43.4	309154.0
2010-02-12 07:30:00	QQQ	ETF	43.4	43.42	43.35	43.38	136482.0
2010-02-12 08:00:00	QQQ	ETF	43.39	43.44	43.37	43.39	214894.0
2010-02-12 08:30:00	QQQ	ETF	43.4	43.5	43.27	43.44	289385.0
2010-02-12 09:00:00	QQQ	ETF	43.45	43.45	43.19	43.27	1412591.0
2010-02-12 09:30:00	QQQ	ETF	43.27	43.38	43.16	43.36	12438080.0
2010-02-12 10:00:00	QQQ	ETF	43.36	43.47	43.2	43.44	9513958.0
2010-02-12 10:30:00	QQQ	ETF	43.44	43.48	43.25	43.33	6180896.0
2010-02-12 11:00:00	QQQ	ETF	43.32	43.5	43.28	43.43	2653727.0
2010-02-12 11:30:00	QQQ	ETF	43.43	43.53	43.39	43.51	3595081.0
2010-02-12 12:00:00	QQQ	ETF	43.51	43.85	43.51	43.762	7975843.0
2010-02-12 12:30:00	QQQ	ETF	43.77	43.81	43.71	43.76	4564334.0
2010-02-12 13:00:00	QQQ	ETF	43.76	43.76	43.5	43.57	6129855.0

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

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