PREVIEW / etf_30min / 2010-05-03

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-03.parquet
  size:    257 KB
  rows:    8,450

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-05-03 04:00:00	SPY	ETF	119.2	119.2	119.2	119.2	150.0
2010-05-03 04:30:00	SPY	ETF	119.26	119.31	119.25	119.26	500.0
2010-05-03 05:00:00	SPY	ETF	119.18	119.18	119.11	119.15	500.0
2010-05-03 05:30:00	SPY	ETF	119.13	119.13	119.02	119.02	3300.0
2010-05-03 06:00:00	SPY	ETF	119.11	119.19	119.1	119.19	25700.0
2010-05-03 06:30:00	SPY	ETF	119.21	119.28	119.21	119.28	59800.0
2010-05-03 07:00:00	SPY	ETF	119.3	119.46	119.3	119.37	941152.0
2010-05-03 07:30:00	SPY	ETF	119.35	119.36	119.3	119.34	143863.0
2010-05-03 08:00:00	SPY	ETF	119.18	119.42	118.86	119.31	450716.0
2010-05-03 08:30:00	SPY	ETF	119.31	119.49	118.8125	119.34	470566.0
2010-05-03 09:00:00	SPY	ETF	119.34	119.43	118.8125	119.39	974049.0
2010-05-03 09:30:00	SPY	ETF	119.38	119.72	119.35	119.6583	19042584.0
2010-05-03 10:00:00	SPY	ETF	119.65	119.82	119.43	119.69	15392655.0
2010-05-03 10:30:00	SPY	ETF	119.68	119.69	119.2	119.34	14287589.0
2010-05-03 11:00:00	SPY	ETF	119.34	119.64	119.28	119.62	7247539.0
2010-05-03 11:30:00	SPY	ETF	119.62	119.86	119.56	119.7784	8388969.0
2010-05-03 12:00:00	SPY	ETF	119.779	120.28	119.6	120.25	10976821.0
2010-05-03 12:30:00	SPY	ETF	120.2583	120.55	120.24	120.55	16155611.0
2010-05-03 13:00:00	SPY	ETF	120.545	120.55	120.3	120.3484	9153888.0
2010-05-03 13:30:00	SPY	ETF	120.35	120.66	120.34	120.52	11321576.0
2010-05-03 14:00:00	SPY	ETF	120.53	120.68	120.38	120.67	8374417.0
2010-05-03 14:30:00	SPY	ETF	120.67	120.67	120.44	120.6099	8544537.0
2010-05-03 15:00:00	SPY	ETF	120.61	120.67	120.18	120.29	17558194.0
2010-05-03 15:30:00	SPY	ETF	120.28	120.47	120.25	120.39	21599359.0
2010-05-03 16:00:00	SPY	ETF	120.39	120.44	119.29	120.34	6985653.0
2010-05-03 16:30:00	SPY	ETF	120.33	120.4001	120.16	120.24	3836811.0
2010-05-03 17:00:00	SPY	ETF	120.24	120.36	120.22	120.29	71795.0
2010-05-03 17:30:00	SPY	ETF	120.25	120.27	120.18	120.24	89049.0
2010-05-03 18:00:00	SPY	ETF	120.23	120.28	120.23	120.28	40373.0
2010-05-03 18:30:00	SPY	ETF	120.29	120.31	120.28	120.31	6100.0
2010-05-03 19:00:00	SPY	ETF	120.32	120.34	120.3	120.3	2730.0
2010-05-03 19:30:00	SPY	ETF	120.28	120.29	120.25	120.25	35018.0
2010-05-03 04:00:00	QQQ	ETF	49.33	49.33	49.33	49.33	414.0
2010-05-03 05:30:00	QQQ	ETF	49.28	49.28	49.28	49.28	2000.0
2010-05-03 06:30:00	QQQ	ETF	49.41	49.41	49.41	49.41	1000.0
2010-05-03 07:00:00	QQQ	ETF	49.44	49.48	49.43	49.44	110220.0
2010-05-03 07:30:00	QQQ	ETF	49.43	49.43	49.4	49.4	82241.0
2010-05-03 08:00:00	QQQ	ETF	49.4	49.45	49.38	49.41	310731.0
2010-05-03 08:30:00	QQQ	ETF	49.41	49.45	49.4	49.42	300005.0
2010-05-03 09:00:00	QQQ	ETF	49.42	49.45	49.2375	49.43	291494.0
2010-05-03 09:30:00	QQQ	ETF	49.42	49.6	49.42	49.55	7090361.0
2010-05-03 10:00:00	QQQ	ETF	49.56	49.76	49.47	49.69	6321234.0
2010-05-03 10:30:00	QQQ	ETF	49.68	49.72	49.5501	49.63	4927838.0
2010-05-03 11:00:00	QQQ	ETF	49.629	49.715	49.57	49.715	3104070.0
2010-05-03 11:30:00	QQQ	ETF	49.71	49.9	49.6985	49.86	4665359.0
2010-05-03 12:00:00	QQQ	ETF	49.87	50.08	49.83	50.06	5062596.0
2010-05-03 12:30:00	QQQ	ETF	50.06	50.17	50.05	50.165	5588413.0
2010-05-03 13:00:00	QQQ	ETF	50.1699	50.17	50.05	50.08	3879153.0
2010-05-03 13:30:00	QQQ	ETF	50.07	50.17	50.07	50.12	3276853.0
2010-05-03 14:00:00	QQQ	ETF	50.13	50.13	50.02	50.11	5629558.0

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

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