PREVIEW / etf_30min / 2007-04-05

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-05.parquet
  size:    101 KB
  rows:    3,632

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
2007-04-05 04:30:00	SPY	ETF	143.76	143.76	143.76	143.76	100.0
2007-04-05 06:30:00	SPY	ETF	143.76	143.76	143.76	143.76	5000.0
2007-04-05 07:00:00	SPY	ETF	143.8	143.8	143.8	143.8	500.0
2007-04-05 07:30:00	SPY	ETF	143.8	143.82	143.76	143.82	14200.0
2007-04-05 08:00:00	SPY	ETF	143.82	143.85	143.78	143.83	137200.0
2007-04-05 08:30:00	SPY	ETF	143.86	143.86	143.76	143.76	255400.0
2007-04-05 09:00:00	SPY	ETF	143.77	143.8	143.65	143.67	161900.0
2007-04-05 09:30:00	SPY	ETF	143.67	143.84	143.61	143.75	5233700.0
2007-04-05 10:00:00	SPY	ETF	143.74	143.9	143.69	143.85	3613925.0
2007-04-05 10:30:00	SPY	ETF	143.86	143.93	143.8	143.9	3529000.0
2007-04-05 11:00:00	SPY	ETF	143.9	143.93	143.84	143.9	2010750.0
2007-04-05 11:30:00	SPY	ETF	143.89	144.11	143.85	144.1	3853100.0
2007-04-05 12:00:00	SPY	ETF	144.1	144.25	144.1	144.14	3535150.0
2007-04-05 12:30:00	SPY	ETF	144.15	144.17	144.08	144.11	1264650.0
2007-04-05 13:00:00	SPY	ETF	144.12	144.31	144.11	144.21	2911425.0
2007-04-05 13:30:00	SPY	ETF	144.2	144.36	143.92	144.29	2335900.0
2007-04-05 14:00:00	SPY	ETF	144.28	144.43	144.25	144.42	1784800.0
2007-04-05 14:30:00	SPY	ETF	144.41	144.44	144.3	144.32	2962600.0
2007-04-05 15:00:00	SPY	ETF	144.32	144.41	144.25	144.28	4143290.0
2007-04-05 15:30:00	SPY	ETF	144.29	144.33	144.21	144.28	6067250.0
2007-04-05 16:00:00	SPY	ETF	144.3	144.37	144.22	144.26	1861700.0
2007-04-05 16:30:00	SPY	ETF	144.25	144.3	144.24	144.27	165100.0
2007-04-05 17:00:00	SPY	ETF	144.28	144.31	144.28	144.31	114000.0
2007-04-05 17:30:00	SPY	ETF	144.27	144.3	144.27	144.27	2100.0
2007-04-05 18:00:00	SPY	ETF	144.3	144.3	144.25	144.25	20500.0
2007-04-05 19:00:00	SPY	ETF	144.29	144.29	144.29	144.29	900.0
2007-04-05 19:30:00	SPY	ETF	144.3	144.31	144.3	144.31	27500.0
2007-04-05 05:30:00	QQQ	ETF	44.29	44.29	44.28	44.28	8040.0
2007-04-05 06:00:00	QQQ	ETF	44.29	44.29	44.29	44.29	1960.0
2007-04-05 07:00:00	QQQ	ETF	44.31	44.32	44.29	44.31	47475.0
2007-04-05 07:30:00	QQQ	ETF	44.32	44.34	44.32	44.33	29175.0
2007-04-05 08:00:00	QQQ	ETF	44.34	44.35	44.32	44.32	57574.0
2007-04-05 08:30:00	QQQ	ETF	44.34	44.35	44.32	44.32	101275.0
2007-04-05 09:00:00	QQQ	ETF	44.32	44.32	44.28	44.28	544765.0
2007-04-05 09:30:00	QQQ	ETF	44.29	44.36	44.23	44.32	6273700.0
2007-04-05 10:00:00	QQQ	ETF	44.33	44.37	44.3	44.33	3896600.0
2007-04-05 10:30:00	QQQ	ETF	44.33	44.36	44.3	44.33	2202400.0
2007-04-05 11:00:00	QQQ	ETF	44.33	44.36	44.32	44.32	1861900.0
2007-04-05 11:30:00	QQQ	ETF	44.32	44.39	44.3	44.39	3839000.0
2007-04-05 12:00:00	QQQ	ETF	44.4	44.45	44.4	44.4	3032000.0
2007-04-05 12:30:00	QQQ	ETF	44.41	44.43	44.38	44.39	1070000.0
2007-04-05 13:00:00	QQQ	ETF	44.39	44.45	44.39	44.41	2641100.0
2007-04-05 13:30:00	QQQ	ETF	44.4	44.46	44.4	44.44	2820500.0
2007-04-05 14:00:00	QQQ	ETF	44.44	44.48	44.42	44.48	1980000.0
2007-04-05 14:30:00	QQQ	ETF	44.47	44.51	44.47	44.48	3342300.0
2007-04-05 15:00:00	QQQ	ETF	44.48	44.51	44.3	44.49	3226400.0
2007-04-05 15:30:00	QQQ	ETF	44.49	44.57	44.47	44.57	7991500.0
2007-04-05 16:00:00	QQQ	ETF	44.58	44.62	44.52	44.58	8442376.0
2007-04-05 16:30:00	QQQ	ETF	44.57	44.59	44.56	44.57	247098.0
2007-04-05 17:00:00	QQQ	ETF	44.58	44.58	44.57	44.57	8885.0

> showing 50 of 3,632 rows — these rows as CSV

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