PREVIEW / etf_30min / 2009-05-20

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-20.parquet
  size:    224 KB
  rows:    7,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
2009-05-20 04:00:00	SPY	ETF	91.67	91.67	91.64	91.64	5800.0
2009-05-20 04:30:00	SPY	ETF	91.57	91.67	91.57	91.65	6150.0
2009-05-20 05:00:00	SPY	ETF	91.5	91.5	91.39	91.39	1440.0
2009-05-20 05:30:00	SPY	ETF	91.5	91.6	91.33	91.36	6700.0
2009-05-20 06:00:00	SPY	ETF	91.38	91.38	91.2	91.25	6500.0
2009-05-20 06:30:00	SPY	ETF	91.25	91.6	91.25	91.5	19400.0
2009-05-20 07:00:00	SPY	ETF	91.52	91.53	91.3	91.4	155045.0
2009-05-20 07:30:00	SPY	ETF	91.37	91.75	91.37	91.59	626567.0
2009-05-20 08:00:00	SPY	ETF	91.59	91.81	90.6	91.67	1433231.0
2009-05-20 08:30:00	SPY	ETF	91.67	91.82	91.67	91.78	948159.0
2009-05-20 09:00:00	SPY	ETF	91.79	91.96	91.12	91.95	1235804.0
2009-05-20 09:30:00	SPY	ETF	91.95	92.56	91.87	92.41	30482148.0
2009-05-20 10:00:00	SPY	ETF	92.3999	92.8	92.39	92.526	21823067.0
2009-05-20 10:30:00	SPY	ETF	92.52	92.66	92.32	92.35	15806638.0
2009-05-20 11:00:00	SPY	ETF	92.35	92.44	92.02	92.11	17244831.0
2009-05-20 11:30:00	SPY	ETF	92.1099	92.28	91.55	91.58	20067152.0
2009-05-20 12:00:00	SPY	ETF	91.58	91.73	91.48	91.58	17205609.0
2009-05-20 12:30:00	SPY	ETF	91.57	91.62	91.24	91.26	11229458.0
2009-05-20 13:00:00	SPY	ETF	91.26	91.55	91.17	91.5199	13860099.0
2009-05-20 13:30:00	SPY	ETF	91.52	91.83	91.43	91.74	13428333.0
2009-05-20 14:00:00	SPY	ETF	91.75	91.92	91.29	91.72	29401961.0
2009-05-20 14:30:00	SPY	ETF	91.72	91.88	91.39	91.67	16488895.0
2009-05-20 15:00:00	SPY	ETF	91.68	91.69	90.77	90.92	24671229.0
2009-05-20 15:30:00	SPY	ETF	90.9196	91.03	90.41	90.57	32407155.0
2009-05-20 16:00:00	SPY	ETF	90.55	92.05	90.41	90.48	10769415.0
2009-05-20 16:30:00	SPY	ETF	90.45	90.56	90.37	90.54	4963263.0
2009-05-20 17:00:00	SPY	ETF	90.53	90.55	90.39	90.49	345841.0
2009-05-20 17:30:00	SPY	ETF	90.48	90.48	90.37	90.42	214676.0
2009-05-20 18:00:00	SPY	ETF	90.42	90.54	90.41	90.42	281128.0
2009-05-20 18:30:00	SPY	ETF	90.43	90.43	90.33	90.35	52182.0
2009-05-20 19:00:00	SPY	ETF	90.34	90.34	90.25	90.28	72588.0
2009-05-20 19:30:00	SPY	ETF	90.29	90.46	90.28	90.39	45715.0
2009-05-20 05:00:00	QQQ	ETF	34.44	34.44	34.37	34.37	1100.0
2009-05-20 05:30:00	QQQ	ETF	34.41	34.41	34.38	34.38	1100.0
2009-05-20 06:00:00	QQQ	ETF	34.41	34.42	34.35	34.35	500.0
2009-05-20 06:30:00	QQQ	ETF	34.34	34.41	34.34	34.41	500.0
2009-05-20 07:00:00	QQQ	ETF	34.39	34.42	34.35	34.4	172820.0
2009-05-20 07:30:00	QQQ	ETF	34.41	34.49	34.41	34.41	30012.0
2009-05-20 08:00:00	QQQ	ETF	34.0	34.56	34.0	34.46	672591.0
2009-05-20 08:30:00	QQQ	ETF	34.45	34.55	34.45	34.51	1039515.0
2009-05-20 09:00:00	QQQ	ETF	34.51	34.56	34.48	34.54	936467.0
2009-05-20 09:30:00	QQQ	ETF	34.54	34.87	34.46	34.8	13786585.0
2009-05-20 10:00:00	QQQ	ETF	34.81	35.04	34.8	34.94	8710822.0
2009-05-20 10:30:00	QQQ	ETF	34.94	35.01	34.9	34.92	7241162.0
2009-05-20 11:00:00	QQQ	ETF	34.92	34.97	34.82	34.85	6301481.0
2009-05-20 11:30:00	QQQ	ETF	34.85	34.95	34.65	34.67	6932126.0
2009-05-20 12:00:00	QQQ	ETF	34.67	34.74	34.65	34.68	5146477.0
2009-05-20 12:30:00	QQQ	ETF	34.69	34.7	34.4	34.41	5878062.0
2009-05-20 13:00:00	QQQ	ETF	34.42	34.56	34.36	34.55	10233454.0
2009-05-20 13:30:00	QQQ	ETF	34.55	34.66	34.51	34.66	6010259.0

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

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