PREVIEW / etf_30min / 2007-05-09

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-09.parquet
  size:    107 KB
  rows:    3,876

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-05-09 05:00:00	SPY	ETF	150.83	150.83	150.83	150.83	500.0
2007-05-09 06:00:00	SPY	ETF	150.79	150.79	150.77	150.79	17500.0
2007-05-09 06:30:00	SPY	ETF	150.7	150.7	150.66	150.66	5200.0
2007-05-09 07:00:00	SPY	ETF	150.68	150.69	150.65	150.65	23700.0
2007-05-09 07:30:00	SPY	ETF	150.7	150.72	150.64	150.64	26500.0
2007-05-09 08:00:00	SPY	ETF	150.61	150.65	150.51	150.6	783800.0
2007-05-09 08:30:00	SPY	ETF	150.58	150.64	150.55	150.64	966600.0
2007-05-09 09:00:00	SPY	ETF	150.65	150.66	150.46	150.63	2399200.0
2007-05-09 09:30:00	SPY	ETF	150.64	150.77	150.51	150.63	6376808.0
2007-05-09 10:00:00	SPY	ETF	150.64	150.93	150.63	150.81	3463200.0
2007-05-09 10:30:00	SPY	ETF	150.81	150.82	150.64	150.7115	3251050.0
2007-05-09 11:00:00	SPY	ETF	150.72	150.94	150.72	150.83	3407905.0
2007-05-09 11:30:00	SPY	ETF	150.82	150.87	150.72	150.72	3167271.0
2007-05-09 12:00:00	SPY	ETF	150.72	150.96	150.72	150.93	2933200.0
2007-05-09 12:30:00	SPY	ETF	150.94	151.16	150.88	151.07	3816156.0
2007-05-09 13:00:00	SPY	ETF	151.08	151.12	151.01	151.04	3251745.0
2007-05-09 13:30:00	SPY	ETF	151.04	151.09	150.95	150.95	3273260.0
2007-05-09 14:00:00	SPY	ETF	150.96	151.34	150.37	150.89	23424080.0
2007-05-09 14:30:00	SPY	ETF	150.89	152.82	150.7	151.3	18755354.0
2007-05-09 15:00:00	SPY	ETF	151.3	151.49	151.15	151.48	8682767.0
2007-05-09 15:30:00	SPY	ETF	151.49	151.52	151.33	151.38	8810979.0
2007-05-09 16:00:00	SPY	ETF	151.38	151.38	151.14	151.18	2110600.0
2007-05-09 16:30:00	SPY	ETF	151.2	151.21	151.08	151.11	1794600.0
2007-05-09 17:00:00	SPY	ETF	151.13	151.16	151.11	151.14	42800.0
2007-05-09 17:30:00	SPY	ETF	151.14	151.2	151.14	151.14	868600.0
2007-05-09 18:00:00	SPY	ETF	151.13	151.15	151.13	151.15	3000.0
2007-05-09 18:30:00	SPY	ETF	151.1	151.1	151.1	151.1	200.0
2007-05-09 19:00:00	SPY	ETF	151.1	151.12	151.09	151.12	700.0
2007-05-09 19:30:00	SPY	ETF	151.12	151.12	151.1	151.12	2000.0
2007-05-09 07:00:00	QQQ	ETF	46.53	46.56	46.53	46.56	30560.0
2007-05-09 07:30:00	QQQ	ETF	46.55	46.58	46.52	46.54	73395.0
2007-05-09 08:00:00	QQQ	ETF	46.54	46.54	46.49	46.52	202627.0
2007-05-09 08:30:00	QQQ	ETF	46.5	46.65	46.5	46.53	207361.0
2007-05-09 09:00:00	QQQ	ETF	46.54	46.54	46.43	46.48	6292686.0
2007-05-09 09:30:00	QQQ	ETF	46.49	46.56	46.46	46.49	7900202.0
2007-05-09 10:00:00	QQQ	ETF	46.49	46.64	46.49	46.55	6482283.0
2007-05-09 10:30:00	QQQ	ETF	46.56	46.58	46.5	46.54	2360388.0
2007-05-09 11:00:00	QQQ	ETF	46.54	46.63	46.54	46.56	4078967.0
2007-05-09 11:30:00	QQQ	ETF	46.56	46.6	46.52	46.52	2163008.0
2007-05-09 12:00:00	QQQ	ETF	46.52	46.63	46.52	46.63	1607650.0
2007-05-09 12:30:00	QQQ	ETF	46.62	46.74	46.61	46.69	5837451.0
2007-05-09 13:00:00	QQQ	ETF	46.69	46.7	46.64	46.647	1613438.0
2007-05-09 13:30:00	QQQ	ETF	46.647	46.68	46.6	46.6	1934741.0
2007-05-09 14:00:00	QQQ	ETF	46.6	46.81	46.49	46.68	24736543.0
2007-05-09 14:30:00	QQQ	ETF	46.67	46.92	46.61	46.85	19165872.0
2007-05-09 15:00:00	QQQ	ETF	46.86	46.9	46.8	46.9	8569382.0
2007-05-09 15:30:00	QQQ	ETF	46.9	46.97	46.83	46.84	16400590.0
2007-05-09 16:00:00	QQQ	ETF	46.84	46.86	46.78	46.8	2338938.0
2007-05-09 16:30:00	QQQ	ETF	46.8	46.81	46.74	46.76	1859973.0
2007-05-09 17:00:00	QQQ	ETF	46.76	46.77	46.75	46.77	642563.0

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

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