PREVIEW / etf_30min / 2010-10-01

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-01.parquet
  size:    260 KB
  rows:    8,712

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-10-01 04:00:00	SPY	ETF	114.52	114.71	114.52	114.66	2510.0
2010-10-01 04:30:00	SPY	ETF	114.68	114.68	114.63	114.66	824.0
2010-10-01 05:00:00	SPY	ETF	114.7	114.8	114.7	114.75	1600.0
2010-10-01 05:30:00	SPY	ETF	114.77	114.77	114.73	114.73	600.0
2010-10-01 06:00:00	SPY	ETF	114.83	114.83	114.76	114.8	4300.0
2010-10-01 06:30:00	SPY	ETF	114.81	114.85	114.44	114.44	81963.0
2010-10-01 07:00:00	SPY	ETF	114.43	114.62	114.27	114.53	1109571.0
2010-10-01 07:30:00	SPY	ETF	114.51	114.77	114.51	114.75	102596.0
2010-10-01 08:00:00	SPY	ETF	114.75	114.81	114.13	114.74	2288260.0
2010-10-01 08:30:00	SPY	ETF	114.75	114.9	114.12	114.85	970189.0
2010-10-01 09:00:00	SPY	ETF	114.86	114.97	114.13	114.97	1187791.0
2010-10-01 09:30:00	SPY	ETF	114.99	115.12	114.72	114.868	21580638.0
2010-10-01 10:00:00	SPY	ETF	114.86	115.03	114.12	114.26	35219144.0
2010-10-01 10:30:00	SPY	ETF	114.24	114.39	113.93	114.29	22471837.0
2010-10-01 11:00:00	SPY	ETF	114.29	114.36	114.08	114.18	12783853.0
2010-10-01 11:30:00	SPY	ETF	114.18	114.58	114.06	114.47	9742354.0
2010-10-01 12:00:00	SPY	ETF	114.47	114.54	114.32	114.41	4096754.0
2010-10-01 12:30:00	SPY	ETF	114.41	114.43	114.24	114.4	4240954.0
2010-10-01 13:00:00	SPY	ETF	114.4	114.69	114.38	114.56	5498478.0
2010-10-01 13:30:00	SPY	ETF	114.56	114.56	114.3	114.5	5438823.0
2010-10-01 14:00:00	SPY	ETF	114.49	114.77	114.49	114.65	6235545.0
2010-10-01 14:30:00	SPY	ETF	114.65	114.79	114.59	114.71	6670585.0
2010-10-01 15:00:00	SPY	ETF	114.71	114.85	114.56	114.59	10359056.0
2010-10-01 15:30:00	SPY	ETF	114.59	114.74	114.48	114.6299	15075673.0
2010-10-01 16:00:00	SPY	ETF	114.62	115.08	114.175	114.79	5047974.0
2010-10-01 16:30:00	SPY	ETF	114.79	114.85	114.72	114.82	1217086.0
2010-10-01 17:00:00	SPY	ETF	114.83	114.85	114.82	114.82	109126.0
2010-10-01 17:30:00	SPY	ETF	114.82	114.83	114.72	114.76	181738.0
2010-10-01 18:00:00	SPY	ETF	114.76	114.8	114.61	114.78	19938.0
2010-10-01 18:30:00	SPY	ETF	114.76	114.78	114.74	114.78	1570.0
2010-10-01 19:00:00	SPY	ETF	114.78	114.84	114.72	114.75	35250.0
2010-10-01 19:30:00	SPY	ETF	114.75	114.84	114.74	114.84	25442.0
2010-10-01 04:00:00	QQQ	ETF	49.29	49.3	49.29	49.3	500.0
2010-10-01 04:30:00	QQQ	ETF	49.31	49.31	49.31	49.31	500.0
2010-10-01 05:00:00	QQQ	ETF	49.4	49.4	49.4	49.4	600.0
2010-10-01 06:30:00	QQQ	ETF	49.31	49.31	49.24	49.25	3426.0
2010-10-01 07:00:00	QQQ	ETF	49.23	49.32	49.18	49.32	48337.0
2010-10-01 07:30:00	QQQ	ETF	49.32	49.38	49.31	49.38	47465.0
2010-10-01 08:00:00	QQQ	ETF	49.38	49.42	49.28	49.41	1506829.0
2010-10-01 08:30:00	QQQ	ETF	49.41	49.46	49.35	49.43	287297.0
2010-10-01 09:00:00	QQQ	ETF	49.41	49.47	49.37	49.47	426632.0
2010-10-01 09:30:00	QQQ	ETF	49.47	49.53	49.31	49.425	11397246.0
2010-10-01 10:00:00	QQQ	ETF	49.42	49.4998	48.8701	48.96	15410413.0
2010-10-01 10:30:00	QQQ	ETF	48.95	49.0	48.781	48.94	6767633.0
2010-10-01 11:00:00	QQQ	ETF	48.935	49.0	48.86	48.89	6314125.0
2010-10-01 11:30:00	QQQ	ETF	48.89	49.11	48.84	49.05	3349689.0
2010-10-01 12:00:00	QQQ	ETF	49.05	49.0695	48.94	49.005	1563145.0
2010-10-01 12:30:00	QQQ	ETF	49.01	49.0381	48.92	49.02	1476693.0
2010-10-01 13:00:00	QQQ	ETF	49.03	49.12	49.0	49.07	2974327.0
2010-10-01 13:30:00	QQQ	ETF	49.06	49.07	48.91	48.98	1889125.0

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

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