PREVIEW / etf_30min / 2007-03-28

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-28.parquet
  size:    105 KB
  rows:    3,641

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-03-28 05:30:00	SPY	ETF	142.49	142.49	142.49	142.49	100.0
2007-03-28 06:00:00	SPY	ETF	142.51	142.54	142.51	142.54	25000.0
2007-03-28 06:30:00	SPY	ETF	142.49	142.49	142.4	142.4	18500.0
2007-03-28 07:00:00	SPY	ETF	142.43	142.45	142.26	142.28	194800.0
2007-03-28 07:30:00	SPY	ETF	142.28	142.34	142.14	142.27	655200.0
2007-03-28 08:00:00	SPY	ETF	142.28	142.37	142.2	142.33	593200.0
2007-03-28 08:30:00	SPY	ETF	142.31	142.46	141.95	142.17	2150800.0
2007-03-28 09:00:00	SPY	ETF	142.17	142.28	142.14	142.24	802007.0
2007-03-28 09:30:00	SPY	ETF	142.23	142.33	142.02	142.1	15307711.0
2007-03-28 10:00:00	SPY	ETF	142.1	142.28	142.05	142.12	9831772.0
2007-03-28 10:30:00	SPY	ETF	142.12	142.13	141.26	141.8	26953702.0
2007-03-28 11:00:00	SPY	ETF	141.8	142.37	141.48	141.61	11575256.0
2007-03-28 11:30:00	SPY	ETF	141.61	141.75	141.55	141.71	4447100.0
2007-03-28 12:00:00	SPY	ETF	141.7	142.47	141.69	142.23	16582481.0
2007-03-28 12:30:00	SPY	ETF	142.23	142.36	142.11	142.19	5016300.0
2007-03-28 13:00:00	SPY	ETF	142.1915	142.35	141.95	142.05	3979000.0
2007-03-28 13:30:00	SPY	ETF	142.06	142.35	141.96	142.06	5796600.0
2007-03-28 14:00:00	SPY	ETF	142.06	142.19	141.58	141.7	13622100.0
2007-03-28 14:30:00	SPY	ETF	141.7	142.01	141.5	141.68	7970100.0
2007-03-28 15:00:00	SPY	ETF	141.68	142.04	141.62	141.94	9415250.0
2007-03-28 15:30:00	SPY	ETF	141.94	141.97	141.53	141.54	12060458.0
2007-03-28 16:00:00	SPY	ETF	141.55	142.5	141.51	141.76	3803300.0
2007-03-28 16:30:00	SPY	ETF	141.76	141.81	141.59	141.8	767200.0
2007-03-28 17:00:00	SPY	ETF	141.81	141.81	141.76	141.76	21600.0
2007-03-28 17:30:00	SPY	ETF	141.76	141.85	141.74	141.76	27000.0
2007-03-28 18:00:00	SPY	ETF	141.79	141.81	141.76	141.8	43300.0
2007-03-28 18:30:00	SPY	ETF	141.84	141.86	141.81	141.86	6500.0
2007-03-28 19:00:00	SPY	ETF	141.82	141.82	141.82	141.82	7900.0
2007-03-28 19:30:00	SPY	ETF	141.81	141.84	141.81	141.84	4200.0
2007-03-28 07:00:00	QQQ	ETF	43.86	43.89	43.84	43.84	46614.0
2007-03-28 07:30:00	QQQ	ETF	43.85	43.85	43.76	43.84	554098.0
2007-03-28 08:00:00	QQQ	ETF	43.82	43.84	43.76	43.82	1516575.0
2007-03-28 08:30:00	QQQ	ETF	43.82	43.83	43.7	43.79	2673451.0
2007-03-28 09:00:00	QQQ	ETF	43.78	43.81	43.75	43.79	931589.0
2007-03-28 09:30:00	QQQ	ETF	43.78	43.91	43.74	43.82	12188000.0
2007-03-28 10:00:00	QQQ	ETF	43.82	43.9	43.8	43.86	7715500.0
2007-03-28 10:30:00	QQQ	ETF	43.86	44.63	43.55	43.75	24181700.0
2007-03-28 11:00:00	QQQ	ETF	43.76	43.81	43.62	43.67	9360700.0
2007-03-28 11:30:00	QQQ	ETF	43.67	43.71	43.65	43.68	3831300.0
2007-03-28 12:00:00	QQQ	ETF	43.69	44.03	43.68	43.91	16598300.0
2007-03-28 12:30:00	QQQ	ETF	43.92	44.01	43.89	43.92	7043100.0
2007-03-28 13:00:00	QQQ	ETF	43.92	43.92	43.8	43.87	3361000.0
2007-03-28 13:30:00	QQQ	ETF	43.87	43.95	43.81	43.82	4279400.0
2007-03-28 14:00:00	QQQ	ETF	43.83	43.87	43.62	43.67	12090100.0
2007-03-28 14:30:00	QQQ	ETF	43.66	43.71	43.58	43.67	8904800.0
2007-03-28 15:00:00	QQQ	ETF	43.67	43.78	43.63	43.77	8366300.0
2007-03-28 15:30:00	QQQ	ETF	43.76	43.78	43.51	43.52	12347100.0
2007-03-28 16:00:00	QQQ	ETF	43.51	43.57	43.5	43.53	2628003.0
2007-03-28 16:30:00	QQQ	ETF	43.54	43.57	43.52	43.55	2379576.0
2007-03-28 17:00:00	QQQ	ETF	43.54	43.57	43.54	43.56	163520.0

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

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