PREVIEW / etf_30min / 2010-04-06

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-06.parquet
  size:    251 KB
  rows:    8,380

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-04-06 04:00:00	SPY	ETF	118.54	118.54	118.52	118.52	900.0
2010-04-06 04:30:00	SPY	ETF	118.53	118.53	118.53	118.53	100.0
2010-04-06 05:30:00	SPY	ETF	118.49	118.5	118.48	118.5	4500.0
2010-04-06 06:00:00	SPY	ETF	118.48	118.54	118.45	118.47	2100.0
2010-04-06 06:30:00	SPY	ETF	118.5	118.56	118.5	118.53	3500.0
2010-04-06 07:00:00	SPY	ETF	118.55	118.55	118.49	118.52	35830.0
2010-04-06 07:30:00	SPY	ETF	118.51	118.6	118.49	118.54	161650.0
2010-04-06 08:00:00	SPY	ETF	118.54	118.54	118.24	118.3	803416.0
2010-04-06 08:30:00	SPY	ETF	118.28	118.34	118.22	118.26	814563.0
2010-04-06 09:00:00	SPY	ETF	118.25	118.42	118.2	118.41	1091273.0
2010-04-06 09:30:00	SPY	ETF	118.42	118.59	118.29	118.52	15516618.0
2010-04-06 10:00:00	SPY	ETF	118.52	118.68	118.42	118.66	9211907.0
2010-04-06 10:30:00	SPY	ETF	118.67	118.75	118.62	118.7	7646429.0
2010-04-06 11:00:00	SPY	ETF	118.71	118.9	118.64	118.84	8312466.0
2010-04-06 11:30:00	SPY	ETF	118.83	118.91	118.73	118.78	5293105.0
2010-04-06 12:00:00	SPY	ETF	118.78	118.86	118.75	118.81	3356500.0
2010-04-06 12:30:00	SPY	ETF	118.81	118.82	118.69	118.8	5247426.0
2010-04-06 13:00:00	SPY	ETF	118.8	118.91	118.8	118.8501	3334391.0
2010-04-06 13:30:00	SPY	ETF	118.85	118.88	118.76	118.8	3439036.0
2010-04-06 14:00:00	SPY	ETF	118.8	119.14	118.79	119.1	11285080.0
2010-04-06 14:30:00	SPY	ETF	119.1	119.25	118.95	119.15	8767990.0
2010-04-06 15:00:00	SPY	ETF	119.15	119.19	118.93	118.95	6968479.0
2010-04-06 15:30:00	SPY	ETF	118.945	119.06	118.92	119.01	12803278.0
2010-04-06 16:00:00	SPY	ETF	119.01	119.19	118.5	119.03	3810792.0
2010-04-06 16:30:00	SPY	ETF	119.03	119.05	118.98	118.98	1084013.0
2010-04-06 17:00:00	SPY	ETF	118.97	119.0	118.94	118.95	86820.0
2010-04-06 17:30:00	SPY	ETF	118.95	118.99	118.95	118.95	13600.0
2010-04-06 18:00:00	SPY	ETF	118.96	118.98	118.95	118.96	14454.0
2010-04-06 18:30:00	SPY	ETF	118.99	118.99	118.94	118.96	34050.0
2010-04-06 19:00:00	SPY	ETF	118.95	118.96	118.92	118.92	16986.0
2010-04-06 19:30:00	SPY	ETF	118.92	118.92	118.84	118.9	123734.0
2010-04-06 04:00:00	QQQ	ETF	48.54	48.54	48.54	48.54	200.0
2010-04-06 05:30:00	QQQ	ETF	48.48	48.48	48.48	48.48	4000.0
2010-04-06 07:00:00	QQQ	ETF	48.52	48.52	48.49	48.49	2061.0
2010-04-06 07:30:00	QQQ	ETF	48.5	48.52	48.49	48.49	1700.0
2010-04-06 08:00:00	QQQ	ETF	48.49	48.51	48.42	48.44	152315.0
2010-04-06 08:30:00	QQQ	ETF	48.43	48.46	48.4	48.44	354605.0
2010-04-06 09:00:00	QQQ	ETF	48.44	48.49	48.4	48.49	423380.0
2010-04-06 09:30:00	QQQ	ETF	48.49	48.54	48.39	48.49	6682155.0
2010-04-06 10:00:00	QQQ	ETF	48.48	48.55	48.43	48.549	5730454.0
2010-04-06 10:30:00	QQQ	ETF	48.549	48.58	48.48	48.52	3617484.0
2010-04-06 11:00:00	QQQ	ETF	48.53	48.63	48.48	48.6	2821952.0
2010-04-06 11:30:00	QQQ	ETF	48.6	48.64	48.58	48.61	2509005.0
2010-04-06 12:00:00	QQQ	ETF	48.6101	48.65	48.5	48.63	1392205.0
2010-04-06 12:30:00	QQQ	ETF	48.625	48.64	48.58	48.64	1303761.0
2010-04-06 13:00:00	QQQ	ETF	48.6385	48.69	48.63	48.67	1446486.0
2010-04-06 13:30:00	QQQ	ETF	48.67	48.69	48.62	48.65	2169157.0
2010-04-06 14:00:00	QQQ	ETF	48.66	48.87	48.64	48.85	7420310.0
2010-04-06 14:30:00	QQQ	ETF	48.85	48.9	48.82	48.835	3062298.0
2010-04-06 15:00:00	QQQ	ETF	48.8376	48.85	48.721	48.7299	2667139.0

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

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