PREVIEW / etf_30min / 2009-06-08

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-08.parquet
  size:    222 KB
  rows:    7,373

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
2009-06-08 04:00:00	SPY	ETF	93.58	93.61	93.49	93.61	11200.0
2009-06-08 04:30:00	SPY	ETF	93.68	93.68	93.55	93.55	10400.0
2009-06-08 05:00:00	SPY	ETF	93.6	93.6	93.6	93.6	1000.0
2009-06-08 05:30:00	SPY	ETF	93.68	93.68	93.35	93.37	6700.0
2009-06-08 06:00:00	SPY	ETF	93.45	93.65	93.39	93.6	15700.0
2009-06-08 06:30:00	SPY	ETF	93.6	93.7	93.6	93.6	1900.0
2009-06-08 07:00:00	SPY	ETF	93.65	93.79	93.51	93.7	181363.0
2009-06-08 07:30:00	SPY	ETF	93.75	93.76	93.52	93.66	776619.0
2009-06-08 08:00:00	SPY	ETF	93.66	93.72	93.51	93.54	836414.0
2009-06-08 08:30:00	SPY	ETF	93.54	93.72	93.53	93.64	880757.0
2009-06-08 09:00:00	SPY	ETF	93.64	94.03	93.6	93.85	1109713.0
2009-06-08 09:30:00	SPY	ETF	93.84	93.99	93.3	93.39	20935727.0
2009-06-08 10:00:00	SPY	ETF	93.39	93.6	93.11	93.38	18448021.0
2009-06-08 10:30:00	SPY	ETF	93.3886	93.82	93.37	93.65	12034142.0
2009-06-08 11:00:00	SPY	ETF	93.64	93.76	93.43	93.48	11086367.0
2009-06-08 11:30:00	SPY	ETF	93.48	93.53	93.25	93.39	9107077.0
2009-06-08 12:00:00	SPY	ETF	93.38	93.43	93.04	93.23	13627143.0
2009-06-08 12:30:00	SPY	ETF	93.23	93.39	93.09	93.28	9173496.0
2009-06-08 13:00:00	SPY	ETF	93.27	93.5	93.27	93.39	9512793.0
2009-06-08 13:30:00	SPY	ETF	93.39	93.7	93.32	93.59	7460542.0
2009-06-08 14:00:00	SPY	ETF	93.6	93.62	93.41	93.55	7031287.0
2009-06-08 14:30:00	SPY	ETF	93.55	93.7	93.44	93.61	10305447.0
2009-06-08 15:00:00	SPY	ETF	93.62	94.6	93.61	94.42	30818371.0
2009-06-08 15:30:00	SPY	ETF	94.42	95.1	94.27	94.31	48607655.0
2009-06-08 16:00:00	SPY	ETF	94.31	94.529	94.09	94.34	18049766.0
2009-06-08 16:30:00	SPY	ETF	94.35	94.48	94.34	94.46	6598022.0
2009-06-08 17:00:00	SPY	ETF	94.46	94.5	94.39	94.4	1118496.0
2009-06-08 17:30:00	SPY	ETF	94.41	94.44	94.41	94.41	10501.0
2009-06-08 18:00:00	SPY	ETF	94.41	94.46	94.3	94.42	16571.0
2009-06-08 18:30:00	SPY	ETF	94.43	94.43	94.34	94.37	36250.0
2009-06-08 19:00:00	SPY	ETF	94.39	94.43	94.37	94.43	17200.0
2009-06-08 19:30:00	SPY	ETF	94.43	94.5	94.41	94.45	16695.0
2009-06-08 05:30:00	QQQ	ETF	36.47	36.47	36.39	36.39	2600.0
2009-06-08 06:30:00	QQQ	ETF	36.44	36.5	36.44	36.5	51000.0
2009-06-08 07:00:00	QQQ	ETF	36.47	36.5	36.37	36.47	161195.0
2009-06-08 07:30:00	QQQ	ETF	36.47	36.48	36.4	36.47	120364.0
2009-06-08 08:00:00	QQQ	ETF	36.47	36.5	36.39	36.41	411522.0
2009-06-08 08:30:00	QQQ	ETF	36.41	36.5	36.41	36.47	380920.0
2009-06-08 09:00:00	QQQ	ETF	36.46	36.58	36.46	36.54	905939.0
2009-06-08 09:30:00	QQQ	ETF	36.53	36.58	36.22	36.25	8582382.0
2009-06-08 10:00:00	QQQ	ETF	36.25	36.32	36.15	36.2	6780026.0
2009-06-08 10:30:00	QQQ	ETF	36.2	36.35	36.19	36.27	6165948.0
2009-06-08 11:00:00	QQQ	ETF	36.27	36.34	36.19	36.21	3181201.0
2009-06-08 11:30:00	QQQ	ETF	36.21	36.26	36.17	36.21	4148969.0
2009-06-08 12:00:00	QQQ	ETF	36.21	36.22	36.12	36.17	2619368.0
2009-06-08 12:30:00	QQQ	ETF	36.17	36.27	36.15	36.2	3165798.0
2009-06-08 13:00:00	QQQ	ETF	36.2	36.27	36.17	36.248	3879139.0
2009-06-08 13:30:00	QQQ	ETF	36.25	36.38	36.2	36.3199	4194448.0
2009-06-08 14:00:00	QQQ	ETF	36.31	36.33	36.21	36.29	2699896.0
2009-06-08 14:30:00	QQQ	ETF	36.29	36.36	36.23	36.33	4947257.0

> showing 50 of 7,373 rows — these rows as CSV

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