PREVIEW / etf_30min / 2008-04-21

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-21.parquet
  size:    159 KB
  rows:    5,606

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-21 06:00:00	SPY	ETF	138.59	138.59	138.59	138.59	100.0
2008-04-21 06:30:00	SPY	ETF	138.5	138.5	138.48	138.48	5000.0
2008-04-21 07:00:00	SPY	ETF	138.44	138.48	138.04	138.08	543303.0
2008-04-21 07:30:00	SPY	ETF	138.16	138.4	138.1	138.33	284094.0
2008-04-21 08:00:00	SPY	ETF	138.33	138.95	138.31	138.43	362898.0
2008-04-21 08:30:00	SPY	ETF	138.41	138.45	138.25	138.35	886007.0
2008-04-21 09:00:00	SPY	ETF	138.35	138.36	138.07	138.21	1694414.0
2008-04-21 09:30:00	SPY	ETF	138.23	138.65	138.2	138.46	12303523.0
2008-04-21 10:00:00	SPY	ETF	138.47	138.47	137.89	137.95	13212189.0
2008-04-21 10:30:00	SPY	ETF	137.94	138.2	137.87	137.91	8306076.0
2008-04-21 11:00:00	SPY	ETF	137.91	138.27	136.87	138.13	9008805.0
2008-04-21 11:30:00	SPY	ETF	138.13	138.45	138.0	138.36	7500919.0
2008-04-21 12:00:00	SPY	ETF	138.35	138.43	138.27	138.39	4630015.0
2008-04-21 12:30:00	SPY	ETF	138.39	138.43	138.23	138.36	4314138.0
2008-04-21 13:00:00	SPY	ETF	138.36	138.6	138.3	138.49	5223660.0
2008-04-21 13:30:00	SPY	ETF	138.48	138.49	138.15	138.26	7516881.0
2008-04-21 14:00:00	SPY	ETF	138.25	138.36	138.13	138.23	4422972.0
2008-04-21 14:30:00	SPY	ETF	138.23	138.57	138.16	138.5	6990552.0
2008-04-21 15:00:00	SPY	ETF	138.49	138.81	138.48	138.72	9410772.0
2008-04-21 15:30:00	SPY	ETF	138.71	138.98	138.61	138.79	11096455.0
2008-04-21 16:00:00	SPY	ETF	138.79	138.81	138.5	138.5	2696364.0
2008-04-21 16:30:00	SPY	ETF	138.6	138.79	138.34	138.4	2221763.0
2008-04-21 17:00:00	SPY	ETF	138.42	138.42	138.23	138.25	119731.0
2008-04-21 17:30:00	SPY	ETF	138.31	138.31	138.27	138.3	11757.0
2008-04-21 18:00:00	SPY	ETF	138.3	138.3	138.22	138.26	11600.0
2008-04-21 18:30:00	SPY	ETF	138.3	138.33	138.3	138.33	1200.0
2008-04-21 19:00:00	SPY	ETF	138.3	138.31	138.3	138.3	2300.0
2008-04-21 19:30:00	SPY	ETF	138.3	138.3	138.25	138.25	4700.0
2008-04-21 05:00:00	QQQ	ETF	46.64	46.66	46.64	46.66	9500.0
2008-04-21 06:00:00	QQQ	ETF	46.57	46.57	46.57	46.57	1000.0
2008-04-21 06:30:00	QQQ	ETF	46.59	46.59	46.51	46.52	4300.0
2008-04-21 07:00:00	QQQ	ETF	46.53	46.54	46.44	46.52	121660.0
2008-04-21 07:30:00	QQQ	ETF	46.52	46.61	46.48	46.58	266459.0
2008-04-21 08:00:00	QQQ	ETF	46.59	46.83	46.56	46.58	305242.0
2008-04-21 08:30:00	QQQ	ETF	46.57	46.59	46.56	46.58	209523.0
2008-04-21 09:00:00	QQQ	ETF	46.57	46.6	46.52	46.6	689559.0
2008-04-21 09:30:00	QQQ	ETF	46.61	46.75	46.55	46.71	8472750.0
2008-04-21 10:00:00	QQQ	ETF	46.71	46.715	46.53	46.55	9579072.0
2008-04-21 10:30:00	QQQ	ETF	46.56	46.66	46.49	46.549	6350910.0
2008-04-21 11:00:00	QQQ	ETF	46.54	46.69	46.52	46.639	4187671.0
2008-04-21 11:30:00	QQQ	ETF	46.639	46.79	46.635	46.7519	6444736.0
2008-04-21 12:00:00	QQQ	ETF	46.76	46.83	46.73	46.79	3742321.0
2008-04-21 12:30:00	QQQ	ETF	46.79	46.81	46.73	46.78	2646405.0
2008-04-21 13:00:00	QQQ	ETF	46.79	46.9	46.79	46.81	4081045.0
2008-04-21 13:30:00	QQQ	ETF	46.8	46.82	46.67	46.74	4360201.0
2008-04-21 14:00:00	QQQ	ETF	46.73	46.76	46.66	46.72	2660788.0
2008-04-21 14:30:00	QQQ	ETF	46.72	46.96	46.7	46.91	5330171.0
2008-04-21 15:00:00	QQQ	ETF	46.9	47.07	46.9	47.0199	7825768.0
2008-04-21 15:30:00	QQQ	ETF	47.01	47.08	46.96	47.04	6120592.0
2008-04-21 16:00:00	QQQ	ETF	47.03	47.07	46.7628	47.0	2149395.0

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

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