PREVIEW / etf_30min / 2007-05-31

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-31.parquet
  size:    114 KB
  rows:    4,409

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-31 06:00:00	SPY	ETF	153.49	153.51	153.49	153.51	25500.0
2007-05-31 06:30:00	SPY	ETF	153.51	153.6	153.51	153.6	9000.0
2007-05-31 07:00:00	SPY	ETF	153.58	153.75	153.57	153.7	181200.0
2007-05-31 07:30:00	SPY	ETF	153.7	153.76	153.68	153.72	60100.0
2007-05-31 08:00:00	SPY	ETF	153.56	153.81	153.56	153.8	1591400.0
2007-05-31 08:30:00	SPY	ETF	153.78	153.88	153.69	153.75	2044300.0
2007-05-31 09:00:00	SPY	ETF	153.73	153.7888	153.65	153.65	1217100.0
2007-05-31 09:30:00	SPY	ETF	153.66	153.87	153.58	153.73	11068286.0
2007-05-31 10:00:00	SPY	ETF	153.73	153.89	153.38	153.53	13670247.0
2007-05-31 10:30:00	SPY	ETF	153.52	153.77	153.48	153.69	8373342.0
2007-05-31 11:00:00	SPY	ETF	153.68	153.69	153.28	153.32	9191550.0
2007-05-31 11:30:00	SPY	ETF	153.32	153.535	153.32	153.46	3422824.0
2007-05-31 12:00:00	SPY	ETF	153.46	153.7	153.3421	153.68	4625100.0
2007-05-31 12:30:00	SPY	ETF	153.68	153.71	153.55	153.62	4509000.0
2007-05-31 13:00:00	SPY	ETF	153.61	153.67	153.12	153.25	9974413.0
2007-05-31 13:30:00	SPY	ETF	153.24	153.46	153.16	153.38	4483800.0
2007-05-31 14:00:00	SPY	ETF	153.38	153.66	153.37	153.56	3683276.0
2007-05-31 14:30:00	SPY	ETF	153.55	153.7	153.47	153.48	3780973.0
2007-05-31 15:00:00	SPY	ETF	153.49	153.54	153.37	153.41	4538907.0
2007-05-31 15:30:00	SPY	ETF	153.41	153.54	153.31	153.35	11237699.0
2007-05-31 16:00:00	SPY	ETF	153.36	153.6	153.3	153.36	8383500.0
2007-05-31 16:30:00	SPY	ETF	153.36	153.5	153.32	153.32	158400.0
2007-05-31 17:00:00	SPY	ETF	153.44	153.5	153.3419	153.3419	3673500.0
2007-05-31 17:30:00	SPY	ETF	153.45	153.48	153.45	153.46	3100.0
2007-05-31 18:00:00	SPY	ETF	153.46	153.46	153.39	153.46	868100.0
2007-05-31 18:30:00	SPY	ETF	153.41	153.41	153.38	153.38	40000.0
2007-05-31 19:30:00	SPY	ETF	153.44	153.47	153.44	153.47	2400.0
2007-05-31 07:00:00	QQQ	ETF	47.26	47.29	47.26	47.29	10400.0
2007-05-31 07:30:00	QQQ	ETF	47.33	47.35	47.31	47.34	37169.0
2007-05-31 08:00:00	QQQ	ETF	47.32	47.37	47.32	47.35	363812.0
2007-05-31 08:30:00	QQQ	ETF	47.34	47.39	47.29	47.33	1116781.0
2007-05-31 09:00:00	QQQ	ETF	47.33	47.34	47.3	47.31	612181.0
2007-05-31 09:30:00	QQQ	ETF	47.32	47.47	47.29	47.4	20386065.0
2007-05-31 10:00:00	QQQ	ETF	47.403	47.49	47.29	47.35	11843132.0
2007-05-31 10:30:00	QQQ	ETF	47.3588	47.5	47.33	47.47	7491266.0
2007-05-31 11:00:00	QQQ	ETF	47.47	47.48	47.29	47.31	9042983.0
2007-05-31 11:30:00	QQQ	ETF	47.31	47.43	47.31	47.4	3583483.0
2007-05-31 12:00:00	QQQ	ETF	47.41	47.51	47.37	47.5	2760040.0
2007-05-31 12:30:00	QQQ	ETF	47.5	47.52	47.45	47.49	2554784.0
2007-05-31 13:00:00	QQQ	ETF	47.49	47.5	47.24	47.29	8999873.0
2007-05-31 13:30:00	QQQ	ETF	47.28	47.36	47.21	47.34	7471894.0
2007-05-31 14:00:00	QQQ	ETF	47.33	47.43	47.32	47.41	5784882.0
2007-05-31 14:30:00	QQQ	ETF	47.4	47.48	47.38	47.42	4903976.0
2007-05-31 15:00:00	QQQ	ETF	47.42	47.45	47.33	47.34	6619051.0
2007-05-31 15:30:00	QQQ	ETF	47.34	47.49	47.3	47.44	9491155.0
2007-05-31 16:00:00	QQQ	ETF	47.44	47.53	47.41	47.5	3840074.0
2007-05-31 16:30:00	QQQ	ETF	47.49	47.51	47.41	47.49	196381.0
2007-05-31 17:00:00	QQQ	ETF	47.48	47.51	47.44	47.45	560980.0
2007-05-31 17:30:00	QQQ	ETF	47.45	47.48	47.45	47.47	76384.0
2007-05-31 18:00:00	QQQ	ETF	47.47	47.47	47.46	47.46	1235690.0

> showing 50 of 4,409 rows — these rows as CSV

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