PREVIEW / etf_30min / 2009-05-13

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-13.parquet
  size:    228 KB
  rows:    7,612

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-13 04:00:00	SPY	ETF	91.15	91.18	91.15	91.18	574.0
2009-05-13 04:30:00	SPY	ETF	91.18	91.36	91.18	91.31	10526.0
2009-05-13 05:00:00	SPY	ETF	91.32	91.35	91.32	91.35	300.0
2009-05-13 05:30:00	SPY	ETF	91.16	91.16	90.97	90.97	3700.0
2009-05-13 06:00:00	SPY	ETF	91.05	91.07	90.95	91.02	15612.0
2009-05-13 06:30:00	SPY	ETF	90.97	91.02	90.65	90.71	59483.0
2009-05-13 07:00:00	SPY	ETF	90.75	90.86	90.27	90.39	204383.0
2009-05-13 07:30:00	SPY	ETF	90.41	90.49	90.19	90.24	885346.0
2009-05-13 08:00:00	SPY	ETF	90.25	91.25	90.1	90.24	1669125.0
2009-05-13 08:30:00	SPY	ETF	90.22	90.22	89.38	89.64	6050330.0
2009-05-13 09:00:00	SPY	ETF	89.63	89.75	89.5	89.75	2716528.0
2009-05-13 09:30:00	SPY	ETF	89.74	89.74	89.15	89.571	33525411.0
2009-05-13 10:00:00	SPY	ETF	89.58	89.92	89.25	89.91	22381158.0
2009-05-13 10:30:00	SPY	ETF	89.89	90.01	89.28	89.2899	20923416.0
2009-05-13 11:00:00	SPY	ETF	89.2899	89.49	89.19	89.39	15581742.0
2009-05-13 11:30:00	SPY	ETF	89.39	89.4	89.02	89.16	16051458.0
2009-05-13 12:00:00	SPY	ETF	89.16	89.53	89.12	89.39	10013228.0
2009-05-13 12:30:00	SPY	ETF	89.39	89.4	88.8	88.82	10992646.0
2009-05-13 13:00:00	SPY	ETF	88.81	88.9	88.6	88.61	15171343.0
2009-05-13 13:30:00	SPY	ETF	88.62	89.09	88.5	89.08	17129924.0
2009-05-13 14:00:00	SPY	ETF	89.08	89.14	88.59	88.8	16612394.0
2009-05-13 14:30:00	SPY	ETF	88.8	89.11	88.68	89.09	10661429.0
2009-05-13 15:00:00	SPY	ETF	89.08	89.36	88.61	88.73	21625500.0
2009-05-13 15:30:00	SPY	ETF	88.7399	89.03	88.55	88.7	35734678.0
2009-05-13 16:00:00	SPY	ETF	88.73	89.2997	86.6322	88.9233	7630287.0
2009-05-13 16:30:00	SPY	ETF	88.99	89.05	88.93	88.95	1135384.0
2009-05-13 17:00:00	SPY	ETF	88.98	88.98	88.9	88.92	108449.0
2009-05-13 17:30:00	SPY	ETF	88.91	88.93	88.86	88.86	81797.0
2009-05-13 18:00:00	SPY	ETF	88.88	88.88	88.72	88.77	79151.0
2009-05-13 18:30:00	SPY	ETF	88.81	88.81	88.62	88.68	53259.0
2009-05-13 19:00:00	SPY	ETF	88.74	88.75	88.69	88.7	26050.0
2009-05-13 19:30:00	SPY	ETF	88.74	88.9	88.68	88.88	71578.0
2009-05-13 04:00:00	QQQ	ETF	34.0	34.0	34.0	34.0	100.0
2009-05-13 04:30:00	QQQ	ETF	34.08	34.08	34.08	34.08	100.0
2009-05-13 06:00:00	QQQ	ETF	33.97	33.97	33.97	33.97	100.0
2009-05-13 06:30:00	QQQ	ETF	33.92	33.92	33.81	33.83	35021.0
2009-05-13 07:00:00	QQQ	ETF	33.86	33.87	33.7	33.75	127387.0
2009-05-13 07:30:00	QQQ	ETF	33.76	33.76	33.63	33.69	193084.0
2009-05-13 08:00:00	QQQ	ETF	33.71	33.93	33.69	33.76	669904.0
2009-05-13 08:30:00	QQQ	ETF	33.76	33.76	33.55	33.6	1783727.0
2009-05-13 09:00:00	QQQ	ETF	33.62	33.64	33.56	33.63	1253467.0
2009-05-13 09:30:00	QQQ	ETF	33.63	33.65	33.39	33.48	19463004.0
2009-05-13 10:00:00	QQQ	ETF	33.48	33.48	33.27	33.45	13956542.0
2009-05-13 10:30:00	QQQ	ETF	33.45	33.45	33.14	33.1599	12809625.0
2009-05-13 11:00:00	QQQ	ETF	33.155	33.28	33.12	33.269	9586502.0
2009-05-13 11:30:00	QQQ	ETF	33.26	33.27	33.11	33.16	6756065.0
2009-05-13 12:00:00	QQQ	ETF	33.16	33.28	33.14	33.27	7262307.0
2009-05-13 12:30:00	QQQ	ETF	33.2701	33.28	33.07	33.08	4441178.0
2009-05-13 13:00:00	QQQ	ETF	33.08	33.1295	33.03	33.04	8942484.0
2009-05-13 13:30:00	QQQ	ETF	33.0401	33.23	33.01	33.23	14049053.0

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

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