PREVIEW / etf_30min / 2009-04-22

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-22.parquet
  size:    214 KB
  rows:    7,166

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-04-22 04:00:00	SPY	ETF	84.6	84.6	84.34	84.47	8150.0
2009-04-22 04:30:00	SPY	ETF	84.6	84.6	84.43	84.43	900.0
2009-04-22 05:00:00	SPY	ETF	84.57	84.7	84.57	84.7	2100.0
2009-04-22 05:30:00	SPY	ETF	84.67	84.84	84.67	84.84	1500.0
2009-04-22 06:00:00	SPY	ETF	84.71	84.84	84.56	84.84	8050.0
2009-04-22 06:30:00	SPY	ETF	84.8	84.88	84.64	84.74	17299.0
2009-04-22 07:00:00	SPY	ETF	84.7	84.7	84.43	84.64	436148.0
2009-04-22 07:30:00	SPY	ETF	84.64	84.98	84.48	84.86	550767.0
2009-04-22 08:00:00	SPY	ETF	84.85	84.91	84.1	84.29	4141747.0
2009-04-22 08:30:00	SPY	ETF	84.3	85.08	84.06	84.23	2639226.0
2009-04-22 09:00:00	SPY	ETF	84.23	84.3	84.03	84.3	1689801.0
2009-04-22 09:30:00	SPY	ETF	84.29	84.69	84.07	84.63	28535444.0
2009-04-22 10:00:00	SPY	ETF	84.62	85.89	84.3	85.82	40502828.0
2009-04-22 10:30:00	SPY	ETF	85.82	85.92	85.54	85.58	25353705.0
2009-04-22 11:00:00	SPY	ETF	85.58	85.87	85.49	85.87	17039841.0
2009-04-22 11:30:00	SPY	ETF	85.87	86.13	85.86	86.0999	16022936.0
2009-04-22 12:00:00	SPY	ETF	86.1	86.12	85.55	85.55	17934311.0
2009-04-22 12:30:00	SPY	ETF	85.57	85.58	85.03	85.2895	21510367.0
2009-04-22 13:00:00	SPY	ETF	85.29	85.6	85.08	85.54	14921801.0
2009-04-22 13:30:00	SPY	ETF	85.54	85.85	85.35	85.36	11725338.0
2009-04-22 14:00:00	SPY	ETF	85.36	86.0	85.32	85.94	18037643.0
2009-04-22 14:30:00	SPY	ETF	85.94	86.3	84.65	85.95	24772985.0
2009-04-22 15:00:00	SPY	ETF	85.95	86.34	85.67	85.79	25284050.0
2009-04-22 15:30:00	SPY	ETF	85.79	85.89	84.34	84.54	47158719.0
2009-04-22 16:00:00	SPY	ETF	84.52	85.1653	84.02	84.12	10391426.0
2009-04-22 16:30:00	SPY	ETF	84.12	85.1163	84.04	84.25	6467543.0
2009-04-22 17:00:00	SPY	ETF	84.27	84.4	84.19	84.37	2791814.0
2009-04-22 17:30:00	SPY	ETF	84.37	84.43	84.3	84.35	90125.0
2009-04-22 18:00:00	SPY	ETF	84.35	84.35	84.19	84.28	101078.0
2009-04-22 18:30:00	SPY	ETF	84.31	84.43	84.31	84.4	34142.0
2009-04-22 19:00:00	SPY	ETF	84.38	84.4	84.33	84.33	11202.0
2009-04-22 19:30:00	SPY	ETF	84.33	84.35	84.23	84.28	23718.0
2009-04-22 05:30:00	QQQ	ETF	32.53	32.53	32.53	32.53	100.0
2009-04-22 06:00:00	QQQ	ETF	32.52	32.55	32.45	32.55	1800.0
2009-04-22 06:30:00	QQQ	ETF	32.53	32.55	32.51	32.51	8100.0
2009-04-22 07:00:00	QQQ	ETF	32.5	32.54	32.46	32.54	12226.0
2009-04-22 07:30:00	QQQ	ETF	32.54	32.68	32.53	32.64	485542.0
2009-04-22 08:00:00	QQQ	ETF	32.63	32.64	32.4	32.46	1304138.0
2009-04-22 08:30:00	QQQ	ETF	32.46	32.49	32.38	32.48	1651000.0
2009-04-22 09:00:00	QQQ	ETF	32.48	32.5	32.39	32.5	1047079.0
2009-04-22 09:30:00	QQQ	ETF	32.5	32.929	32.39	32.92	12181835.0
2009-04-22 10:00:00	QQQ	ETF	32.92	33.32	32.911	33.27	18789638.0
2009-04-22 10:30:00	QQQ	ETF	33.27	33.32	33.15	33.17	11923426.0
2009-04-22 11:00:00	QQQ	ETF	33.16	33.32	33.1	33.31	6480896.0
2009-04-22 11:30:00	QQQ	ETF	33.31	33.46	33.31	33.42	7090780.0
2009-04-22 12:00:00	QQQ	ETF	33.42	33.42	33.24	33.25	8140324.0
2009-04-22 12:30:00	QQQ	ETF	33.24	33.27	33.01	33.1299	12489753.0
2009-04-22 13:00:00	QQQ	ETF	33.1221	33.21	33.05	33.2	6905310.0
2009-04-22 13:30:00	QQQ	ETF	33.2	33.29	33.07	33.08	5492853.0
2009-04-22 14:00:00	QQQ	ETF	33.08	33.34	33.06	33.32	6353615.0

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

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