PREVIEW / etf_30min / 2010-11-09

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-09.parquet
  size:    287 KB
  rows:    9,377

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-11-09 04:00:00	SPY	ETF	122.25	122.29	122.2	122.23	630.0
2010-11-09 04:30:00	SPY	ETF	122.32	122.45	122.32	122.45	1300.0
2010-11-09 05:00:00	SPY	ETF	122.45	122.6	122.45	122.6	21750.0
2010-11-09 05:30:00	SPY	ETF	122.55	122.75	122.55	122.68	2110.0
2010-11-09 06:00:00	SPY	ETF	122.62	122.67	122.6	122.62	11100.0
2010-11-09 06:30:00	SPY	ETF	122.68	122.79	122.68	122.79	9750.0
2010-11-09 07:00:00	SPY	ETF	122.79	122.88	122.75	122.75	130818.0
2010-11-09 07:30:00	SPY	ETF	122.75	122.86	122.73	122.76	201991.0
2010-11-09 08:00:00	SPY	ETF	122.76	122.81	122.39	122.72	572374.0
2010-11-09 08:30:00	SPY	ETF	122.72	122.75	122.63	122.72	358835.0
2010-11-09 09:00:00	SPY	ETF	122.75	122.82	122.1	122.82	1404471.0
2010-11-09 09:30:00	SPY	ETF	122.82	122.82	122.38	122.65	17102051.0
2010-11-09 10:00:00	SPY	ETF	122.65	122.95	122.61	122.81	13344534.0
2010-11-09 10:30:00	SPY	ETF	122.811	122.86	122.5	122.62	12276935.0
2010-11-09 11:00:00	SPY	ETF	122.62	122.65	122.42	122.53	9417229.0
2010-11-09 11:30:00	SPY	ETF	122.53	122.58	122.17	122.18	7250856.0
2010-11-09 12:00:00	SPY	ETF	122.18	122.32	122.17	122.26	6963193.0
2010-11-09 12:30:00	SPY	ETF	122.26	122.33	122.11	122.17	5660310.0
2010-11-09 13:00:00	SPY	ETF	122.18	122.42	122.04	122.07	7568956.0
2010-11-09 13:30:00	SPY	ETF	122.0736	122.15	121.71	121.865	16409736.0
2010-11-09 14:00:00	SPY	ETF	121.8699	122.11	121.84	121.95	10611382.0
2010-11-09 14:30:00	SPY	ETF	121.96	122.17	121.95	122.02	8586273.0
2010-11-09 15:00:00	SPY	ETF	122.02	122.03	121.63	121.69	19824993.0
2010-11-09 15:30:00	SPY	ETF	121.699	122.025	121.12	121.6	36564379.0
2010-11-09 16:00:00	SPY	ETF	121.59	122.795	121.27	121.54	8489797.0
2010-11-09 16:30:00	SPY	ETF	121.54	122.53	121.44	121.52	1615007.0
2010-11-09 17:00:00	SPY	ETF	121.51	121.52	121.44	121.47	177178.0
2010-11-09 17:30:00	SPY	ETF	121.52	121.53	121.46	121.52	48694.0
2010-11-09 18:00:00	SPY	ETF	121.52	121.6	121.36	121.4	494184.0
2010-11-09 18:30:00	SPY	ETF	121.39	121.6	121.38	121.59	39605.0
2010-11-09 19:00:00	SPY	ETF	121.59	121.68	121.52	121.52	55579.0
2010-11-09 19:30:00	SPY	ETF	121.6	121.68	121.6	121.68	48586.0
2010-11-09 04:00:00	QQQ	ETF	53.71	53.71	53.71	53.71	200.0
2010-11-09 05:00:00	QQQ	ETF	53.83	53.83	53.83	53.83	300.0
2010-11-09 05:30:00	QQQ	ETF	53.9	53.9	53.88	53.88	645.0
2010-11-09 06:00:00	QQQ	ETF	53.86	53.88	53.86	53.88	4100.0
2010-11-09 06:30:00	QQQ	ETF	53.88	53.92	53.88	53.92	14288.0
2010-11-09 07:00:00	QQQ	ETF	53.92	53.98	53.91	53.91	86810.0
2010-11-09 07:30:00	QQQ	ETF	53.91	53.95	53.91	53.94	40100.0
2010-11-09 08:00:00	QQQ	ETF	53.9	53.93	53.89	53.9	586846.0
2010-11-09 08:30:00	QQQ	ETF	53.9	53.91	53.85	53.9	846466.0
2010-11-09 09:00:00	QQQ	ETF	53.9	53.97	53.89	53.96	276002.0
2010-11-09 09:30:00	QQQ	ETF	53.96	53.967	53.7	53.7904	5821386.0
2010-11-09 10:00:00	QQQ	ETF	53.79	54.0401	53.77	53.98	5609977.0
2010-11-09 10:30:00	QQQ	ETF	53.98	54.0	53.87	53.91	2409204.0
2010-11-09 11:00:00	QQQ	ETF	53.9	53.915	53.73	53.76	4783070.0
2010-11-09 11:30:00	QQQ	ETF	53.76	53.82	53.62	53.63	3701103.0
2010-11-09 12:00:00	QQQ	ETF	53.62	53.71	53.62	53.7	1707964.0
2010-11-09 12:30:00	QQQ	ETF	53.7	53.72	53.64	53.67	2126722.0
2010-11-09 13:00:00	QQQ	ETF	53.67	53.78	53.6281	53.63	2249050.0

> showing 50 of 9,377 rows — these rows as CSV

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