PREVIEW / etf_30min / 2010-05-25

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-25.parquet
  size:    291 KB
  rows:    9,682

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-25 04:00:00	SPY	ETF	105.07	105.18	105.0	105.11	12907.0
2010-05-25 04:30:00	SPY	ETF	105.21	105.21	104.73	104.73	14650.0
2010-05-25 05:00:00	SPY	ETF	104.84	105.18	104.84	105.18	74072.0
2010-05-25 05:30:00	SPY	ETF	105.05	105.08	104.8	104.8	51200.0
2010-05-25 06:00:00	SPY	ETF	104.68	104.83	104.27	104.78	231324.0
2010-05-25 06:30:00	SPY	ETF	104.82	105.2	104.63	105.17	342871.0
2010-05-25 07:00:00	SPY	ETF	105.2	105.2	104.56	104.94	812848.0
2010-05-25 07:30:00	SPY	ETF	104.9	105.12	104.7	105.03	1137160.0
2010-05-25 08:00:00	SPY	ETF	105.05	106.9875	104.61	105.28	3817451.0
2010-05-25 08:30:00	SPY	ETF	105.28	105.29	104.73	104.88	2691740.0
2010-05-25 09:00:00	SPY	ETF	104.98	105.11	104.73	105.11	4311845.0
2010-05-25 09:30:00	SPY	ETF	105.11	105.43	104.38	105.21	56977499.0
2010-05-25 10:00:00	SPY	ETF	105.21	105.95	104.9279	105.42	38180241.0
2010-05-25 10:30:00	SPY	ETF	105.42	105.75	105.05	105.47	22858364.0
2010-05-25 11:00:00	SPY	ETF	105.47	106.06	105.42	105.82	25266052.0
2010-05-25 11:30:00	SPY	ETF	105.81	106.16	105.49	106.08	16990533.0
2010-05-25 12:00:00	SPY	ETF	106.08	106.37	105.75	105.89	21925679.0
2010-05-25 12:30:00	SPY	ETF	105.9	106.07	105.61	105.91	12143661.0
2010-05-25 13:00:00	SPY	ETF	105.9	106.1286	105.47	105.82	15758415.0
2010-05-25 13:30:00	SPY	ETF	105.82	105.86	105.42	105.62	13700759.0
2010-05-25 14:00:00	SPY	ETF	105.62	106.35	105.44	106.16	17102736.0
2010-05-25 14:30:00	SPY	ETF	106.16	106.88	105.8	106.59	27975831.0
2010-05-25 15:00:00	SPY	ETF	106.59	107.38	106.54	107.29	34727000.0
2010-05-25 15:30:00	SPY	ETF	107.3	107.87	105.9	107.8075	47888103.0
2010-05-25 16:00:00	SPY	ETF	107.82	107.96	104.45	107.78	20050127.0
2010-05-25 16:30:00	SPY	ETF	107.77	108.17	107.71	108.13	2827475.0
2010-05-25 17:00:00	SPY	ETF	108.13	108.95	108.13	108.84	651710.0
2010-05-25 17:30:00	SPY	ETF	108.83	108.86	108.65	108.75	381031.0
2010-05-25 18:00:00	SPY	ETF	108.74	108.83	108.42	108.54	486763.0
2010-05-25 18:30:00	SPY	ETF	108.54	108.6	108.49	108.54	57568.0
2010-05-25 19:00:00	SPY	ETF	108.51	108.61	108.49	108.59	54439.0
2010-05-25 19:30:00	SPY	ETF	108.58	108.79	108.53	108.7	100068.0
2010-05-25 04:00:00	QQQ	ETF	43.74	43.78	43.74	43.78	3304.0
2010-05-25 04:30:00	QQQ	ETF	43.8	43.8	43.8	43.8	338.0
2010-05-25 05:00:00	QQQ	ETF	43.64	43.66	43.61	43.61	29233.0
2010-05-25 05:30:00	QQQ	ETF	43.63	43.63	43.58	43.6	1500.0
2010-05-25 06:00:00	QQQ	ETF	43.59	43.62	43.37	43.62	14211.0
2010-05-25 06:30:00	QQQ	ETF	43.65	43.79	43.58	43.79	11544.0
2010-05-25 07:00:00	QQQ	ETF	43.8	43.8	43.55	43.69	36467.0
2010-05-25 07:30:00	QQQ	ETF	43.59	43.77	43.59	43.77	42648.0
2010-05-25 08:00:00	QQQ	ETF	43.77	43.87	43.71	43.83	493754.0
2010-05-25 08:30:00	QQQ	ETF	43.82	44.66	43.61	43.63	722950.0
2010-05-25 09:00:00	QQQ	ETF	43.64	44.66	43.58	43.68	1302814.0
2010-05-25 09:30:00	QQQ	ETF	43.68	43.69	43.23	43.54	24823204.0
2010-05-25 10:00:00	QQQ	ETF	43.53	43.92	43.49	43.73	18167892.0
2010-05-25 10:30:00	QQQ	ETF	43.73	43.8	43.52	43.7301	10683619.0
2010-05-25 11:00:00	QQQ	ETF	43.73	43.96	43.7	43.86	8623921.0
2010-05-25 11:30:00	QQQ	ETF	43.86	44.04	43.72	44.02	5789825.0
2010-05-25 12:00:00	QQQ	ETF	44.03	44.18	43.95	43.96	5678507.0
2010-05-25 12:30:00	QQQ	ETF	43.96	44.01	43.82	43.98	4209585.0

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

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