PREVIEW / etf_30min / 2009-09-10

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-10.parquet
  size:    233 KB
  rows:    7,626

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-09-10 04:00:00	SPY	ETF	104.01	104.03	103.98	104.03	1700.0
2009-09-10 05:00:00	SPY	ETF	103.97	103.97	103.97	103.97	100.0
2009-09-10 05:30:00	SPY	ETF	103.69	103.69	103.58	103.58	500.0
2009-09-10 06:30:00	SPY	ETF	103.63	103.63	103.39	103.44	5030.0
2009-09-10 07:00:00	SPY	ETF	103.42	103.63	103.42	103.63	67174.0
2009-09-10 07:30:00	SPY	ETF	103.61	103.76	103.5	103.69	90224.0
2009-09-10 08:00:00	SPY	ETF	103.69	103.75	103.53	103.61	1021050.0
2009-09-10 08:30:00	SPY	ETF	103.62	104.01	103.33	103.82	2417393.0
2009-09-10 09:00:00	SPY	ETF	103.83	103.88	103.72	103.8	1248362.0
2009-09-10 09:30:00	SPY	ETF	103.8	103.86	103.22	103.54	21758605.0
2009-09-10 10:00:00	SPY	ETF	103.54	103.8333	103.51	103.59	14249664.0
2009-09-10 10:30:00	SPY	ETF	103.59	104.13	103.57	104.09	10378640.0
2009-09-10 11:00:00	SPY	ETF	104.1	104.27	103.92	103.98	10052883.0
2009-09-10 11:30:00	SPY	ETF	103.98	104.15	103.92	104.03	7689965.0
2009-09-10 12:00:00	SPY	ETF	104.02	104.07	103.94	104.02	4294823.0
2009-09-10 12:30:00	SPY	ETF	104.02	104.19	104.02	104.17	3737830.0
2009-09-10 13:00:00	SPY	ETF	104.16	104.36	104.08	104.205	12666647.0
2009-09-10 13:30:00	SPY	ETF	104.2017	104.73	104.18	104.71	12506056.0
2009-09-10 14:00:00	SPY	ETF	104.71	104.82	104.59	104.631	9406909.0
2009-09-10 14:30:00	SPY	ETF	104.64	104.75	104.6	104.66	5642155.0
2009-09-10 15:00:00	SPY	ETF	104.66	104.66	104.3	104.53	12425652.0
2009-09-10 15:30:00	SPY	ETF	104.53	104.86	104.0563	104.79	19222988.0
2009-09-10 16:00:00	SPY	ETF	104.8	104.8374	103.57	104.65	8717742.0
2009-09-10 16:30:00	SPY	ETF	104.63	104.7	103.7778	104.61	3003397.0
2009-09-10 17:00:00	SPY	ETF	104.61	104.66	104.6	104.66	30034.0
2009-09-10 17:30:00	SPY	ETF	104.65	104.66	104.64	104.65	11899.0
2009-09-10 18:00:00	SPY	ETF	104.66	104.82	104.54	104.55	87805.0
2009-09-10 18:30:00	SPY	ETF	104.56	104.57	104.52	104.54	15150.0
2009-09-10 19:00:00	SPY	ETF	104.56	104.59	104.55	104.55	16278.0
2009-09-10 19:30:00	SPY	ETF	104.55	104.59	104.55	104.55	48998.0
2009-09-10 04:30:00	QQQ	ETF	41.13	41.13	41.13	41.13	200.0
2009-09-10 06:00:00	QQQ	ETF	40.99	40.99	40.99	40.99	300.0
2009-09-10 07:00:00	QQQ	ETF	40.93	41.04	40.92	41.04	67100.0
2009-09-10 07:30:00	QQQ	ETF	41.01	41.08	40.99	41.05	68498.0
2009-09-10 08:00:00	QQQ	ETF	41.05	41.07	40.99	41.0	173829.0
2009-09-10 08:30:00	QQQ	ETF	41.02	41.21	41.02	41.12	425368.0
2009-09-10 09:00:00	QQQ	ETF	41.11	41.13	41.07	41.1	288081.0
2009-09-10 09:30:00	QQQ	ETF	41.11	41.27	41.04	41.1574	14291010.0
2009-09-10 10:00:00	QQQ	ETF	41.152	41.3	41.0	41.09	13515803.0
2009-09-10 10:30:00	QQQ	ETF	41.1	41.29	41.07	41.258	5767272.0
2009-09-10 11:00:00	QQQ	ETF	41.26	41.34	41.16	41.2	5147344.0
2009-09-10 11:30:00	QQQ	ETF	41.2	41.3	41.19	41.25	4250171.0
2009-09-10 12:00:00	QQQ	ETF	41.25	41.26	41.2	41.23	1474631.0
2009-09-10 12:30:00	QQQ	ETF	41.222	41.3	41.2206	41.27	2094111.0
2009-09-10 13:00:00	QQQ	ETF	41.28	41.33	41.24	41.28	5832841.0
2009-09-10 13:30:00	QQQ	ETF	41.28	41.4779	41.17	41.468	7385072.0
2009-09-10 14:00:00	QQQ	ETF	41.47	41.52	41.34	41.48	6023902.0
2009-09-10 14:30:00	QQQ	ETF	41.48	41.51	41.42	41.44	3245196.0
2009-09-10 15:00:00	QQQ	ETF	41.44	41.5	41.3	41.4001	6006246.0
2009-09-10 15:30:00	QQQ	ETF	41.41	41.53	41.39	41.47	9640852.0

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

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