PREVIEW / etf_30min / 2008-04-16

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-16.parquet
  size:    169 KB
  rows:    5,921

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
2008-04-16 04:00:00	SPY	ETF	133.92	133.92	133.92	133.92	200.0
2008-04-16 05:00:00	SPY	ETF	133.95	133.95	133.9	133.9	1000.0
2008-04-16 05:30:00	SPY	ETF	133.82	133.82	133.62	133.62	5700.0
2008-04-16 06:00:00	SPY	ETF	133.67	133.67	133.66	133.66	3000.0
2008-04-16 06:30:00	SPY	ETF	133.78	133.95	133.76	133.86	114700.0
2008-04-16 07:00:00	SPY	ETF	133.99	134.19	133.84	134.15	887662.0
2008-04-16 07:30:00	SPY	ETF	134.16	134.16	134.01	134.08	263256.0
2008-04-16 08:00:00	SPY	ETF	134.1	134.38	133.93	134.24	4216951.0
2008-04-16 08:30:00	SPY	ETF	134.25	134.56	134.11	134.56	3980913.0
2008-04-16 09:00:00	SPY	ETF	134.56	134.7	134.51	134.52	1952212.0
2008-04-16 09:30:00	SPY	ETF	134.54	134.95	134.52	134.72	20189461.0
2008-04-16 10:00:00	SPY	ETF	134.72	135.29	134.52	135.18	20060478.0
2008-04-16 10:30:00	SPY	ETF	135.19	135.51	135.1	135.49	19609846.0
2008-04-16 11:00:00	SPY	ETF	135.49	135.57	135.21	135.26	10070130.0
2008-04-16 11:30:00	SPY	ETF	135.26	135.39	135.06	135.19	9597045.0
2008-04-16 12:00:00	SPY	ETF	135.19	135.67	135.17	135.61	7495524.0
2008-04-16 12:30:00	SPY	ETF	135.61	135.69	135.43	135.59	7060557.0
2008-04-16 13:00:00	SPY	ETF	135.6	135.69	134.4	135.55	7668190.0
2008-04-16 13:30:00	SPY	ETF	135.55	135.58	135.31	135.439	6425516.0
2008-04-16 14:00:00	SPY	ETF	135.4396	135.5	135.16	135.4	10276165.0
2008-04-16 14:30:00	SPY	ETF	135.4	135.85	135.4	135.739	8935777.0
2008-04-16 15:00:00	SPY	ETF	135.73	136.14	135.7	136.07	13571327.0
2008-04-16 15:30:00	SPY	ETF	136.08	136.5	135.93	136.22	20170513.0
2008-04-16 16:00:00	SPY	ETF	136.23	137.0	135.13	136.92	9910565.0
2008-04-16 16:30:00	SPY	ETF	136.9	136.98	133.3965	136.85	2570033.0
2008-04-16 17:00:00	SPY	ETF	136.85	136.86	136.72	136.75	456043.0
2008-04-16 17:30:00	SPY	ETF	136.75	136.85	136.65	136.77	136252.0
2008-04-16 18:00:00	SPY	ETF	136.76	136.77	136.68	136.72	43806.0
2008-04-16 18:30:00	SPY	ETF	136.72	136.77	136.7	136.75	8680.0
2008-04-16 19:00:00	SPY	ETF	136.75	136.77	136.62	136.65	25969.0
2008-04-16 19:30:00	SPY	ETF	136.6	136.66	136.57	136.64	44568.0
2008-04-16 05:30:00	QQQ	ETF	44.57	44.57	44.56	44.56	400.0
2008-04-16 06:30:00	QQQ	ETF	44.58	44.59	44.57	44.59	2000.0
2008-04-16 07:00:00	QQQ	ETF	44.66	44.67	44.59	44.6	56976.0
2008-04-16 07:30:00	QQQ	ETF	44.63	44.67	44.61	44.65	54602.0
2008-04-16 08:00:00	QQQ	ETF	44.65	44.75	44.64	44.65	871626.0
2008-04-16 08:30:00	QQQ	ETF	44.7	44.77	44.67	44.75	2525265.0
2008-04-16 09:00:00	QQQ	ETF	44.75	44.79	44.64	44.68	1818923.0
2008-04-16 09:30:00	QQQ	ETF	44.69	44.78	44.65	44.68	12652937.0
2008-04-16 10:00:00	QQQ	ETF	44.69	45.05	44.66	45.01	14310739.0
2008-04-16 10:30:00	QQQ	ETF	45.01	45.11	44.94	45.108	12200817.0
2008-04-16 11:00:00	QQQ	ETF	45.1	45.16	45.03	45.12	8712993.0
2008-04-16 11:30:00	QQQ	ETF	45.11	45.25	45.1099	45.16	7932325.0
2008-04-16 12:00:00	QQQ	ETF	45.17	45.32	45.16	45.29	5471101.0
2008-04-16 12:30:00	QQQ	ETF	45.29	45.33	45.18	45.28	6319371.0
2008-04-16 13:00:00	QQQ	ETF	45.2725	45.315	45.16	45.2305	5701674.0
2008-04-16 13:30:00	QQQ	ETF	45.24	45.25	45.12	45.1695	4184618.0
2008-04-16 14:00:00	QQQ	ETF	45.16	45.23	45.1	45.2001	5768733.0
2008-04-16 14:30:00	QQQ	ETF	45.2	45.36	45.15	45.3105	6245675.0
2008-04-16 15:00:00	QQQ	ETF	45.32	45.45	45.28	45.43	7080156.0

> showing 50 of 5,921 rows — these rows as CSV

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