PREVIEW / etf_30min / 2009-07-07

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-07.parquet
  size:    219 KB
  rows:    7,128

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-07-07 04:30:00	SPY	ETF	89.82	90.03	89.82	90.03	1100.0
2009-07-07 06:00:00	SPY	ETF	90.15	90.24	90.15	90.17	16300.0
2009-07-07 06:30:00	SPY	ETF	90.12	90.17	90.07	90.15	14100.0
2009-07-07 07:00:00	SPY	ETF	90.17	90.24	90.08	90.2	79900.0
2009-07-07 07:30:00	SPY	ETF	90.18	90.22	89.97	89.97	153989.0
2009-07-07 08:00:00	SPY	ETF	89.98	89.98	89.69	89.77	1157130.0
2009-07-07 08:30:00	SPY	ETF	89.77	89.87	89.73	89.73	371546.0
2009-07-07 09:00:00	SPY	ETF	89.75	89.79	89.6	89.72	1253479.0
2009-07-07 09:30:00	SPY	ETF	89.71	89.82	89.39	89.5601	20741813.0
2009-07-07 10:00:00	SPY	ETF	89.56	89.58	89.14	89.3	13661369.0
2009-07-07 10:30:00	SPY	ETF	89.31	89.335	89.04	89.1299	8523135.0
2009-07-07 11:00:00	SPY	ETF	89.13	89.35	89.01	89.01	5985022.0
2009-07-07 11:30:00	SPY	ETF	89.01	89.09	88.79	88.99	14652682.0
2009-07-07 12:00:00	SPY	ETF	88.9899	88.99	88.75	88.81	5859076.0
2009-07-07 12:30:00	SPY	ETF	88.82	88.9	88.69	88.85	8217610.0
2009-07-07 13:00:00	SPY	ETF	88.85	89.2	88.8	89.1	12186762.0
2009-07-07 13:30:00	SPY	ETF	89.11	89.31	88.94	89.04	7923162.0
2009-07-07 14:00:00	SPY	ETF	89.04	89.06	88.81	88.99	7122011.0
2009-07-07 14:30:00	SPY	ETF	88.99	89.06	88.52	88.61	15774433.0
2009-07-07 15:00:00	SPY	ETF	88.6102	88.6102	88.27	88.54	18531281.0
2009-07-07 15:30:00	SPY	ETF	88.53	89.2	88.0	88.1	38423000.0
2009-07-07 16:00:00	SPY	ETF	88.09	88.4514	88.06	88.4	12484837.0
2009-07-07 16:30:00	SPY	ETF	88.41	89.9042	88.25	88.28	1571934.0
2009-07-07 17:00:00	SPY	ETF	88.27	88.28	88.1563	88.27	1238569.0
2009-07-07 17:30:00	SPY	ETF	88.28	88.29	88.22	88.25	26104.0
2009-07-07 18:00:00	SPY	ETF	88.29	88.33	88.27	88.29	45651.0
2009-07-07 18:30:00	SPY	ETF	88.27	88.32	88.24	88.26	15250.0
2009-07-07 19:00:00	SPY	ETF	88.24	88.34	88.24	88.29	49135.0
2009-07-07 19:30:00	SPY	ETF	88.29	88.34	88.25	88.25	28266.0
2009-07-07 04:00:00	QQQ	ETF	35.35	35.35	35.35	35.35	1307.0
2009-07-07 05:30:00	QQQ	ETF	35.51	35.53	35.51	35.53	15000.0
2009-07-07 06:00:00	QQQ	ETF	35.57	35.6	35.57	35.6	2300.0
2009-07-07 06:30:00	QQQ	ETF	35.58	35.58	35.52	35.55	15550.0
2009-07-07 07:00:00	QQQ	ETF	35.56	35.6	35.55	35.59	62600.0
2009-07-07 07:30:00	QQQ	ETF	35.58	35.6	35.53	35.53	56062.0
2009-07-07 08:00:00	QQQ	ETF	35.52	35.53	35.41	35.44	163924.0
2009-07-07 08:30:00	QQQ	ETF	35.45	35.47	35.43	35.44	62051.0
2009-07-07 09:00:00	QQQ	ETF	35.44	35.44	35.38	35.42	274786.0
2009-07-07 09:30:00	QQQ	ETF	35.42	35.49	35.19	35.23	21497085.0
2009-07-07 10:00:00	QQQ	ETF	35.22	35.22	35.01	35.11	14523161.0
2009-07-07 10:30:00	QQQ	ETF	35.11	35.11	35.0	35.02	5629191.0
2009-07-07 11:00:00	QQQ	ETF	35.01	35.08	34.96	34.97	4023696.0
2009-07-07 11:30:00	QQQ	ETF	34.9615	35.05	34.8	34.91	14192693.0
2009-07-07 12:00:00	QQQ	ETF	34.9	34.92	34.84	34.85	5369227.0
2009-07-07 12:30:00	QQQ	ETF	34.86	34.88	34.78	34.84	7758041.0
2009-07-07 13:00:00	QQQ	ETF	34.84	34.96	34.8201	34.92	6723626.0
2009-07-07 13:30:00	QQQ	ETF	34.92	34.97	34.85	34.881	4457209.0
2009-07-07 14:00:00	QQQ	ETF	34.89	34.92	34.82	34.91	4814742.0
2009-07-07 14:30:00	QQQ	ETF	34.92	34.94	34.74	34.76	6260081.0
2009-07-07 15:00:00	QQQ	ETF	34.77	34.77	34.63	34.71	10094728.0

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

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