PREVIEW / etf_30min / 2010-05-18

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-18.parquet
  size:    276 KB
  rows:    9,059

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-18 04:00:00	SPY	ETF	114.46	114.47	114.35	114.35	2308.0
2010-05-18 04:30:00	SPY	ETF	114.37	114.42	114.35	114.35	400.0
2010-05-18 05:00:00	SPY	ETF	114.15	114.32	114.12	114.12	1500.0
2010-05-18 05:30:00	SPY	ETF	114.12	114.3	114.1	114.3	5552.0
2010-05-18 06:00:00	SPY	ETF	114.32	114.41	114.3	114.41	5000.0
2010-05-18 06:30:00	SPY	ETF	114.45	114.56	114.45	114.48	34172.0
2010-05-18 07:00:00	SPY	ETF	114.54	114.57	114.46	114.48	457374.0
2010-05-18 07:30:00	SPY	ETF	114.48	114.75	114.44	114.67	633964.0
2010-05-18 08:00:00	SPY	ETF	114.66	114.89	113.549	114.69	4056417.0
2010-05-18 08:30:00	SPY	ETF	114.75	114.94	114.53	114.85	1590926.0
2010-05-18 09:00:00	SPY	ETF	114.84	114.97	114.7	114.88	1506739.0
2010-05-18 09:30:00	SPY	ETF	114.88	115.22	114.72	114.81	30701759.0
2010-05-18 10:00:00	SPY	ETF	114.81	114.99	114.51	114.57	21557476.0
2010-05-18 10:30:00	SPY	ETF	114.57	114.7	113.78	114.1	31325383.0
2010-05-18 11:00:00	SPY	ETF	114.09	114.44	113.9975	114.43	17863269.0
2010-05-18 11:30:00	SPY	ETF	114.43	114.46	113.56	113.7	18188829.0
2010-05-18 12:00:00	SPY	ETF	113.69	114.25	113.32	113.78	16715818.0
2010-05-18 12:30:00	SPY	ETF	113.78	114.19	113.65	113.6601	15552332.0
2010-05-18 13:00:00	SPY	ETF	113.66	113.8	113.03	113.46	28408984.0
2010-05-18 13:30:00	SPY	ETF	113.47	113.62	112.81	112.82	30721966.0
2010-05-18 14:00:00	SPY	ETF	112.83	113.31	112.63	112.82	24959848.0
2010-05-18 14:30:00	SPY	ETF	112.82	112.82	112.18	112.35	31752367.0
2010-05-18 15:00:00	SPY	ETF	112.35	112.92	112.03	112.15	33516952.0
2010-05-18 15:30:00	SPY	ETF	112.14	112.76	112.05	112.41	41633565.0
2010-05-18 16:00:00	SPY	ETF	112.41	115.03	112.17	112.32	7028891.0
2010-05-18 16:30:00	SPY	ETF	112.3	114.0969	112.03	112.05	717855.0
2010-05-18 17:00:00	SPY	ETF	112.05	112.05	111.5	111.67	645541.0
2010-05-18 17:30:00	SPY	ETF	111.74	112.25	111.6	111.7	173690.0
2010-05-18 18:00:00	SPY	ETF	111.67	112.43	111.65	111.68	167466.0
2010-05-18 18:30:00	SPY	ETF	111.69	111.75	111.65	111.65	45695.0
2010-05-18 19:00:00	SPY	ETF	111.67	111.67	111.56	111.66	63855.0
2010-05-18 19:30:00	SPY	ETF	111.63	111.67	111.31	111.34	201982.0
2010-05-18 04:00:00	QQQ	ETF	47.37	47.37	47.37	47.37	100.0
2010-05-18 04:30:00	QQQ	ETF	47.3	47.34	47.3	47.34	2100.0
2010-05-18 05:00:00	QQQ	ETF	47.29	47.29	47.29	47.29	100.0
2010-05-18 05:30:00	QQQ	ETF	47.29	47.29	47.29	47.29	100.0
2010-05-18 07:00:00	QQQ	ETF	47.37	47.4	47.37	47.39	8033.0
2010-05-18 07:30:00	QQQ	ETF	47.37	47.46	47.37	47.41	216636.0
2010-05-18 08:00:00	QQQ	ETF	47.41	47.47	47.35	47.4	2126523.0
2010-05-18 08:30:00	QQQ	ETF	47.41	47.48	47.32	47.47	902739.0
2010-05-18 09:00:00	QQQ	ETF	47.47	47.5	47.42	47.47	591051.0
2010-05-18 09:30:00	QQQ	ETF	47.47	47.58	47.33	47.37	11190842.0
2010-05-18 10:00:00	QQQ	ETF	47.3701	47.5	47.15	47.17	9705297.0
2010-05-18 10:30:00	QQQ	ETF	47.17	47.25	46.6	46.82	19684372.0
2010-05-18 11:00:00	QQQ	ETF	46.82	47.05	46.79	47.04	9928026.0
2010-05-18 11:30:00	QQQ	ETF	47.05	47.06	46.68	46.75	7643542.0
2010-05-18 12:00:00	QQQ	ETF	46.75	46.86	46.59	46.8599	7003427.0
2010-05-18 12:30:00	QQQ	ETF	46.85	46.99	46.8025	46.811	10246827.0
2010-05-18 13:00:00	QQQ	ETF	46.81	46.84	46.55	46.7	9164125.0
2010-05-18 13:30:00	QQQ	ETF	46.7	47.0	46.47	46.49	9065218.0

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

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