PREVIEW / etf_30min / 2007-05-14

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-14.parquet
  size:    108 KB
  rows:    3,903

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-14 04:00:00	SPY	ETF	151.01	151.01	151.01	151.01	100.0
2007-05-14 05:00:00	SPY	ETF	150.88	150.88	150.84	150.84	200.0
2007-05-14 06:00:00	SPY	ETF	150.87	150.87	150.87	150.87	2000.0
2007-05-14 06:30:00	SPY	ETF	150.83	150.83	150.74	150.82	13000.0
2007-05-14 07:00:00	SPY	ETF	150.84	150.84	150.72	150.72	184800.0
2007-05-14 07:30:00	SPY	ETF	150.74	150.77	150.72	150.77	52200.0
2007-05-14 08:00:00	SPY	ETF	150.77	150.91	150.76	150.89	110500.0
2007-05-14 08:30:00	SPY	ETF	150.89	150.94	150.86	150.93	712700.0
2007-05-14 09:00:00	SPY	ETF	150.93	150.98	150.86	150.86	231300.0
2007-05-14 09:30:00	SPY	ETF	150.86	151.3	150.83	151.12	9158360.0
2007-05-14 10:00:00	SPY	ETF	151.115	151.115	150.65	150.72	15538803.0
2007-05-14 10:30:00	SPY	ETF	150.71	150.99	150.67	150.89	11994439.0
2007-05-14 11:00:00	SPY	ETF	150.88	150.89	150.66	150.72	7575335.0
2007-05-14 11:30:00	SPY	ETF	150.71	150.85	150.68	150.78	2867100.0
2007-05-14 12:00:00	SPY	ETF	150.77	150.93	150.76	150.78	4695727.0
2007-05-14 12:30:00	SPY	ETF	150.78	150.92	150.77	150.89	1295920.0
2007-05-14 13:00:00	SPY	ETF	150.89	150.9	150.65	150.77	5423398.0
2007-05-14 13:30:00	SPY	ETF	150.77	150.82	150.32	150.36	11828523.0
2007-05-14 14:00:00	SPY	ETF	150.35	150.35	149.79	150.3	13737083.0
2007-05-14 14:30:00	SPY	ETF	150.3	150.37	150.12	150.2	6602300.0
2007-05-14 15:00:00	SPY	ETF	150.2	150.51	150.16	150.36	5098943.0
2007-05-14 15:30:00	SPY	ETF	150.36	150.55	150.31	150.55	8332070.0
2007-05-14 16:00:00	SPY	ETF	150.54	150.58	150.18	150.51	1181800.0
2007-05-14 16:30:00	SPY	ETF	150.48	150.5	150.42	150.49	586300.0
2007-05-14 17:00:00	SPY	ETF	150.45	150.45	150.33	150.33	16400.0
2007-05-14 17:30:00	SPY	ETF	150.35	150.35	150.34	150.35	1400.0
2007-05-14 18:00:00	SPY	ETF	150.38	150.4	150.37	150.38	14900.0
2007-05-14 18:30:00	SPY	ETF	150.39	150.4	150.38	150.38	3200.0
2007-05-14 19:30:00	SPY	ETF	150.39	150.4	150.37	150.37	2400.0
2007-05-14 07:00:00	QQQ	ETF	46.77	46.78	46.75	46.75	15700.0
2007-05-14 07:30:00	QQQ	ETF	46.75	46.75	46.75	46.75	14000.0
2007-05-14 08:00:00	QQQ	ETF	46.76	46.8	46.75	46.8	119635.0
2007-05-14 08:30:00	QQQ	ETF	46.79	46.88	46.79	46.84	1980122.0
2007-05-14 09:00:00	QQQ	ETF	46.84	46.85	46.78	46.78	297331.0
2007-05-14 09:30:00	QQQ	ETF	46.77	46.88	46.77	46.79	9332102.0
2007-05-14 10:00:00	QQQ	ETF	46.79	46.79	46.53	46.56	17282340.0
2007-05-14 10:30:00	QQQ	ETF	46.56	46.69	46.54	46.64	8814557.0
2007-05-14 11:00:00	QQQ	ETF	46.64	46.65	46.5	46.54	6235240.0
2007-05-14 11:30:00	QQQ	ETF	46.54	46.62	46.53	46.56	4525646.0
2007-05-14 12:00:00	QQQ	ETF	46.55	46.62	46.51	46.52	2785431.0
2007-05-14 12:30:00	QQQ	ETF	46.52	46.59	46.52	46.58	1572591.0
2007-05-14 13:00:00	QQQ	ETF	46.58	46.58	46.44	46.4874	5068918.0
2007-05-14 13:30:00	QQQ	ETF	46.48	46.51	46.33	46.34	11052324.0
2007-05-14 14:00:00	QQQ	ETF	46.33	46.34	46.19	46.31	13696316.0
2007-05-14 14:30:00	QQQ	ETF	46.31	46.35	46.26	46.28	6035949.0
2007-05-14 15:00:00	QQQ	ETF	46.28	46.43	46.27	46.36	8744471.0
2007-05-14 15:30:00	QQQ	ETF	46.367	46.45	46.36	46.45	11387222.0
2007-05-14 16:00:00	QQQ	ETF	46.45	46.46	46.4	46.4	2398170.0
2007-05-14 16:30:00	QQQ	ETF	46.4	46.46	46.37	46.39	1647441.0
2007-05-14 17:00:00	QQQ	ETF	46.39	46.41	46.35	46.37	51152.0

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

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