PREVIEW / etf_30min / 2007-03-21

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-03-21.parquet
  size:    107 KB
  rows:    3,684

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-03-21 06:00:00	SPY	ETF	140.89	140.89	140.89	140.89	2000.0
2007-03-21 07:00:00	SPY	ETF	140.93	140.97	140.9	140.93	84000.0
2007-03-21 07:30:00	SPY	ETF	140.98	141.09	140.98	140.99	327100.0
2007-03-21 08:00:00	SPY	ETF	141.0	141.07	140.76	141.06	69700.0
2007-03-21 08:30:00	SPY	ETF	141.06	141.1	141.03	141.09	992900.0
2007-03-21 09:00:00	SPY	ETF	141.1	141.15	141.07	141.08	483200.0
2007-03-21 09:30:00	SPY	ETF	141.1	141.26	140.83	140.92	9565350.0
2007-03-21 10:00:00	SPY	ETF	140.91	141.08	140.82	141.06	4263748.0
2007-03-21 10:30:00	SPY	ETF	141.06	141.09	140.84	141.04	3295400.0
2007-03-21 11:00:00	SPY	ETF	141.04	141.08	140.92	141.02	1998500.0
2007-03-21 11:30:00	SPY	ETF	141.02	141.06	140.97	140.98	1424900.0
2007-03-21 12:00:00	SPY	ETF	140.98	141.05	140.97	141.05	718300.0
2007-03-21 12:30:00	SPY	ETF	141.05	141.17	141.0	141.14	4485800.0
2007-03-21 13:00:00	SPY	ETF	141.15	141.24	141.11	141.21	2954561.0
2007-03-21 13:30:00	SPY	ETF	141.21	141.34	141.18	141.25	4441300.0
2007-03-21 14:00:00	SPY	ETF	141.25	143.36	141.14	142.35	39141707.0
2007-03-21 14:30:00	SPY	ETF	142.35	143.46	142.3	143.4	24138700.0
2007-03-21 15:00:00	SPY	ETF	143.4	143.65	142.84	142.98	22892828.0
2007-03-21 15:30:00	SPY	ETF	142.98	143.44	142.8	143.3226	26732854.0
2007-03-21 16:00:00	SPY	ETF	143.35	143.35	143.1	143.22	1394700.0
2007-03-21 16:30:00	SPY	ETF	143.22	143.22	143.04	143.15	670700.0
2007-03-21 17:00:00	SPY	ETF	143.13	143.17	143.11	143.12	180000.0
2007-03-21 17:30:00	SPY	ETF	143.11	143.19	143.11	143.11	116600.0
2007-03-21 18:00:00	SPY	ETF	143.09	143.36	143.05	143.1	806500.0
2007-03-21 18:30:00	SPY	ETF	143.09	143.12	143.07	143.07	18600.0
2007-03-21 19:00:00	SPY	ETF	143.1	143.11	143.04	143.06	85300.0
2007-03-21 19:30:00	SPY	ETF	143.08	143.09	143.03	143.04	40600.0
2007-03-21 07:00:00	QQQ	ETF	43.62	43.64	43.62	43.63	28166.0
2007-03-21 07:30:00	QQQ	ETF	43.63	43.71	43.63	43.67	346502.0
2007-03-21 08:00:00	QQQ	ETF	43.67	43.68	43.65	43.68	581014.0
2007-03-21 08:30:00	QQQ	ETF	43.68	43.69	43.64	43.69	1305355.0
2007-03-21 09:00:00	QQQ	ETF	43.68	43.69	43.64	43.64	542167.0
2007-03-21 09:30:00	QQQ	ETF	43.64	43.66	43.35	43.41	28847900.0
2007-03-21 10:00:00	QQQ	ETF	43.4	43.47	43.35	43.45	5911000.0
2007-03-21 10:30:00	QQQ	ETF	43.45	43.47	43.36	43.45	3353400.0
2007-03-21 11:00:00	QQQ	ETF	43.44	43.47	43.4	43.45	2203500.0
2007-03-21 11:30:00	QQQ	ETF	43.45	43.47	43.41	43.42	1280300.0
2007-03-21 12:00:00	QQQ	ETF	43.42	43.45	43.42	43.43	963400.0
2007-03-21 12:30:00	QQQ	ETF	43.44	43.49	43.42	43.48	1708000.0
2007-03-21 13:00:00	QQQ	ETF	43.48	43.56	43.47	43.55	2764600.0
2007-03-21 13:30:00	QQQ	ETF	43.55	43.56	43.5	43.52	3755500.0
2007-03-21 14:00:00	QQQ	ETF	43.52	43.9	43.46	43.81	38355500.0
2007-03-21 14:30:00	QQQ	ETF	43.81	44.3	43.75	44.28	28444100.0
2007-03-21 15:00:00	QQQ	ETF	44.28	44.4	43.8	44.1	21803700.0
2007-03-21 15:30:00	QQQ	ETF	44.1	44.43	44.1	44.43	22396000.0
2007-03-21 16:00:00	QQQ	ETF	44.43	44.43	44.34	44.4	5579322.0
2007-03-21 16:30:00	QQQ	ETF	44.38	44.38	44.31	44.36	1393335.0
2007-03-21 17:00:00	QQQ	ETF	44.35	44.38	44.34	44.38	121523.0
2007-03-21 17:30:00	QQQ	ETF	44.36	44.42	44.35	44.4	325690.0
2007-03-21 18:00:00	QQQ	ETF	44.39	44.46	44.34	44.34	225577.0

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

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